Transact SQL Assessment

$16.00

Transact SQL Assessment

$16.00
description

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 test is reflective of the skill set typically required by Database Programmers, Database Programmer/Analysts, Data Warehouse Specialists, and TSQL programmers.

 

Number of questions 36
Competencies tested Basic Query Components
Advanced Query Concepts
DML
DDL
Granularity
Tasks tested Using Relational Operators
TSQL Syntax
Where Clause
Basic Query Syntax
Manipulating Results
Group by Clause
Identifying Structures
Filtering Results
Understanding the * Symbol in a Select Clause
Relational Operators
Query Components
Case Statements
Updates
Indexes
Null Functions
Break and Continue
Identifying Statements
Concatenation
Cursors
Procedure Logic
Outer Joins
Correlated Sub Queries
Sub Queries
Restricting Result Sets
Evaluating a Query
TSQL Objects
Triggers
Advantages in Indexing
Variable Creation
Procedures
Altering a Column
DDL Implications
Inserts
Finding Errors and Why
Transversing Your Data