20464C - Developing Microsoft SQL Server 2014 Databases

20464C - Developing Microsoft SQL Server 2014 Databases


This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.


5 Days

Target Audience

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database.


Introduction to Database Development

Designing and Implementing Tables

Ensuring Data Integrity through Constraints

Introduction to Indexing

Advanced Indexing

Columnstore Indexes

Designing and Implementing Views

Designing and Implementing Stored Procedures

Designing and Implementing User-Defined Functions

Responding to Data Manipulation via Triggers

Using In-Memory Tables

Implementing Managed Code in SQL Server

Storing and Querying XML Data in SQL Server

Working with SQL Server Spatial Data

A more comprehensive course outline is available in the Course Download section, to the right of this page.

Course Details

Course Ref:


Course Duration:

5 Days

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk