SKILL BENCHMARK

SQLAlchemy Literacy (Beginner Level)

  • 12m
  • 12 questions
Explore all Skills Benchmarks
The SQLAlchemy Literacy (Beginner Level) benchmark measures your ability to use SQLAlchemy to carry out foundational actions and tasks. You will be evaluated on your ability to perform simple select-from-where queries with logical and relational operators from SQLAlchemy, add and drop columns and constraints, and define foreign key constraints and parent/child relationships. A learner who scores high on this benchmark demonstrates that they have the skills to use SQLAlchemy and perform basic DB operations.

Topics covered

  • add a foreign key constraint between tables
  • create and use a SQL primary key constraint with autoincrement
  • create a table and insert rows into it
  • drop a table, recreate it, and insert rows into it
  • execute alter operations to add constraints and indices to tables
  • explore different ways to use logical operators for querying data
  • filter data using two tables with a parent-child relationship
  • install SQLAlchemy and connect to MySQL
  • perform filter operations using SQL operators, such as like, not like, and between
  • perform insert and delete operations
  • perform simple filter operations using logical operators
  • perform update operations while preserving the parameter order