Module 1: Basics of Database (10 Hours)

• RDBMS
• Architecture of MySQL
• Database ACID properties
• Installation and Configuring MySQL
• Features of DBMS

Module 2: Database Design (10 Hours)

• Database Table andConstraints
• ACID and Transactions
• Deadlocks, Isolation Levels and Logging
• Designing and Normalization

Module 3: Security and Users (10 Hours)

• Creating users and granting privileges
• User Backup
• Security practices and changing password

Module 4:Performance (10 Hours)

• Performance problems
• Performance monitoring
• Impact of Indexing on Database performance
• Performance Optimization

Module 5: MySQL Basics (10 Hours)

• Database creation
• Database manipulation -Add, Edit, Retrieve and Delete
• Table creation
• Table manipulation -Add, Edit, Retrieve and Delete

Module 6: Advanced SQL (10 Hours)

• Building and Updating VIEWs
• SQL Select Statements
• Using Joins to combine Related Table
• Insert, Update and Delete commands
• Sub queries