Demystify the select statement by learning to retrieve all columns or specific columns from the employee table, improving performance by cherry-picking data and mastering query basics.

Master the where clause to filter data precisely, using examples on the employees table to compare text and numeric fields, implement conditional operators, and retrieve specific results.

Explore how to use and, or, and not operators in MySQL to build complex where clauses that filter by multiple country and city conditions.

Explore MySQL aggregation functions by counting rows, averaging prices, and summing quantities using the orders details table, with practical examples of count, avg, and sum.

Master the inner join to fetch matching records from two (and multiple) tables, using orders and customers as practical examples to retrieve linked customer information.

Discover how the having clause filters aggregated data in MySQL, using group by and count to show countries with more than five customers.

Explore how the MySQL exists clause uses subqueries to test for row existence. Apply exists with practical examples, like suppliers with products costing under 20 or 22.

Explore MySQL operators: arithmetic, comparison, and logical, and learn how they power SQL queries and conditional logic with practical examples.

Learn the basic create table syntax in MySQL by defining a books table with id as auto increment primary key, and columns for title, author, and published year.

Discover the drop table syntax in MySQL, learn to drop a table such as books, create tables, and verify the deletion by refreshing the database.

Explore the MySQL foreign key constraint to enforce table relationships, prevent actions that destroy links, and reference a parent table's primary key from a child table like orders and person.

Explore how to define and apply default values in MySQL, including creating a table with a city default of UK and using alter table to set and drop defaults.

Create and populate the customers and orders tables in MySQL, establish a one-to-many relationship by adding a foreign key from orders to customers, and verify with a join query.

Create and manage MySQL triggers to enforce rules and audit changes, including before insert and after insert actions, and before update checks on salaries in the employees table.