Course Details
Course Outline
1 - Introduction to Microsoft SQL Server 2016
Learn the Basics of SQL Server ArchitectureGet Exposed to the Different SQL Server Editions and VersionsBecome Familiar With SQL Server Management StudioLab: Working with SQL Server 2016 Tools
2 - Introduction to T-SQL Querying
Learn the Components of T-SQLUnderstand Sets and Predicate LogicMaster the Logical Order of Operations in SELECT statementsLab: Introduction to Transact-SQL Querying
3 - Writing SELECT Queries
Write Simple SELECT Statements and CASE ExpressionsEliminate Duplicates With DISTINCTPractice Using Column and Table AliasesLab: Writing Basic SELECT Statements
4 - Querying Multiple Tables
Understand JoinsQuery with Inner Joins, Outer Joins, Cross Joins and Self JoinsLab: Querying Multiple Tables
5 - Sorting and Filtering Data
Learn How to Sort DataFilter Data with PredicatesWork With Unknown ValuesLab: Sorting and Filtering Data
6 - Working with SQL Server 2016 Data Types
Learn About SQL Server 2016 Data TypesWork With Character Data and Date and Time DataLab: Working with SQL Server 2016 Data Types
7 - Using DML to Modify Data
Insert DataModify and Delete DataLab: Using DML to Modify Data
8 - Using Built-In Functions
Write Queries with Built-In FunctionsPractice Conversion Functions and Logical FunctionsPractice Using Functions to Work With NULLLab: Using Built-In Functions
9 - Grouping and Aggregating Data
Use Aggregate Functions and the GROUP BY ClauseFilter Groups With HAVINGLab: Grouping and Aggregating Data
10 - Using Subqueries
Write Self-Contained and Correlated SubqueriesExecute the EXISTS Predicate with SubqueriesLab: Using Subqueries
11 - Using Table Expressions
Navigate Views and Inline Table-Valued FunctionsManipulate Derived Tables and Common Table ExpressionsLab: Using Table Expressions
12 - Using Set Operators
Complete Queries with the UNION OperatorUse EXCEPT, INTERSECT and APPLYLab: Using Set Operators
13 - Using Windows Ranking, Offset, and Aggregate Functions
Create Windows with OVERExplore Window FunctionsLab: Using Windows Ranking, Offset, and Aggregate Functions
14 - Pivoting and Grouping Sets
Write Queries with PIVOT and UNPIVOTWork with Grouping SetsLab: Pivoting and Grouping Sets
15 - Executing Stored Procedures
Query Data with Stored ProceduresPass Parameters to Stored proceduresCreate Simple Stored ProceduresNavigate Dynamic SQLLab: Executing Stored Procedures
16 - Programming with T-SQL
Master T-SQL Programming ElementsControl Program FlowLab: Programming with T-SQL
17 - Implementing Error Handling
Execute T-SQL Error HandlingImplement Structured Exception HandlingLab: Implementing Error Handling
18 - Implementing Transactions
Learn About Transactions and Database EnginesControl TransactionsLab: Implementing Transactions
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
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.
Other Prerequisites
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.