A beginners' guide to MySQL queries, database design, transactions and stored procedures.
InstructorJohn Purcell
Free
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This screenshot displays the MySQL Workbench interface showing a relational database schema design with interconnected tables for products, categories, customers, and sales.
This screenshot displays a SQL query editor containing a stored procedure script that declares variables and executes a loop to insert data into a users table.
This screenshot displays a SQL query editor executing a transaction block with update statements, alongside an action output log tracking command responses.
This database schema diagram illustrates the relational structure between person, address, and region tables, showing how foreign keys link user data to geographic locations.
Instruction covers critical database mechanics including ACID properties, isolation levels, and various table locking mechanisms.
The curriculum provides detailed coverage of stored procedures, including the use of parameters, local variables, and cursors.
One sampled review suggests that a recurring pattern of specific exercise lectures followed by dedicated solution lectures supports practical skill development.
Learner signals suggest the instructional pace can feel slow due to excessive detail on basic concepts, leading to a repetitive lecture structure.
The curriculum aligns with the goal of taking a student from beginner to advanced MySQL proficiency.