NEED HELP? TALK TO AN EXPERT (904) 638-5743

Loading Events

« All Events

Virtual T-SQL Boot Camp (March 2023)

March 20, 2023 @ 9:00 am - March 23, 2023 @ 5:00 pm EDT

$1,596.00

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Virtual T-SQL Boot Camp Ticket March 2023
$ 1,995.00 $ 1,596.00

Boot Camp Details

The Introduction to T-SQL Boot Camp is an intensive course that is designed to get you authoring T-SQL queries very quickly. You will first learn about the structure of a SQL Server database, then you will dive right into learning how to query the tables for analytical purposes. Next, you will discover how to modify data, sort and filter the results, and write queries that involve multiple tables and summary queries. Finally, you will learn and understand the logical programming aspects of T-SQL.

Prerequisites

This class is targeted at developers, analysts or end-users looking to gain a better understanding of how to write T-SQL code. Previous SQL Server knowledge is not required, but students should have a basic understanding of database terminology such as tables, views, columns, rows, etc…

System Requirements

  • Windows 11, Windows 10, Windows 8, Windows 7
  • SQL Server Management Studio
  • AdeventureWorks2019 database (Included in class files)
  • AdventureWorksDW2019 database (Included in class files)

Course Outline:

  • Module 01 – Introduction to SQL Server Databases
  • Module 02 – SQL Server Management Studio (SSMS)
  • Module 03 – The SELECT Statement
  • Module 04 – Expressions
  • Module 05 – Indexes
  • Module 06 – The WHERE Clause
  • Module 07 – Complex WHERE Clauses
  • Module 08 – Using a Sub-Query to Filter Data
  • Module 09 – Joining Tables
  • Module 10 – Outer Joins
  • Module 11 – Other Query Patterns
  • Module 12 – Aggregate Queries
  • Module 13 – Modifying Data
  • Module 14 – T-SQL Programming

*Price is in USD and any discount applied is for new purchases only. Offers are subject to change with/without notice and are for a limited time only.”

Details

Start:
March 20, 2023 @ 9:00 am EDT
End:
March 23, 2023 @ 5:00 pm EDT
Cost:
$1,596.00
Event Category:

Organizer

Austin Libal