SQL
22 videos • 32,009 views • by James Oliver
1
Advanced SQL Tutorial
James Oliver
Download
2
Master SQL like a Pro in 20 Minutes
James Oliver
Download
3
Expert Level SQL Tutorial
James Oliver
Download
4
Stop Using Inner Joins!
James Oliver
Download
5
Handling Deadlocks with T-SQL
James Oliver
Download
6
Dynamic SQL with Parameters
James Oliver
Download
7
JSON and SQL Tutorial - Convert a table to JSON and JSON to table
James Oliver
Download
8
Full outer joins don't get enough love
James Oliver
Download
9
What is a Data Lake?
James Oliver
Download
10
Building an Enterprise Data Warehouse
James Oliver
Download
11
SQL Unpivot and more
James Oliver
Download
12
SQL - Merge
James Oliver
Download
13
SQL Cursors - how and when to use them
James Oliver
Download
14
SQL Performance Tips
James Oliver
Download
15
Database Triggers - React to Table Changes
James Oliver
Download
16
Data Warehousing for Starters
James Oliver
Download
17
SubTotals with SQL using ROLLUP
James Oliver
Download
18
Cross & Outer Apply
James Oliver
Download
19
Install High-Performance SQL Servers
James Oliver
Download
20
Tips for dealing with SQL Server constraints
James Oliver
Download
21
Server aliases - why you need them
James Oliver
Download
22
Discussing my favorite SQL join with an AI
James Oliver
Download