SQL Server 2014 for Developers Assessment

  • $10.00


This SQL Server 2014 for Developers assessment has been designed to verify the ability of a developer to effectively work in a SQL 2014 environment. Topics covered by this assessment include data types, SQL programming, transaction management, tools and utilities, system stored procedures, and understanding code. This assessment is appropriate for developers that have at least a year or more of SQL Server 2014 experience.

Number of questions 48
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered SQL Programming
System Stored Procedures
Tools and Utilities
Transaction Management
Understanding Code
Tasks tested Access Database Objects
APPLY Operator Usage
CTE Usage
Data Types for Full-Text Search
Database Object Details
Database Schemas
Delayed Transaction Durability
Dynamic SQL in Procedures
Evaluate Statements
Hekaton
Implementing Database Mail
Import/Export Data
In-Memory OLTP Implementation
Index on Date Columns
INFORMATION_SCHEMA
ISNULL and COALESCE
Memory-Optimized Tables
Modifying XML Data
Name Column Values
New User Database Creation
Object in FROM Clause
OLE Automation Objects
Performing Mass Updates
Poor Query Performance
Predicate for Full-Text Search
Prefix N for String Constants
Query Return
Query Review
Query to View Records
Querying XML Data
RDL File Format
Recreating Objects
Rowversion
Service Broker Enablement
Service Broker Queue
SET NOCOUNT ON
SQL Server Profiler
Structured Error-Handling
System Stored Procedure
Table-Valued Function Usage
Tasks in Integration Services Package
Tinyint Data Type
Tracking Changes to Data
Transaction Management
Truncate Table
Valid Data Types
XMLSC
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)

We Also Recommend