Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Database MasterClass: Go from Pupil to Master
Introduction to SQL
Intro to SQL a 101 Guide to Designing and Building Your First Database (5:28)
Lets Recreate a Video Course Database
Lets Talk About Tables And How They Are Used In SQL (5:57)
What Would This Database Need If We Were Recreating A Video Course Site? (7:33)
Lets Make The Person Table (15:04)
Primary and Foreign Keys
How to Create Keys In SQL And Why (10:18)
Look What Keys Buy You (1:50)
Lets Fill In Our Datapoints
Adding Data To Your Database (11:35)
The Select
Select Statement In SQL (10:13)
The Anatomy of the Select Statement in SQL (3:45)
Select Exercises to Help You Learn SQL Faster (3:50)
What Else Can You Do WIth The Select (17:05)
Lets Talk About The Order By Clause In SQL (6:54)
Lets Talk About The Order By Clause In SQL (7:15)
Lets Discuss The Like and the In Statements (8:02)
Basic Database Analytics - Introducing Aggregate Functions (11:25)
More Complex Analytics: Group By Clause (7:48)
Sub-Queries
What Is A Subquery
Joins In SQL
The Beauty That Is Inner Joins (15:33)
Left Outer Joins The Tool That Saves (7:27)
User Defined Functions
Introduction to User Defined Functions (2:06)
Scalar Function (10:22)
Table Functions (4:52)
The View
Lets Talk About Views (5:24)
Stored Procedures The V8 of the SQL World
Our First Stored Procedure (6:39)
Insert Update Delete Statements in SQL
Insert Statements in SQL (7:59)
Update Statements in SQL (5:47)
SQL Delete Statement (6:54)
Getting Real Deep in SQL
Adding Random Data To Play With (7:56)
Introducing the Pivot
Intro to Pivot and Unpivot (2:21)
Our First Example Of A Pivot (6:34)
Trouble Shooting and Optimizing Your Database
A Intro To SQL Profiler (7:25)
A How To On Optimizing Our Datbase (4:21)
Adding Our First Indexes To Our Database (9:40)
Create a Script to Index All Foreign Keys (25:41)
SQL Server Reporting Services SSRS
Installing SQL Report Builder 3.0 (1:52)
A Very Basic SSRS Report (2:44)
Random Tips That Make Life Easier
How To Use Templates For Quick Access To SQL (2:33)
Adding Random Data To Play With
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock