Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS SQL Server 2014 Programming

Description:

Our MS SQL Server 2014 Programming test measures your knowledge of Microsoft Structure Query Language (SQL) Server 2014 Programming. Designed for experienced database programmers, this test covers the following topics: Beyond Relational, Control Flow, Data Types and NULL, Database Design, Developer Tools, Modifying Data, Running Queries, and Writing Queries.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Beyond Relational
FileTable and FILESTREAM
Full-Text Search
Spatial
XML
Control Flow
Conditional Statements
Exception Handling
Loops and Cursors
Data Types and NULL
Date and Time
Hierarchies
NULL Values
Numeric and Character Data
Parsing and Converting
Database Design
Constraints
Indexes
Sequences
Tables
Triggers
Views
Developer Tools
Execution Plans
Profiler / SQL Trace
SQL Server Data Tools
Modifying Data
Deleting Data
Inserting Data
Updating Data
Running Queries
Distributed Queries
EXECUTE Statement
Set Operators
Stored Procedures and Functions
Transactions
Writing Queries
Grouping and Aggregation
Joins
Ordering
Ranking and Window Functions
Subqueries and CTEs