MySQL Database MasterClass: Go From Pupil To Master!

Course Curriculum

Chapter 1: What Is A Database

Lecture 1: Material For Section 1

Lecture 2: Full SQL DB Schema Is Avaialbe On This Link

Lecture 3: What Is A Database

Lecture 4: What Is A Table

Chapter 2: Designing Your First Database

Lecture 1: Course Slides and Material For Designing Your Database

Lecture 2: Get To Know PHP MyAdmin

Lecture 3: Designing Your First MySQL Database Creating Our First Table

Lecture 4: Getting Into More Detail About Tables

Chapter 3: Keys Both Primary and Foreign

Lecture 1: Course Slides and Material For Primary and Foreign Keys

Lecture 2: Keys Both Primary and Foreign in MySQL

Chapter 4: The Select Statment in MySQL

Lecture 1: Course Slides and Material For The Select Statement in MySQL

Lecture 2: The Anatomy of the Select

Lecture 3: Excercise on Select Statement

Lecture 4: Answers to the Excercise

Lecture 5: More Great Examples Of Select Concat and Addition etc..

Lecture 6: Useful Queries from this section

Chapter 5: The Order By and A Deep Dive Into The Where Clause

Lecture 1: Course Slides and Material For Order By And Where Clause Lectures

Lecture 2: The Order By Clause Almost As Cool As Santa

Lecture 3: Deep Dive Into The Where Clause

Lecture 4: Group By The Power in Grouping Your Analytics

Lecture 5: Useful SQL Statements for this section

Chapter 6: Analytics With the Group By Feature

Lecture 1: Course Slides and Material For Analytics And The Group By Feature

Lecture 2: Analytics 101

Lecture 3: Useful Sql Statments For Group By and Analytics

Chapter 7: Sub Queries

Lecture 1: Course Slides and Material For Sub-Queries

Lecture 2: Sub-queries

Lecture 3: Useful Subquery Sql Statements

Chapter 8: Joins In MySQL

Lecture 1: Course Slides and Material For Joins

Lecture 2: Inner Joins

Lecture 3: Useful Inner Join SQL Statements

Lecture 4: Left Outer Joins

Lecture 5: Useful Left Outer Join SQL Statements

Chapter 9: Installing MySQL Locally

Lecture 1: Link to MySQL

Lecture 2: Installing MySQL Locally And Exporting Your Database From PHP My Admin

Lecture 3: Importing Our Exported Data

Chapter 10: Creating Our First Views And Stored Procedures

Lecture 1: Creating Our First View

Lecture 2: Code: Creating Our First View

Lecture 3: Creating Our First Stored Procedures

Lecture 4: Code: Creating Our First Stored Procedures

Lecture 5: Basic Scalar UDF

Chapter 11: Inserts Updates and Deletes

Lecture 1: Insert Statements

Lecture 2: Code: For Insert Statemetns

Lecture 3: Update Statements

Lecture 4: Code: For Update Statements

Lecture 5: Code For Delete Statements

Lecture 6: Delete Statements