MySQL

Course Objectives:

• This course aims to equip students with MySQL database management skills.
• Learners will understand database design, creation, manipulation, and optimization.
• They will learn SQL query language, data types, indexing and performance tuning.
• Upon completion, students will be proficient in managing and querying relational databases effectively."

Curriculum:

• Introduction to MySQL
• Overview of databases and MySQL
• Installing MySQL and MySQL Workbench
• Basic SQL Commands
• Introduction to SQL
• Data Definition Language (DDL): CREATE, ALTER, DROP
• Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE
• Data Types and s
• Understanding MySQL data types
• Creating and modifying s
• Setting primary and foreign keys
• Querying Databases
• Basic SELECT queries
• Filtering and sorting data with WHERE, ORDER BY
• Using aggregate functions (COUNT, SUM, AVG, etc.)
• Joins and Subqueries
• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
• Using subqueries and nested queries
• Indexes and Keys
• Creating and managing indexes
• Understanding primary keys and foreign keys
• Optimizing query performance with indexes
• Transactions and Concurrency
• Understanding transactions: COMMIT, ROLLBACK
• Managing concurrency with transactions and isolation levels
• Stored Procedures and Functions
• Creating and using stored procedures
• Defining and calling functions
• Error handling in stored procedures
• Views and User Management
• Creating and managing views
• User roles and permissions
• Implementing security measures and access control
• Database Backup and Recovery
• Backup strategies and tools
• Restoring databases from backups
• Handling database failures
• Advanced SQL Topics
• Using triggers
• Working with complex queries and optimizations
• Understanding and implementing stored routines