[Udemy] SQL Database MasterClass: Go From Pupil To Master! [2016, ENG]

├── 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