SQL – Introduction to SQL with MySQL

Module 1: MySQL Setup & Basics

⏳ 30 minutes

• Installing MySQL Server and Workbench, creating your first database

• Introduction to the MySQL command-line client and GUI tools

Module 2: Retrieving Data with SELECT

⏳ 45 minutes

• Basic SELECT statements, column aliases, and limiting results

• Filtering with WHERE, logical operators, and pattern matching

Module 3: Sorting & Pagination

⏳ 30 minutes

• Using ORDER BY for ascending/descending sort

• Implementing pagination with LIMIT and OFFSET

Module 4: Aggregate Functions & Grouping

⏳ 1 hour

• Summarizing data using COUNT, SUM, AVG, MIN, MAX

• Grouping results with GROUP BY and filtering groups with HAVING

Module 5: Data Modification Statements

⏳ 45 minutes

• Inserting new records with INSERT (single-row and bulk)

• Updating existing data with UPDATE and removing rows with DELETE

Module 6: Schema Design & Joins

⏳ 1 hour

• Creating tables with CREATE TABLE, defining primary and foreign keys

• Combining tables using INNER, LEFT, RIGHT, and FULL OUTER joins

Module 7: Subqueries & Views

⏳ 45 minutes

• Writing subqueries in SELECT, FROM, and WHERE clauses

• Creating and querying views for reusable logic

Module 8: Indexing & Performance Tips

⏳ 30 minutes

• Understanding indexes and when to use them

• Using EXPLAIN to analyze query plans and optimize performance

Get certificate