MySQL Proficiency (Advanced Level)

  • 18m
  • 18 questions
The MySQL Proficiency benchmark assesses your knowledge to implement solid, robust triggers, define stored procedures that take in various arguments, and invoke the stored procedures. You will be evaluated on your skills in leveraging transactions, such as rollbacks, commits, and savepoints, and confidently using read and write locks to control concurrent access to database relations. A learner who scores high on this benchmark demonstrates that they have the skills to use triggers, create and invoke stored procedures, and implement transactions in MySQL.

Topics covered

  • 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
  • check if a stored procedure already exists and drop it before re-defining it
  • combine complex declarative and imperative operations in a stored procedure
  • create a row-level trigger executed before inserts into a MySQL table
  • create a simple stored procedure correctly specifying choice of delimiter
  • create multiple client sessions connected to the same MySQL server
  • define a trigger and enumerate use cases of triggers in a database system
  • enumerate DDL operations which are immediately reflected to database state
  • enumerate the ACID properties and their importance
  • identify commands that can not be rolled back once executed
  • invoke a stored procedure and pass in required arguments
  • leverage stored procedures to control transaction execution
  • override default ON DELETE and ON UPDATE behavior in MySQL tables
  • rollback insert and update commands executed within a transaction
  • specify custom handlers for errors and warnings occurring within transactions
  • understand precise semantics of sequential savepoints in transactions
  • use triggers to performing cascading inserts and satisfy foreign key constraints