Download Advanced MySQL Database Administration Course for Free

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

Solution Import 2013 Q1 data