MySQL: Transactions, Savepoints, & Locks

MySQL 8:0    |    Intermediate
  • 14 Videos | 1h 33m 44s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
This 14-video course explores how to execute groups of commands in an all-or-nothing fashion. Learners will examine how locks are used to regulate table access when multiple clients are accessing the database simultaneously. First, you will explore the ACID properties (atomicity, consistency, isolation, and durability) of database management systems. Next, you will learn how transactions, a unit of work which needs to be executed in an all or nothing fashion, work in MySQL. Next, learners you will examine the start transaction keyword, how transactions are defined as committed or rolled back. You will examine implicit commits, operations which create, alter, or drop database entities, such as databases or tables, and how these operations are affected by transaction commits and rollbacks. Learners will observe DDL (data definition language) operations in MySQL. Continue by exploring savepoints, specific checkpoints where the copy of a system state is created, and release savepoints when they are no longer needed. Finally, the course examines the precise semantics of read and write locks in MySQL.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    enumerate the ACID properties and their importance
    start a transaction and execute statements within it
    rollback insert and update commands executed within a transaction
    identify commands that can not be rolled back once executed
    enumerate DDL operations which are immediately reflected to database state
    leverage stored procedures to control transaction execution
  • specify custom handlers for errors and warnings occurring within transactions
    use savepoints to perform rollback to specific points within a transaction
    understand precise semantics of sequential savepoints in transactions
    create multiple client sessions connected to the same MySQL server
    acquire a read lock on a relation and understand the semantics of read locking
    acquire a write lock on a relation and understand the semantics of write locking
    Course Summary

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 38 Likes 38