SQL for Beginners: Learn SQL using MySQL and Database Design

Install and configure MySQL server and MySQL Workbench on macOS, create a secure devuser with localhost access, and test connections to manage databases.

Install and configure MySQL server and Workbench on Linux (Ubuntu), set up apt repository, install packages, create a devuser with DBA privileges, and verify connections via Workbench.

Learn how DDL creates database objects and DML manipulates data, focusing on table creation, data types, primary and foreign keys, and a coffee shop database with products, customers, and orders.

Master advanced table alteration techniques in MySQL by adding and removing primary and foreign keys, applying unique constraints, renaming columns, and changing data types, plus a test database and exercises.

Modify column data types in MySQL with two commands: change column and modify column; explore renaming and changing types using the addresses table, including varchar, char, and int considerations.

Download the customer_table and orders_table data, execute the insert into customers and insert into orders queries, then query all three tables to see 24 customers and over 100 orders.

Learn to filter data with where clauses in a select statement, using and and or to combine conditions, handle varchar values with quotes, numeric price values, in the coffee_store database.

Explore handling null values in sql by using is null and is not null in where clauses. Use the coffee store database to filter customers with or without phone numbers.

Filter female Bluth customers by gender and last name. Display first name and phone, and show products with price over 3 or origin Sri Lanka; identify males with null phones.

Master filtering with IN and NOT IN in SQL where clauses, listing multiple values in parentheses and quoting strings, using examples with last names Taylor, Bluth, Armstrong.

Learn how to use the between operator for range queries in sql, including dates, numbers, and strings, with inclusive bounds.

Learn to sort sql query results using order by, including ascending and descending on price, last names, and multiple columns, with where filters and default id ordering.

Review sql filtering: select name and price from products where coffee origin in Columbia or Indonesia, and order by name; show February 2023 orders by customer ids and like patterns.

Learn to select distinct values in SQL with the distinct keyword. Explore origin, id, and price in a coffee store database and how where and order by shape results.

Explore selecting data from multiple tables with joins in MySQL, including inner, left, and right joins, and practice queries across more than two tables with exercises and solutions.

Explains step-by-step mysql join queries: orders with customer phones for product 4; product names with order times for January–March 2023; and female January orders, plus an entity relationship diagram.

Learn third normal form (3NF) and how non-primary key columns depend on the whole primary key. Use a subject–year example to see how table splitting achieves 3NF.

Design and implement a cinema booking system database in MySQL, creating seven tables, modeling the schema, and inserting data to prepare for future querying.

Create the customers table with id as an auto-incrementing int primary key, and first_name, last_name, and email as varchar(45) with not null on last_name and email, and email unique.

Create the screenings table with an auto-incrementing primary key and not null film_id, room_id, and start_time. Define foreign keys to films.id and rooms.id, establishing one-to-many relationships with films and rooms.

Explore SQL aggregate functions such as count, min, max, sum, and avg, group data by columns with group by, and filter with the having clause, plus exercises and video solutions.

Explore step-by-step aggregate queries using count, joins, and date filters to analyze bookings and screenings, including Blade Runner 2049, and using distinct and month and year functions.

Provide advanced sql solutions using group by, joining bookings and reserved seats, and counting seats and screenings; cover where vs having, film length over 120, aliasing, and pre-grouping filters.