Completed
- Simon Sez IT Intro
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
MySQL Database Course for Beginners
Automatically move to the next video in the Classroom when playback concludes
- 1 - Simon Sez IT Intro
- 2 - Course Outline and Intro to MySQL and Database
- 3 - MySQL Architecture and Installation of MySQL
- 4 - Installation Demo - Part 1
- 5 - Installation Demo - Part 2
- 6 - Database Design
- 7 - MySQL Workbench Download
- 8 - Database Table and Constraints
- 9 - Database Designing and Normalization - Part 1
- 10 - Database Designing and Normalization - Part 2
- 11 - Storage and Data Types
- 12 - Data Types Demo
- 13 - ACID and Transactions
- 14 - Locks, Deadlocks, Isolation Levels and Logging
- 15 - Isolation Levels and Locking Demo
- 16 - Locking Mechanism Demo and MySQL ACID Support
- 17 - Responsibilities of a Database Administrator
- 18 - Creating a User and Limiting Access to a Database; Basic Table Maintainance Function
- 19 - Protecting your Database; How to Perform Database Backup
- 20 - Performance Monitoring
- 21 - InnoDB Indexing and Clustered vs. Unclustered Index
- 22 - Query and Where Clause
- 23 - Impact of Indexing on Database Performance
- 24 - Performance Optimization
