SQL – Introduction to SQL with MySQL Course Syllabus
Full curriculum breakdown — modules, lessons, estimated time, and outcomes.
A practical and thorough MySQL tutorial that takes you from installation to complex queries, equipping you with the database skills needed for real-world applications. This course is structured into six core modules, blending foundational concepts with hands-on practice. You'll spend approximately 5 hours engaging with step-by-step tutorials, real-world examples, and interactive exercises designed to build your confidence in writing and managing SQL queries using MySQL. Lifetime access ensures you can learn at your own pace and revisit key topics as needed.
Module 1: MySQL Setup & Basics
Estimated time: 0.5 hours
- Installing MySQL Server and Workbench
- Creating your first database
- Introduction to the MySQL command-line client
- Using GUI tools for database management
Module 2: Retrieving Data with SELECT
Estimated time: 0.75 hours
- Writing basic SELECT statements
- Using column aliases
- Filtering data with WHERE clause
- Applying logical operators and pattern matching (LIKE, IN)
Module 3: Sorting & Pagination
Estimated time: 0.5 hours
- Sorting results with ORDER BY (ascending/descending)
- Implementing pagination using LIMIT
- Using OFFSET for advanced pagination
Module 4: Aggregate Functions & Grouping
Estimated time: 1 hour
- Summarizing data with COUNT, SUM, AVG, MIN, MAX
- Grouping results using GROUP BY
- Filtering groups with HAVING clause
Module 5: Data Modification Statements
Estimated time: 0.75 hours
- Inserting new records with INSERT (single and bulk)
- Updating existing data with UPDATE
- Removing rows with DELETE
Module 6: Schema Design & Joins
Estimated time: 1 hour
- Creating tables with CREATE TABLE
- Defining primary and foreign keys
- Performing INNER, LEFT, RIGHT, and FULL OUTER joins
- Designing basic relational schemas
Prerequisites
- Basic computer literacy
- Familiarity with using a web browser and installing software
- No prior database experience required
What You'll Be Able to Do After
- Install and configure MySQL Server and MySQL Workbench
- Write core SQL commands including SELECT, INSERT, UPDATE, and DELETE
- Filter and sort query results using WHERE, ORDER BY, LIMIT, and pattern matching
- Aggregate data using GROUP BY, HAVING, and common SQL functions
- Design simple relational databases and perform table joins