# SQL - Advanced Assessment

## Description
The SQL - Advanced 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 measures proficiency across six key areas: 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 presents a variety of question formats, including Multiple Choice, Multiple Correct Answer, and Essay Composition questions, with questions drawn from a large pool to minimize the risk of cheating, and select questions are subject to individual time limits to further deter dishonesty and enhance predictive accuracy. AI-assisted scoring is applied to one or more questions, ensuring a thorough and objective evaluation of each candidate's advanced SQL capabilities.

## Competencies Measures
- DDL: Tables, Constraints, Indexes, and Views
- Joins, Set Operations, and Grouping
- Joins, Set Operations, and Grouping (Coding Tasks)
- Query Performance and Execution Plans
- Subqueries, CTEs, and Correlated Queries
- Subqueries, CTEs, and Correlated Queries (Coding Tasks)
- Transaction Control and Data Integrity
- Window Functions

## Metadata
- **Duration:** 19.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/9628/sql-advanced.html)