MYSQL & DATABASE

PART-I

12.1. Course Outline and Intro to MySQL and Database
12.2. MySQL Architecture and Installation of MySQL
12.3. Installation Demo Part-I
12.4. Installation Demo Part-II
12.5. Database Design
12.6. MySQL Workbench Download
12.7. Database Table and Constraints
12.8. Database Designing and Normalization Part-I
12.9. Database Designing and Normalization Part-II
12.10. Storage and Data Types
12.11. Data Types Demo
12.12. Acid and Transactions
12.13. Locks, Deadlocks, Isolation Levels and Logging
12.14. Isolation Levels and Locking Demo
12.15. Locking Mechanism Demo and MySQL Acid Support

PART-II

12.16. Responsibilities of a Database Administrator
12.17. Creating a User and Limiting Access to a Database, Table Maintenance
12.18. Protecting Your Database. How to perform Database Backup
12.19. Performance Monitoring
12.20. Innodb Indexing and Clustered Vs Unclustered Index
12.21. Query and Where Clause
12.22. Impact of Indexing on Database Performance
12.23. Performance Optimization
12.24. Char Vs Varchar Data Types, Create, Drop Keywords, Views, Triggers
12.25. Data Definition Language, How to create Database Objects
12.26. SQL Select Statement
12.27. SQL Select Statement Demo

PART-III

12.28. Joins SQL
12.29. Combining Related Table Using Joins
12.30. Insert, Update and Delete Commands
12.31. Insert, Update and Delete Commands Demo
12.32. Query Optimization
12.33. Query Optimization Demo
12.34. Database Replication
12.35. Setting up Replication in MySQL
12.36. Data Encryption
12.37. Column Level Database Encryption Demo
12.38. High Availability
12.39. Wrap-Up