Playlist

SQL, Second Step

Free4 videos, in order

SQL past the first query, in working order: Mirshafiei's pivot-table bridge into SELECT, Pragmatic Works' two T-SQL beginner lessons, and window functions as the capstone. Run the data problems on the practice floor after each step.

Every video plays through YouTube’s official embed player and belongs to the channel named on its row. Work down the list. The order is the curriculum.


1. Your First SQL Query (If You Already Know PivotTables)

EasyMohammad Mirshafiei

SQL introduced through the pivot table you already understand: SELECT, GROUP BY, and ORDER BY, with every number checked against the same table in Excel. The gentlest on-ramp to the next language on this shelf.

Open the watch page On YouTube Paired practice

2. T-SQL Tips and Tricks for Beginners

EasyPragmatic Works

T-SQL tips and tricks for beginners, part one: the small syntax and structure habits that make queries readable and correct. A working companion to the first-query lesson already on this shelf.

Open the watch page On YouTube Paired practice

3. T-SQL Tips and Tricks for Beginners Part 2

EasyPragmatic Works

Part two of Pragmatic Works' T-SQL beginner series, going further into the errors beginners make and the patterns that prevent them. Watch the pair together before a data exercise.

Open the watch page On YouTube Paired practice

4. Window Functions in SQL

MediumPragmatic Works

Window functions in SQL: ranking, running totals, and comparisons across rows without collapsing the table. The single largest step up from basic SELECT fluency, and the one data screens love.

Open the watch page On YouTube Paired practice

Finished the run?

Put the patterns to work while they are fresh. The playlist is the input. The practice floor is where it becomes a skill.

Go to the practice floor All playlists and shelves

Ready when you are.