Querying Data with Transact-SQL

Course Code:
MS20761
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
8 – 12 Jul 2019
2 – 6 Sep 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 course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Program Objectives

After completing this course, students will be able to:

• Describe key capabilities and components of SQL Server 2016

• Describe T-SQL, sets, and predicate logic

• Write a single table SELECT statement

• Write a multi-table SELECT statement

• Write SELECT statements with filtering and sorting

• Describe how SQL Server uses data types

• Write DML statements

• Write queries that use built-in functions

• Write queries that aggregate data

• Write subqueries

• Create and implement views and table-valued functions

• Use set operators to combine query results

• Write queries that use window ranking, offset, and aggregate functions

• Transform data by implementing pivot, unpivot, rollup and cube

• Create and implement stored procedures

• Add programming constructs such as variables, conditions, and loops to T-SQL code

 

Course Outline

Module 1: Introduction to Microsoft SQL Server 2016

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 2016 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 Set Operators

Module 12: Using Set Operators

Module 13: Using Windows 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

Click Here for full course Outline

Take the Next Step

It Takes Less Than 5 Min