# SQL - Advanced (Short) Assessment

## Description
The SQL - Advanced (Short) test is designed to evaluate the knowledge and skills of job candidates and employees in writing, debugging, deploying, and maintaining advanced SQL scripts using standard SQL keywords, syntax, and design patterns. The assessment covers a broad range of advanced topics including Joins, Set Operations, and Grouping; Subqueries, CTEs, and Correlated Queries; Window Functions; Transaction Control and Data Integrity; DDL covering Tables, Constraints, Indexes, and Views; and Query Performance and Execution Plans. The test measures skill-based proficiency and uses a variety of question formats including Multiple Choice, Multiple Correct Answer, and Essay Composition questions, with some questions scored using artificial intelligence. Questions are drawn from a large pool to minimize cheating, and one or more questions include individual time limits to further deter academic dishonesty and to improve the predictive accuracy of results.

## Competencies Measures
- Joins, Set Operations, and Grouping
- Joins, Set Operations, and Grouping (Coding Tasks)
- Subqueries, CTEs, and Correlated Queries
- Subqueries, CTEs, and Correlated Queries (Coding Tasks)
- Transaction Control and Data Integrity
- Window Functions

## Metadata
- **Duration:** 14.0 Minutes
- **Language:** English (US)
- **Type:** Skills/Knowledge Assessment (Test)
- **Last Updated:** July 4, 2026

## Catalog Link
View additional details or to administer the assessment to a candidate here:
[View in Online Test Catalog](https://www.hravatar.com/ta/tests/9633/sql-advanced-short.html)