SQL Database MasterClass: Go From Pupil To Master!

Course Curriculum

Chapter 1: Intro

Lecture 1: Intro to SQL a 101 Guide to Designing and Building Your First Database

Lecture 2: Hit the High Def Button Please

Chapter 2: Lets Recreate a Database Like Udemy's Database

Lecture 1: Lets Talk About Tables And How They Are Used In SQL

Lecture 2: What Would This Database Need If We Were Recreating Udemy?

Lecture 3: Person Table

Chapter 3: Keys Both Primary and Foreign

Lecture 1: How to Create Keys In SQL And Why

Lecture 2: Look What Keys Buy You

Chapter 4: Lets Fill In Our Datapoints

Lecture 1: Adding Data To Your Database

Chapter 5: THe Select

Lecture 1: Select Statement In SQL

Lecture 2: The Anatomy of the Select Statement in SQL

Lecture 3: Select Exercises to Help You Learn SQL Faster

Lecture 4: What Else Can You Do WIth The Select

Lecture 5: Lets Talk About The Order By Clause In SQL

Lecture 6: Where Clause Deep Dive

Lecture 7: Lets Discuss The Like and the In Statements

Lecture 8: Basic Database Analytics – Introducing Aggregate Functions

Lecture 9: More Complex Analytics: Group By Clause

Chapter 6: Sub-queries

Lecture 1: What Is A Subquery

Chapter 7: Course Slides and Material Up To Here

Lecture 1: Course Slides and Material Up To Now

Chapter 8: Joins

Lecture 1: Inner Join

Lecture 2: Left Outer Join

Chapter 9: User Defined Functions

Lecture 1: Introduction to User Defined Functions

Lecture 2: Scalar Functions

Lecture 3: Scalar Functions SQL Statments

Lecture 4: Table Functions

Lecture 5: Table Functions SQL Statements

Chapter 10: The View

Lecture 1: Lets Talk About Views

Lecture 2: View SQL Statements

Chapter 11: Stored Procedures The V8 of the SQL World

Lecture 1: Our First Stored Procedure

Lecture 2: Stored Proc SQL Statments

Chapter 12: Insert Update Delete The Fabulous 3

Lecture 1: Insert Statements in SQL

Lecture 2: Update Statements in SQL

Lecture 3: SQL Delete Statement

Lecture 4: SQL for this section

Chapter 13: Getting Real Deep In SQL

Lecture 1: Adding Random Data To Play With

Lecture 2: Statements for the Random Data

Lecture 3: Adding More Random Data

Chapter 14: Introducing the Pivot

Lecture 1: Intro to Pivot and Unpivot

Lecture 2: Our First Example Of A Pivot

Lecture 3: Code For Pivot Lecture

Chapter 15: Trouble Shooting and Optimizing Your Database

Lecture 1: A Intro To SQL Profiler

Lecture 2: A How To On Optimizing Our Datbase

Lecture 3: Adding Our First Indexes To Our Database

Lecture 4: Create a Script to Index All Foreign Keys

Lecture 5: Useful Queries For Building The Script To Index All Foreign Keys

Chapter 16: SQL Server Reporting Services (SSRS)

Lecture 1: Installing SQL Report Builder 3.0

Lecture 2: A Very Basic SSRS Report

Chapter 17: Random Tips That Make Life Easier

Lecture 1: How To Use Templates For Quick Access To SQL

Lecture 2: Whole DB as Text File