20461D - Querying Microsoft SQL Server 2014

20461D - Querying Microsoft SQL Server 2014

Overview

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals..

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Duration

5 Days

Target Audience

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Topics

Introduction to Microsoft SQL Server 2014
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2014 Data Types
Using DML to Modify Data
Using Built-In Functions
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Using Window Ranking, Offset, and Aggregate Functions
Pivoting and Grouping Sets
Querying data with Stored Procedures
Programming with T-SQL
Implementing Error Handling
Implementing Transactions
Appendix 1: Improving Query Performance
Appendix 2: Querying SQL Server Metadata

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

Course Details

Course Ref:

20461D

Course Duration:

5 Days

Course Location:

Sunderland

Course Dates:

25th Sep 2017 - 29th Sep 2017

Course Price (Excl VAT):

£1,295

Book this course

Course Downloads

Send course details to a colleague

Telephone

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

Sponsors