• Course Structure & Outline Free
  • Introducing The Course Project Free
  • Setting Expectations Free

  • Benchmark Assessment Free

  • Introduction to SQL Free
  • Relational Databases Free
  • Relational Database Management Systems Free
  • QUIZ: SQL & Relational Database Overview Free

  • MySQL Installation Overview Free
  • Mac Download Community Server Free
  • Mac Download MySQL Workbench Free
  • PC: Download Community Server & Workbench Free
  • Connecting Workbench to the Server Free
  • MySQL Workbench Interface Pro
  • Creating the Initial Schemas Pro

  • Creating a Schema Using the MySQL Workbench UI Pro
  • Creating a Schema Using SQL Code Pro
  • Creating a Table Using the MySQL Workbench UI Pro
  • Creating a Table Using SQL Code Pro
  • MySQL Data Types Pro
  • ASSIGNMENT: Creating Your Own Schema & Tables Pro
  • SOLUTION: Creating Your Own Schema & Tables Pro
  • Adding & Removing Columns Using the MySQL Workbench UI Pro
  • Adding & Removing Columns With SQL Code Pro
  • ASSIGNMENT: Adding & Removing Columns Pro
  • SOLUTION: Adding & Removing Columns Pro
  • Dropping Schemas & Tables Pro
  • ASSIGNMENT: Dropping Schemas & Tables Pro
  • SOLUTION: Dropping Schemas & Tables Pro
  • QUIZ: Creating and Altering Schemas & Tables Pro

  • Inserting Records Into Tables Pro
  • Updating Data Records Pro
  • ASSIGNMENT: Inserting & Updating Records Pro
  • SOLUTION: Inserting & Updating Records Pro
  • Deleting Specific Records Pro
  • Deleting All Records with TRUNCATE Pro
  • ASSIGNMENT: Deleting Records Pro
  • SOLUTION: Deleting Records Pro
  • QUIZ: Inserting, Updating & Deleting Records Pro

  • Primary Keys & Foreign Keys Pro
  • Primary Keys & Foreign Keys Demo Pro
  • ASSIGNMENT: Table Relationships Pro
  • SOLUTION: Table Relationships Pro
  • Database Normalization Pro
  • Database Normalization Demo Pro
  • ASSIGNMENT: Normalization Pro
  • SOLUTION: Normalization Pro
  • The EER Diagram Editor Pro
  • ASSIGNMENT: EER Diagram Editor Pro
  • SOLUTION: EER Diagram Editor Pro
  • QUIZ: Database Design Pro

  • ASSIGNMENT: Mid-Course Project Pro
  • SOLUTION: Mid-Course Project Pro

  • Creating An Index Pro
  • The Unique Constraint Pro
  • The Non Null Constraint Pro
  • ASSIGNMENT: Indexes & Constraints Pro
  • SOLUTION: Indexes & Constraints Pro
  • Stored Procedures Pro
  • ASSIGNMENT: Stored Procedures Pro
  • SOLUTION: Stored Procedures Pro
  • Triggers Pro
  • ASSIGNMENT: Triggers Pro
  • SOLUTION: Triggers Pro
  • QUIZ: Advanced Concepts Pro

  • Server Management Pro
  • ASSIGNMENT: Server Management Pro
  • SOLUTION: Server Management Pro
  • Managing Users & Permissions Pro
  • ASSIGNMENT: Managing Users & Permissions Pro
  • SOLUTION: Managing Users & Permissions Pro
  • QUIZ: Server & User Management Pro

  • ASSIGNMENT: Final Project Pro
  • SOLUTION: Final Project Pro

  • Final Assessment Pro

  • Course Feedback Survey Pro
  • Share the Love! Pro
  • Next Steps Pro