SQL: SQL Superpowers

Course 2: Are you ready to unlock SQL's true potential? Learn a few simple techniques to distill complex, time-consuming transformations into one line of code. It's that simple! You'll also learn how to save time and money with optimization tips.

Buy $199.00

Course curriculum

1. Course interaction
2. Introduction
1. Pre-course survey
1. Supplemental slides
2. Supplemental files
3. Database file
1. Chapter preview
2. Install SQL Server
3. Restore database
4. IDE (Part 1)
5. IDE (Part 2)
6. IDE (Part 3)
1. Chapter preview
2. 01 - Union and union all
3. 02 - Introduction to Subqueries
4. 03 - Window function basics
5. 04 - Applying window functions
6. 05 - Exercise 1
7. 06 - Subqueries (Part 1)
8. 07 - Subqueries (Part 2)
1. Chapter preview
2. 08 - Lower and upper bound joins
3. 09 - Data types and joins (date)
4. 10 - Data types and joins (string)
1. Chapter preview
2. 11 - Introduction to temporary (temp) tables
3. 12 - Temp table setup
4. 13 - Using temp tables (self-join)
5. 14 - Common table expression (CTE)
6. 15 - Variables
7. 16 - Exercise 2
1. Chapter preview
2. 17 - Window functions revisited
3. 18 - Group by options
1. Chapter preview
2. 19 - Pivot (Part 1) - Pivot
3. 20 - Pivot (Part 2) - Pivot with case statement
4. 21 - Pivot (Part 3) - Unpivot for more columns
5. 22 - Pivot (Part 4) - Dynamically create SQL
6. 23 - Case statement tips
1. Chapter preview
2. 24 - Why it matters
3. 25 - Indexing
4. 26 - Execution plans
5. 27 - Tips to consider
6. 28 - Exercise 3
1. Post-course survey

About this course

47 lessons
4.0 hours of high-quality video
Supplemental files and slides

SQL: SQL Superpowers

Course curriculum

Introduction

Pre-course survey

Materials

Installation and Orientation

Union, Subqueries, and Window Functions

Data Types and Joins

Tables and Variables

More Window Functions and Group By

Pivot, Unpivot, and Case Statements

Optimization

Post-course survey

About this course