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

  • Prerequisite Skills Review Free
  • QUIZ: Prerequisite Skills 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 Free
  • Preparing Workbench Free

  • Overview of Create, Insert & Delete Free
  • REVIEW: Creating a Schema Free
  • REVIEW: Creating a Table Pro
  • REVIEW: Inserting Records into a Table Pro
  • REVIEW: Deleting Records Pro
  • Importing Data from a File Pro
  • ASSIGNMENT: Importing Order Item Data Pro
  • SOLUTION: Importing Order Item Data Pro
  • ASSIGNMENT: Importing Refund Data Pro
  • SOLUTION: Importing Refund Data Pro
  • ASSIGNMENT: Deleting Records Pro
  • SOLUTION: Deleting Records Pro
  • ASSIGNMENT: Importing Remaining 2012 Data Pro
  • SOLUTION: Importing Remaining 2012 Data Pro
  • BONUS: Load Data Pro
  • QUIZ: Importing Data Files to the Database Pro

  • Overview of Alter, Update & Key Relationships Pro
  • REVIEW: Altering Tables Pro
  • REVIEW: Updating Records Pro
  • REVIEW: Table Relationships & Cardinality Pro
  • ASSIGNMENT: Introducing a New Product Pro
  • SOLUTION: Introducing a New Product Pro
  • ASSIGNMENT: Adding Product to Order Items Pro
  • SOLUTION: Adding Product to Order Items Pro
  • ASSIGNMENT: Updating Product Data in Order Items Pro
  • SOLUTION: Updating Product Data in Order items Pro
  • ASSIGNMENT: Primary Key to Foreign Key Mapping Pro
  • SOLUTION: Primary Key to Foreign Key Mapping Pro
  • ASSIGNMENT: Importing 2013 Q1 Data Pro
  • SOLUTION: Importing 2013 Q1 Data Pro
  • QUIZ: Altering, Updating & Mapping Keys Pro

  • Replication Pro
  • Backup & Recovery Pro
  • ASSIGNMENT: Backup & Recovery Pro
  • SOLUTION: Backup & Recovery Pro
  • QUIZ: Replication, Backup & Recovery Pro

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

  • REVIEW: Triggers Basics Pro
  • Triggers Deep Dive Pro
  • ASSIGNMENT: Creating & Updating Orders Pro
  • SOLUTION: Creating & Updating Orders Pro
  • ASSIGNMENT: Triggers Pro
  • SOLUTION: Triggers Pro
  • ASSIGNMENT: Testing Your Trigger System Pro
  • SOLUTION: Testing Your Trigger System Pro
  • QUIZ: Trigger Automation Pro

  • Views Pro
  • ASSIGNMENT: Creating Website Sessions Pro
  • SOLUTION: Creating Website Sessions Pro
  • ASSIGNMENT: Creating Views Pro
  • SOLUTION: Creating Views Pro
  • QUIZ: Creating Views Pro

  • REVIEW: The EER Diagram Editor Pro
  • Reverse Engineering EER Diagrams Pro
  • ASSIGNMENT: The EER Diagram Editor Pro
  • SOLUTION: The EER Diagram Editor Pro
  • QUIZ: The EER Diagram Editor Pro

  • Stored Procedures Pro
  • Scheduled Events Pro
  • ASSIGNMENT: Stored Procedures Pro
  • SOLUTION: Stored Procedures Pro
  • QUIZ: Stored Procedures & Scheduled Events Pro

  • Writing Data from Website Activity Pro
  • ASSIGNMENT: Writing Data from Website Activity Pro
  • SOLUTION: Writing Data from Website Activity Pro
  • ASSIGNMENT: Importing Website Pageview Data Pro
  • SOLUTION: Importing Website Pageview Data Pro
  • QUIZ: Automating Data from Website Activity Pro

  • Security Threats Pro
  • Security Best Practices Pro
  • ASSIGNMENT: Database Security Pro
  • SOLUTION: Database Security Pro
  • QUIZ: Security Pro

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

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