What Is A Database
  • Material For Section 1
  • Full SQL DB Schema Is Avaialbe On This Link
  • What Is A Database
  • What Is A Table
  • section 1 quiz
Designing Your First Database
  • Course Slides and Material For Designing Your Database
  • Get To Know PHP MyAdmin
  • Designing Your First MySQL Database Creating Our First Table
  • Getting Into More Detail About Tables
  • Section 2 quiz
Keys Both Primary and Foreign
  • Course Slides and Material For Primary and Foreign Keys
  • Keys Both Primary and Foreign in MySQL
  • Section 3 quiz
The Select Statment in MySQL
  • Course Slides and Material For The Select Statement in MySQL
  • The Anatomy of the Select
  • Excercise on Select Statement
  • Answers to the Excercise
  • More Great Examples Of Select Concat and Addition etc..
  • Useful Queries from this section
  • Section 4 quiz
The Order By and A Deep Dive Into The Where Clause
  • Course Slides and Material For Order By And Where Clause Lectures
  • The Order By Clause Almost As Cool As Santa
  • Deep Dive Into The Where Clause
  • Group By The Power in Grouping Your Analytics
  • Useful SQL Statements for this section
  • Section 5 quiz
Analytics With the Group By Feature
  • Course Slides and Material For Analytics And The Group By Feature
  • Analytics 101
  • Useful Sql Statments For Group By and Analytics
  • Section 6 Quiz
Sub Queries
  • Course Slides and Material For Sub-Queries
  • Sub-queries
  • Useful Subquery Sql Statements
  • Section 7 Quiz
Joins In MySQL
  • Course Slides and Material For Joins
  • Inner Joins
  • Useful Inner Join SQL Statements
  • Left Outer Joins
  • Useful Left Outer Join SQL Statements
  • Section 8 Quiz
Installing MySQL Locally
  • Link to MySQL
  • Installing MySQL Locally And Exporting Your Database From PHP My Admin
  • Importing Our Exported Data
Creating Our First Views And Stored Procedures
  • Creating Our First View
  • Code: Creating Our First View
  • Creating Our First Stored Procedures
  • Code: Creating Our First Stored Procedures
  • Basic Scalar UDF
  • Section 10 quiz
Inserts Updates and Deletes
  • Insert Statements
  • Code: For Insert Statemetns
  • Update Statements
  • Code: For Update Statements
  • Code For Delete Statements
  • Delete Statements
  • Section 11 quiz