MySQL

Course Outline:

• Cross-platform support
• Views and Triggers
• SQL compatibility
• Stored procedures
• Unicode

Basics of Database

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

Database Design

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

Security and Users

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

Performance

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

MySQL Basics

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

Advanced SQL

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