SQL Database MasterClass Go From Pupil To Master

2016
4:54 hours

├── 01 – Intro
│ └── 1 Intro to SQL a 101 Guide to Designing and Building Your First Database.mp4
├── 02 – Lets Recreate a Database Like Udemy’s Database
│ ├── 1 Lets Talk About Tables And How They Are Used In SQL.mp4
│ ├── 2 What Would This Database Need If We Were Recreating Udemy.mp4
│ └── 3 Person Table.mp4
├── 03 – Keys Both Primary and Foreign
│ ├── 1How to Create Keys In SQL And Why.mp4
│ └── 2 What Keys Buy You.mp4
├── 04 – Lets Fill In Our Datapoints
│ └── 1 Adding Data To Your Database.mp4
├── 05 – THe Select
│ ├── 1 Select Statement In SQL.mp4
│ ├── 2 The Anatomy of the Select Statement in SQL.mp4
│ ├── 3 Select Exercises to Help You Learn SQL Faster.mp4
│ ├── 4 What Else Can You Do WIth The Select.mp4
│ ├── 5 Lets Talk About The Order By Clause In SQL.mp4
│ ├── 6 Where Clause Deep Dive.mp4
│ ├── 7 Lets Discuss The Like and the In Statements.mp4
│ ├── 8 Basic Database Analytics – Introducing Aggregate Functions.mp4
│ └── 9 More Complex Analytics – Group By Clause.mp4
├── 06 – Sub-queries
│ └── 1 What Is A Subquery.mp4
├── 08 – Joins
│ ├── 1 Inner Join.mp4
│ └── 2 Left Outer Join.mp4
├── 09 – User Defined Functions
│ ├── 1 Introduction to User Defined Functions.mp4
│ ├── 2 Scalar Functions.mp4
│ ├── 3.txt
│ ├── 4 Table Functions.mp4
│ └── 5.txt
├── 10 – The View
│ ├── 1 Lets Talk About Views.mp4
│ └── 2.txt
├── 11 – Stored Procedures The V8 of the SQL World
│ ├── 1 Our First Stored Procedure.mp4
│ └── 2.txt
├── 12 – Insert Update Delete The Fabulous 3
│ ├── 1 Insert Statements in SQL.mp4
│ ├── 2 Update Statements in SQL.mp4
│ ├── 3 SQL Delete Statement.mp4
│ └── 4.txt
├── 13 – Getting Real Deep In SQL
│ ├── 1 Adding Random Data To Play With.mp4
│ ├── 2.txt
│ └── 3 Adding More Random Data.mp4
├── 14 – Introducing the Pivot
│ ├── 1 Intro to Pivot and Unpivot.mp4
│ ├── 2 Our First Example Of A Pivot.mp4
│ └── 3.txt
├── 15 – Trouble Shooting and Optimizing Your Database
│ ├── 1 A Intro To SQL Profiler.mp4
│ ├── 2 A How To On Optimizing Our Datbase.mp4
│ ├── 3 Adding Our First Indexes To Our Database.mp4
│ ├── 4 Create a Script to Index All Foreign Keys.mp4
│ └── 5.txt
├── 16 – SQL Server Reporting Services (SSRS)
│ ├── 1 A Very Basic SSRS Report.mp4
│ └── 2 Installing SQL Report Builder 3.0.mp4
└── 17 – Random Tips That Make Life Easier
├── 1 How To Use Templates For Quick Access To SQL.mp4
└── 2.txt