Lesson 1.1: Databases Demystified

• What are databases, and why do we need them?
• Common database types (relational vs. NoSQL) and their use cases.
• A brief overview of MySQL as a relational database management system (RDBMS).

Lesson 1.2: The Relational Model

• Understanding tables, columns, rows, and primary keys.
• Relationships between tables (one-to-one, one-to-many, many-to-many).
• Ensuring data integrity with constraints.

Lesson 2.1: Installing MySQL

• Step-by-step guide to downloading and installing MySQL on your system.
• Basic configuration and setting up a root user.

 
• Introduction to MySQL Workbench as a visual tool for MySQL.
• Establishing a connection to your MySQL server.
• Navigating the Workbench interface and its key features.

Lesson 3.1: Creating Your First Database and Tables

• The CREATE DATABASE and CREATE TABLE statements.
• Choosing appropriate data types for your columns.
• Defining primary keys and other constraints.

Lesson 3.2: The CRUD Operations

• Inserting data into tables with INSERT.
• Updating existing data using UPDATE.
• Deleting unwanted rows with DELETE.

Lesson 3.3: Retrieving Data with SELECT

• The power of the SELECT statement and its various clauses.
• Selecting specific columns and filtering data with WHERE.
• Sorting your results with ORDER BY.
• Performing calculations and aggregations (e.g., COUNT, SUM, AVG).

Exercise 4.1: Design and Populate a Database

• Design a simple database schema for a real-world scenario (e.g., a book collection, a student roster).
• Create the tables, establish relationships, and populate them with sample data.

Exercise 4.2: Write and Execute SQL Queries

• Series of SQL query challenges based on the created database.
• Experiment and explore different query possibilities.