Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MySQL Database Training for Beginners
Introduction
Course Outline and Intro to MySQL and Database (10:11)
MySQL Architecture and Installation of MySQL (15:55)
Installation Demo - Part 1 (3:35)
Installation Demo - Part 2 (9:37)
Database Design
Database Design (8:46)
MySQL Workbench Download (7:34)
Database Table and Constraints (9:39)
Database Designing and Normalization - Part 1 (11:51)
Database Designing and Normalization - Part 2 (8:10)
Storage and Data Types (5:24)
Data Types Demo (11:20)
ACID and Transactions (9:43)
Locks, Deadlocks, Isolation Levels and Logging (7:16)
Isolation Levels and Locking Demo (12:43)
Locking Mechanism Demo and MySQL ACID Support (6:22)
Administration
Responsibilities of a Database Administrator (3:41)
Creating a User and Limiting Access to a Database; Basic Maintainance Function (10:34)
Protecting your Database; How to Perform Database Backup (7:44)
Performance Monitoring (10:49)
Indexing for Performance
InnoDB Indexing and Clustered vs. Unclustered Index (14:17)
Query and Where Clause (5:28)
Impact of Indexing on Database Performance (10:33)
Performance Optimization (7:49)
SQL for Developers
Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers (13:16)
Data Definition Language; How to Create Database Objects (12:27)
SQL Select Statements (7:48)
SQL Select Statements Demo (10:19)
Joins (5:36)
Combining Related Table Using Joins (16:06)
Insert, Update and Delete Commands (6:08)
Insert, Update, and Delete Commands Demo (8:47)
Query Analysis and Optimization
Query Optimization (3:40)
Query Optimization Demo (6:39)
Data Replication
Database Replication (6:38)
Setting Up Replication in MySQL (4:57)
Data Encryption (5:13)
Column-Level Database Encryption Demo (4:44)
High Availability (10:43)
Conclusion
Closing (4:08)
Course Quiz and Certificate of Completion
Installation Demo - Part 1
Complete and Continue