Querying Data with Transact SQL

Are you ready to learn how to navigate relational databases like a pro? Transact SQL training from New Horizons will prepare you to take the next step in your data career.

In this course, you will gain a comprehensive understanding of the Transact SQL language, which is used by all SQL Server-related disciplines including database administration, database development and business intelligence.

Target Audience

If you’re a database administrator, developer or BI professional responsible for processing data, this course was made for you. However, if you’re simply interested in learning Transact-SQL to become more efficient at your job, you can also benefit from taking this course.

Course Objectives

After finishing this course, you’ll have the confidence to use Transact-SQL commands to interact with relational databases. You will be able to:

• Describe the key capabilities and components of SQL Server
• Confidently speak about T-SQL, sets and predicate logic
• Write single- and multi-table SELECT statements
• Explain how SQL Server uses data types
• Manipulate set operators to combine query results
• Work with and implement views and table-valued functions
• Write DML statements and queries
• 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

Pre-requisites:

We want you to get the most value possible out of your SQL Server training. To maximize your time taking this course, you should have working knowledge of relational databases and 1-2 years of experience using SQL Server. Basic understanding of the Windows operating system and its core functionalities will also set you up for success.

Course Outline

1 - INTRODUCTION TO MICROSOFT SQL SERVER 2016

2 - INTRODUCTION TO T-SQL QUERYING

3 - WRITING SELECT QUERIES

4 - QUERYING MULTIPLE TABLES

5 - SORTING AND FILTERING DATA

6 - WORKING WITH SQL SERVER 2016 DATA TYPES

7 - USING DML TO MODIFY DATA

8 - USING BUILT-IN FUNCTIONS

9 - GROUPING AND AGGREGATING DATA

10 - USING SUBQUERIES

11 - USING TABLE EXPRESSIONS

12 - USING SET OPERATORS

13 - USING WINDOWS RANKING, OFFSET, AND AGGREGATE FUNCTIONS

14 - PIVOTING AND GROUPING SETS

15 - EXECUTING STORED PROCEDURES

16 - PROGRAMMING WITH T-SQL

17 - IMPLEMENTING ERROR HANDLING

18 - IMPLEMENTING TRANSACTIONS