MySQL Database Bootcamp: Go from SQL Beginner to Expert

Learn how to group data with group by and filter groups with having, using aggregate functions like count and sum across scenarios such as orders by country and by status.

Learn how to delete specific records and update records in MySQL using delete from table where, in, and update set, including country and price examples and a practice assignment.

Explore alter table operations in MySQL to add, drop, modify, rename, and truncate columns and tables, with syntax examples and hands-on practice.

The lecture compares delete, truncate, and drop MySQL, noting delete with where can be rolled back, truncate clears rows and cannot be rolled back, and drop removes table or database.

Discover how the not null constraint enforces non-null values in a column, blocking null inserts and raising errors; apply not null when creating or altering tables and verify with describe.

Define unique constraints to enforce distinct values on non-primary-key columns, while primary keys stay inherently unique; learn to add and alter constraints and how nulls are treated.

Discover how to apply default values in MySQL tables using the default keyword, including auto-filled fields on insert, using now for current date, and altering tables with describe and modify.

learn inner join to combine tables by matching common columns using on, illustrated through products, manufacturer, and categories, using aliases and filtering by color and price.

Explore outer joins, including left and right outer joins, to fetch all records from one table and matching records from another, with examples using customers, orders, and products.

Learn to back up and export a database in this MySQL bootcamp. Use the dump project folder to create a separate file for each table, then verify the exported files.