Previous Lecture
Complete and continue
MySQL DBA Course
Introduction
DBA A. Introduction to DBMS and RDBMS
DBA B. Schema Normalization
Getting Started with MySQL
MySQL DBA 3. MySQL Architecture
MySQL DBA 4. Installing, Configuring, Stopping and Starting
MySQL Lab 1 – Installing MySQL on CentOS/RHEL 7
MySQL Lab 2. Creating Multiple Instances of MySQL on CentOS 7
MySQL Lab 3. Getting Started with MySQL 8.0
MySQL DBA 5. Interpreting Error and Diagnostic Information
MySQL DBA 6. Storage Engines
MySQL DBA 7. The Innodb Engine
MySQL Lab 4. Innodb Table Space Management
Data Management in MySQL
MySQL DBA 8. Obtaining Metadata
MySQL DBA 9. Locking and Transactions in MySQL
MySQL Lab 5. Transactions, Savepoints and Isolation Levels
MySQL DBA 10. MySQL Table Maintenance
MySQL Lab 6 Performing Table Maintenance Operations
MySQL DBA 11 Working with Numeric and Temporal Data
MySQL DBA 12 Database Driven Web Applications
MySQL DBA 13. Backup and Recovery in MySQL
MySQL Lab 7 Performing Backup and Restore
MySQL DBA 14. User Management in MySQL
MySQL Lab 8 User Management
MySQL DBA 15. Privileges in MySQL
Variables and Stored Routines
MySQL DBA 16. User Variables and Prepared Statements
MySQL DBA 17. Stored Procedures and Functions in MySQL
MySQL Lab 9 Stored Routines
MySQL DBA 18. Triggers in MySQL
MySQL DBA 19. Partitioned Tables in MySQL
MySQL Lab 10 Partitioning in MySQL
MySQL Security
MySQL DBA 20. Securing MySQL Server
Optimization and Performance Tuning
MySQL DBA 21. Optimizing MySQL Queries
MySQL DBA 22. Query Execution Plan and Optimization
MySQL DBA 23. Optimizing MySQL Schemas
MySQL DBA 24. Optimizing MySQL Server
MySQL Lab 11 Benchmarking your MySQL servers
MySQL DBA 25. Optimizing MySQL Environment
Scaling and High Availability
MySQL DBA 26. Understanding Replication Concepts
MysQL DBA 27. GTID Based Replication in MySQL
MySQL Lab 12 Replication in MySQL
MySQL DBA 28. MySQL Clusters Introduction
MySQL DBA 29. MySQL Cluster
MySQL DBA 30. Working with Views
MySQL Lab 14 MySQL Cluster Setup on CentOS
MySQL DBA 31. Working with Strings
MySQL DBA 32. Reporting in MySQL
MySQL DBA 33. MySQL Spatial Data Types
MySQL DBA 34. JSON Data Handling in MySQL
MySQL DBA 35. Document Store in MySQL
MySQL DBA 36. 50 Tips for Optimization
MySQL DBA 23. Optimizing MySQL Schemas
Lecture content locked
If you're already enrolled,
you'll need to login.
Enroll in Course to Unlock
Log In
×
E-Mail Address
Password
Remember Me
Login
Forgot Your Password?