Getting Started with MySQL Database Service

COURSE OUTLINE

MODULE 01 Introduction to MySQL

• What is MySQL?
• Relational Database Basics
• Difference between MySQL and other RDBMS

MODULE 02 Overview and Setup

• Installing MySQL Server and Workbench (or CLI setup)
• MySQL ArchitectureS

MODULE 03 MySQL Basics

• Understanding Databases and Tables
• Data Types in MySQL (INT, VARCHAR, DATE, etc.)
• MySQL Syntax Basics (Case sensitivity, comments)

MODULE 04 Basic Queries

• Creating a Database
• Creating Tables
• Inserting Data into Tables
• Selecting Data (Basic SELECT Statements)

MODULE 05 Data Manipulation

• Updating Records (UPDATE Statement)
• Deleting Records (DELETE Statement)
• Truncating Tables

MODULE 06 Query Filtering

• Using WHERE Clause
• Logical Operators (AND, OR, NOT)
• Comparison Operators (=, >, <, BETWEEN, LIKE)

MODULE 07 Sorting and Limiting Results

• ORDER BY Clause
• LIMIT Clause

MODULE 08 Aggregate Functions

• COUNT, AVG, SUM, MAX, MIN
• GROUP BY and HAVING Clauses

MODULE 09 Joining Tables

• Inner Join
• Left Join
• Right Join
• Full Outer Join

MODULE 10 Subqueries

• Single-row Subqueries
• Multi-row Subqueries
• Correlated Subqueries

MODULE 11 Advanced Querying

• Using Indexes
• Foreign Keys and Constraints
• Transactions (BEGIN, COMMIT, ROLLBACK)
• Views

MODULE 12 Database Design Principles

• Normalization Basics (1NF, 2NF, 3NF)
• Common Denormalization Scenarios

MODULE 13 Backup and Restore

• Exporting and Importing Databases
• Backup Strategies