SQLAlchemy Proficiency (Advanced Level)

  • 10m
  • 10 questions
The SQLAlchemy Proficiency (Advanced Level) benchmark measures your ability to work with triggers, stored and parameterized stored procedures, and Python transactions. You will be evaluated on your knowledge of working with check and foreign key constraints, using the ORM API to model tables as classes, as well as extending the declarative_base and automap_base classes and using them to perform SQL commands. A learner who scores high on this benchmark demonstrates that they have the skills to perform advanced operations in SQLAlchemy and can work with SQLAlchemy ORM.

Topics covered

  • automate operations using triggers
  • create tables using object relational mapping
  • customize stored procedures using input arguments
  • implement check constraints
  • perform insert operations using object relational mapping
  • query data using object relational mapping
  • query views using the where clause
  • start, commit, and rollback a transaction
  • use Python with blocks for transactions
  • use the automap_base function to convert tables to classes