Transact SQL Assessment

  • $10.00


The Transact SQL assessment measures the understanding of TSQL. Questions are based on both syntax and theory and are asked about various TSQL components, including DDL, DML, performance tuning, and administration. This assessment is reflective of the skill set typically required by Database Programmers, Database Programmer/Analysts, Data Warehouse Specialists, and TSQL programmers.

Assessments for ANSI/SQL and SQL Server are also available.

Number of questions 36
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Advanced Query Concepts
Basic Query Components
DDL
DML
Granularity
Tasks tested Advantages in Indexing
Altering a Column
Basic Query Syntax
Break and Continue
Case Statements
Concatenation
Correlated Sub Queries
Cursors
DDL Implications
Evaluating a Query
Filtering Results
Finding Errors and Why
Group by Clause
Identifying Statements
Identifying Structures
Indexes
Inserts
Manipulating Results
Null Functions
Outer Joins
Procedure Logic
Procedures
Query Components
Relational Operators
Restricting Result Sets
Sub Queries
Transversing Your Data
Triggers
TSQL Objects
TSQL Syntax
Understanding the * Symbol in a Select Clause
Updates
Using Relational Operators
Variable Creation
Where Clause
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)