Course Overview
Data is the lifeblood of modern applications. Our comprehensive MySQL course takes you from fundamental SQL commands to advanced database administration. You will learn data modeling, how to write complex queries to extract business logic, and how to utilize indexes, views, and stored procedures to build performant, scalable databases.
What you'll learn
- Relational Database Design
- Advanced SQL Queries
- Joins & Complex Subqueries
- Indexing & Optimization
Key Highlights
- Normalization (1NF, 2NF, 3NF)
- Writing Stored Procedures
- Creating database Triggers
- Administrative best practices
Course Syllabus
Module 1: Database Fundamentals & Basic SQL
- Introduction to RDBMS and MySQL Architecture
- Database normalization and Data Modeling
- Data Definition Language (CREATE, ALTER, DROP)
- MySQL Data Types and Constraints (Primary/Foreign Keys)
- Data Manipulation Language (INSERT, UPDATE, DELETE)
- Basic SELECT Statements and filtering data
Module 2: Advanced Data Retrieval
- Filtering and Sorting (WHERE, ORDER BY, LIMIT)
- Pattern matching (LIKE, IN, BETWEEN)
- Aggregate Functions (COUNT, SUM, AVG, MAX, MIN)
- Grouping Data (GROUP BY, HAVING)
- Built-in Functions (String, Date/Time, Numeric)
- Handling NULL values realistically
Module 3: Joins, Subqueries & Views
- Understanding Relational Joins
- INNER JOIN, LEFT/RIGHT OUTER JOINS, and CROSS JOIN
- Self Joins and combining multiple tables
- Writing Subqueries (Correlated and Non-correlated)
- Using the EXISTS operator
- Creating and managing Views for query abstraction
Module 4: Advanced Concepts & Optimization
- Introduction to database Indexes and query execution plans
- Transactions (ACID properties, COMMIT, ROLLBACK)
- Writing Stored Procedures and User-Defined Functions
- Implementing Triggers for auditing
- Database Security (User accounts, privileges)
- Backup and Restore (mysqldump)
Course Info
- Duration 6 Weeks
- Lessons 30 Lessons
- Level Beginner to Advanced
- Outcome Database Developer