Querying Microsoft SQL Server® 2014

Course Code:
MS20461

Duration:
5 days
9.00am to 5.00pm
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$3,000 (excl of G.S.T)
2019 Course Dates
5 – 8 Aug 2019 (9am – 7pm)
7 – 11 Oct 2019
4 – 8 Nov 2019
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.
Do note that this course listed is a Microsoft Digital Class (DMOC Class). You are required to bring your own device.

Course Overview

This 5-day instructor led course provides participants 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 participants 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.

Program Objectives

• Describe the basic architecture and concepts of Microsoft SQL Server 2014

• Understand the similarities and differences between Transact-SQL and other computer languages

• Write SELECT queries

• Query multiple tables

• Sort and filter data

• Describe the use of data types in SQL Server

• Modify data using Transact-SQL

• Use built-in functions

• Group and aggregate data

• Use subqueries

• Use table expressions

• Use set operators

• Use window ranking, offset and aggregate functions

• Implement pivoting and grouping sets

• Execute stored procedures

• Program with T-SQL

• Implement error handling

• Implement transactions

Course Outline

Module 1: Introduction to Microsoft SQL Server 2014

Module 2: Introduction to T-SQL Querying

Module 3: Writing SELECT Queries

Module 4: Querying Multiple Tables

Module 5: Sorting and Filtering Data

Module 6: Working with SQL Server 2014 Data Types

Module 7: Using DML to Modify Data

Module 8: Using Built-In Functions

Module 9: Grouping and Aggregating Data

Module 10: Using Subqueries

Module 11: Using Table Expressions

Module 12: Using Set Operators

Module 13: Using Window Ranking, Offset, and Aggregate Functions

Module 14: Pivoting and Grouping Sets

Module 15: Executing Stored Procedures

Module 16: Programming with T-SQL

Module 17: Implementing Error Handling

Module 18: Implementing Transactions

Module 19: Improving Query Performance

Module 20: Querying SQL Server Metadata

Click Here for full course outline

Take The Next Step

It Takes Less Than 5 Min