MySQL Database Training for Beginners

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Outline and Intro to MySQL and Database

Lecture 2: READ ME: Essential Information for a Successful Training Experience

Lecture 3: MySQL Architecture and Installation of MySQL

Lecture 4: Installation Demo – Part 1

Lecture 5: Installation Demo – Part 2

Chapter 2: Database Design

Lecture 1: Database Design

Lecture 2: MySQL Workbench Download

Lecture 3: Database Table and Constraints

Lecture 4: Database Designing and Normalization – Part 1

Lecture 5: Database Designing and Normalization – Part 2

Lecture 6: Storage and Data Types

Lecture 7: Data Types Demo

Lecture 8: ACID and Transactions

Lecture 9: Locks, Deadlocks, Isolation Levels and Logging

Lecture 10: Isolation Levels and Locking Demo

Lecture 11: Locking Mechanism Demo and MySQL ACID Support

Chapter 3: Administration

Lecture 1: Responsibilities of a Database Administrator

Lecture 2: Creating a User and Limiting Access to a Database; Basic Maintainance Function

Lecture 3: Protecting your Database; How to Perform Database Backup

Lecture 4: Performance Monitoring

Chapter 4: Indexing for Performance

Lecture 1: Course Review

Lecture 2: InnoDB Indexing and Clustered vs. Unclustered Index

Lecture 3: Query and Where Clause

Lecture 4: Impact of Indexing on Database Performance

Lecture 5: Performance Optimization

Chapter 5: SQL for Developers

Lecture 1: Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers

Lecture 2: Data Definition Language; How to Create Database Objects

Lecture 3: SQL Select Statements

Lecture 4: SQL Select Statements Demo

Lecture 5: Joins

Lecture 6: Combining Related Table Using Joins

Lecture 7: Insert, Update and Delete Commands

Lecture 8: Insert, Update, and Delete Commands Demo

Chapter 6: Query Analysis and Optimization

Lecture 1: Query Optimization

Lecture 2: Query Optimization Demo

Chapter 7: Data Replication

Lecture 1: Database Replication

Lecture 2: Setting Up Replication in MySQL

Lecture 3: Data Encryption

Lecture 4: Column-Level Database Encryption Demo

Lecture 5: High Availability

Chapter 8: Conclusion

Lecture 1: Closing