Course structure and outline

Introducing the course project

Setting expectations

Prerequisite skills review

MySQL installation overview

Mac download Community Server

Mac download MySQL Workbench

PC Download Community Server plus Workbench

Connecting Workbench to the server

MySQL Workbench interface

Preparing Workbench

Overview of create, insert, and delete

Review Creating a schema

Review Creating a table

Review Inserting records into a table

Review Deleting records

Importing data from a file

Challenge Importing order item data

Solution Importing order item data

Challenge Importing refund data

Solution Importing refund data

Challenge Deleting records

Solution Deleting records

Challenge Import remaining 2012 data

Solution Import remaining 2012 data

Bonus Load data

Overview of alter, update, and key relationships

Review Altering tables

Review Updating records

Review Table relationships and cardinality

Challenge Introducing a new product

Solution Introducing a new product

Challenge Adding a product to order items

Solution Adding a product to order items

Challenge Updating product data in order items

Solution Updating product data in order items

Challenge Primary key to foreign key mapping

Solution Primary key to foreign key mapping

Challenge Import 2013 Q1 data

Replication

Backup and recovery

Challenge Backup and recovery

Solution Backup and recovery

Challenge Mid-course project

Solution Mid-course project

Review Triggers basics

Triggers deep dive

Challenge Creating and updating orders

Solution Creating and updating orders

Challenge Triggers

Solution Triggers

Challenge Testing your trigger system

Solution Testing your trigger system

Views

Challenge Creating website sessions

Solution Creating website sessions

Challenge Creating views

Solution Creating views

Review The EER diagram editor

Reverse engineering EER diagrams

Challenge The EER diagram editor

Solution The EER diagram editor

Stored procedures

Scheduled events

Challenge Stored procedures

Solution Stored procedures

Writing data from website activity

Challenge Writing data from website activity

Solution Writing data from website activity

Challenge Importing website pageview data

Solution Importing website pageview data

Security threats

Security best practices

Challenge Database security

Solution Database security

Challenge Final project

Solution Final project