MySQL, SQL and Stored Procedures from Beginner to Advanced

Learn to use the MySQL command line to start the server, connect with the MySQL client, and run basic commands like show databases, with notes on PATH and MySQL Workbench.

Discover how sql_mode governs insert behavior in MySQL, including global and session settings, strict mode for not null columns, and no engine substitution, and how default values and errors arise.

Delete from a table clears all rows, not the table itself; learn to disable sql_safe_updates to allow deleting all rows, then verify by selecting from the table to confirm emptiness.

Learn how auto increment primary keys work in MySQL by creating a users table with an auto increment primary key, inserting without an id, and observing 0 handling.

Explore exclusive or (xor) in MySQL and learn how it differs from or by showing when rows match one condition, both, or neither.

Learn how to limit SQL query results using the limit keyword, with optional offset, order by, and where clauses to retrieve a small, precise subset from large tables.

Explore the bit data type in MySQL, learn how bit fields store binary values, how to insert and view them, and how binary representations convert to decimal.

Explore MySQL blob types and storing binary data, such as images, in a database, and learn why linking to disk files with names is often preferred over storing binaries.

Explore the difference between timestamp and datetime in MySQL, including real-time recording versus date-time storage, and learn practical usage with now as a default value in a products table.

Learn how MySQL enumerations constrain a column to a fixed set of values using enum types, defaults, and examples like temperature and flavor, with inserts and optional foreign key considerations.

Create two MySQL tables, products and personnel, defining primary keys and fields for names, category, sell-by date, sold time, quantity, weight, status, plus extensive personnel and address data.

The lecture demonstrates building MySQL tables for a shop app, detailing primary keys, auto increment, data types (int, varchar, timestamp, boolean, numeric), inserts, and preparing for foreign keys and joins.

Apply the distinct keyword in MySQL to extract unique values, identify duplicates, and understand how to filter by combinations of columns for precise grouped results.

Master inner, left, and right joins and how they return matched or unmatched rows across tables; note that full outer joins aren’t supported by this syntax.

Join multiple tables to replace survey IDs with actual answers from related tables using left or right outer joins, aliasing tables to avoid ambiguity, and rename columns for clarity.

Explore querying chains of tables by joining person, address, and region to retrieve individuals with their street and region, using foreign keys and one-to-many relationships.

Master one-to-many and one-to-one relationships in MySQL, learn why the foreign key lives in the child table, and how to design many-to-many with an extra table in the middle.

Explore many-to-many relationships using a customer and product example, and learn how a linking table with foreign keys connects the two tables to track which customer buys which product.

Design a simple online shop database using multiple related tables with foreign keys, including products, categories, customers, and sales with the time of sale, plus join queries for listing sales.

Design a simple online shop database in MySQL with products, categories, customers, and a sales table. Employ foreign keys and inner joins to analyze sales and identify top products.

Use inline views to treat query results as a table, creating a temporary table from a subquery to enable calculations like the average number of respondents by country.

Discover how adding an index to a non-primary key column speeds up queries in MySQL, illustrated with a music table and an alter table add index example.