SKILL BENCHMARK

Prompt Engineering for Querying SQL Databases Competency (Intermediate Level)

  • 15m
  • 15 questions
Explore all Skills Benchmarks
The Prompt Engineering for Querying SQL Databases Competency (Intermediate Level) benchmark evaluates your knowledge of and ability to harness the power of generative artificial intelligence (GenAI) tools such as ChatGPT and Bard to filter and group data using SQL. You will be assessed on your ability to use prompt engineering to work with advanced SQL features. Learners scoring high on this benchmark demonstrate that they have the skills to utilize AI tools for filtering and grouping data with SQL and can employ prompt engineering for advanced SQL features.

Topics covered

  • commit and rollback transactions
  • create and work with views
  • create indexes to improve performance
  • filter data with the LIKE and IN keywords
  • filter rows using the WHERE clause
  • group data and perform aggregations
  • perform complex groupby and aggregation operations
  • perform inner joins
  • perform left, right, and full outer joins
  • perform numeric aggregations
  • recall key concepts relating to the normalization of data
  • run queries automatically with triggers
  • set up foreign keys with cascading deletes
  • upload data from a file to MySQL
  • view data with subqueries