Virtual T-SQL Boot Camp
- Start: Mar 17, 2025 9:00 AM EDT
- End: Mar 19, 2025 5:00 PM EDT
- Cost: $1,995.00
- Instructor: Zane Goodman
- Event Categories:
- Available Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
- Need help convincing your boss? We can help.
Event description
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
- SQL Server Management Studio (SSMS)
- Navigating in Management Studio
- Module 02 – Writing SELECT Statement
- Returning Columns
- Module 03 – Writing Queries with Filters
- Filtering with WHERE
- Module 04 – Expressions
- Exploring Commonly used Expression
- Module 05 – Writing More Complex WHERE Clauses
- Exploring Different Filter Criteria Options
- Module 06 – Using a Sub-Query to Filter Data
- Returning Subsets of Data with Sub-Queries
- Module 07 – Joining Tables
- Understanding INNER JOIN
- Module 08 – OUTER JOINs
- Understanding and Writing OUTER JOINs
- Module 09 – Writing Queries with Virtual Tables
- Understanding UNION
- Working with CTEs
- Module 10 – Aggregate Queries
- Working with COUNT
- Understanding SUM
- Using GROUP BY
- Filtering with HAVING
- Module 11 – Exploring Windows Function
- Windows Function Ranking
- Aggregate Windows Functions
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual T-SQL Boot Camp (Mar 17, 2025 – 3/19/25) | $1,995.00 | |
Add an event to your calendar
Instructor – Zane Goodman
Zane Goodman is a Trainer for Pragmatic Works specializing in the Power Platform. He's worked in skilled labor roles as well as the construction industry. Zane spent a lot of time in attics, on boom lifts, and in ditches making sure all the lights turned on properly. Now his primary focus is turning on the light for learning, helping our customers learn the ins and outs of Power Apps.