A beginners' guide to MySQL queries, database design, transactions and stored procedures.

MySQL, SQL and Stored Procedures from Beginner to Advanced

Name: Advanced MySQL mechanics through structured exercises
Rating: 6.2

InstructorJohn Purcell

Duration18h 17m

Students30.5K

Rating4.5 (4,651)

Advanced MySQL mechanics through structured exercises

Strengths

Advanced Concurrency and Logic

Instruction covers critical database mechanics including ACID properties, isolation levels, and various table locking mechanisms.

Procedural Programming Focus

The curriculum provides detailed coverage of stored procedures, including the use of parameters, local variables, and cursors.

Structured Skill Development

One sampled review suggests that a recurring pattern of specific exercise lectures followed by dedicated solution lectures supports practical skill development.

Limitations

Slow and Repetitive Delivery

Learner signals suggest the instructional pace can feel slow due to excessive detail on basic concepts, leading to a repetitive lecture structure.

Best suited to

Learners seeking depth in transaction isolation and locking
Students wanting to learn procedural SQL elements like cursors
Beginners looking for structured exercise-and-solution patterns

Less suited to

Learners preferring a fast-paced or concise delivery
Those seeking highly varied instructional styles

Comidoc Score

6.2/10

Worth considering

Beginner-friendly

Comidoc verdict

Instruction moves from fundamental table creation and querying into complex database administration, including user privileges and storage engines. The curriculum places significant emphasis on the mechanics of transactions, ACID properties, and procedural logic through stored procedures and cursors.

The technical depth is a primary strength, particularly for those needing to understand how locks and isolation levels function within MySQL. This is supplemented by a structured approach where exercises are paired with specific solutions to reinforce learning.

However, the instructional experience may feel taxing due to a slow pace and repetitive lecture formats. This course is best suited for learners who prioritize technical detail and structured practice over rapid-fire instruction.

Score breakdown