MySQL in Practice: Joins, Views, Stored Routines & Triggers
Join tables the MySQL way, wrap queries in views, write stored procedures, functions and triggers, keep data safe with transactions and design a clean schema, with every answer checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In this intermediate MySQL course you work on a fictional tea shop's database. Every lesson is a lab: you read real MySQL code and work out exactly what it returns or changes, and each answer is checked as you go. You join tables with INNER, LEFT and self joins and avoid join fan-out, save queries as views and update them safely with WITH CHECK OPTION, and write stored procedures with IN, OUT and INOUT parameters, IF/CASE logic, loops, cursors and SIGNAL. You then add stored functions and BEFORE and AFTER triggers, protect changes with transactions and savepoints, index joins and normalize a schema with foreign key actions and finish with a capstone and a certificate exam.
Lessons
- INNER JOIN, Aliases and USING in MySQLFree
- LEFT JOIN, Filters in ON and the Anti-Join Locked
- Joining Three Tables: Lines, Products and Orders Locked
- Self Joins: Employees and Their Managers Locked
- Join Fan-Out: Why Totals Grow After a Join Locked
- Views: Saving a Join Under a Name Locked
- Updatable Views and WITH CHECK OPTION Locked
- Stored Procedures with IN Parameters Locked
- OUT and INOUT Parameters, SELECT ... INTO Locked
- IF, ELSEIF and CASE in Procedures Locked
- Loops in Procedures: WHILE, REPEAT and LOOP Locked
- Stored Functions: DETERMINISTIC, RETURNS and Rounding Locked
- Cursors and the NOT FOUND Handler Locked
- SIGNAL, SQLSTATE 45000 and Error Handlers Locked
- BEFORE INSERT Triggers: Changing NEW Locked
- AFTER Triggers: Stock Updates and Alerts Locked
- Transactions, COMMIT, ROLLBACK and Savepoints Locked
- Indexes for Joins and Foreign Keys Locked
- Schema Design: Normalization and Foreign Key Actions Locked
- Capstone: Procedure, Trigger and View in One Order Run Locked