Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Microsoft SQL Server 2016
- The Basic Architecture of SQL Server
- SQL Server Editions and Versions
- Getting Started with SQL Server Management Studio
- Lab: Working with SQL Server 2016 Tools
Introduction to T-SQL Querying
- Introducing T-SQL
- Understanding Sets
- Understanding Predicate Logic
- Understanding the Logical Order of Operations in SELECT Statements
- Lab: Introduction to T-SQL Querying
Writing SELECT Queries
- Writing Simple SELECT Statements
- Eliminating Duplicates with DISTINCT
- Using Column and Table Aliases
- Writing Simple CASE Expressions
- Lab: Writing Basic SELECT Statements
Querying Multiple Tables
- Understanding Joins
- Querying with Inner Joins
- Querying with Outer Joins
- Querying with Cross Joins and Self Joins
- Lab: Querying Multiple Tables
Sorting and Filtering Data
- Sorting Data
- Filtering Data with Predicates
- Filtering Data with TOP and OFFSET-FETCH
- Working with Unknown Values
- Lab: Sorting and Filtering Data
Working with SQL Server 2016 Data Types
- Introducing SQL Server 2016 Data Types
- Working with Character Data
- Working with Date and Time Data
- Lab: Working with SQL Server 2016 Data Types
Using DML to Modify Data
- Adding Data to Tables
- Modifying and Removing Data
- Generating Automatic Column Values
- Lab: Using DML to Modify Data
Using Built-In Functions
- Writing Queries with Built-In Functions
- Using Conversion Functions
- Using Logical Functions
- Using Functions to Work with NULL
- Lab: Using Built-in Functions
Grouping and Aggregating Data
- Using Aggregate Functions
- Using the GROUP BY Clause
- Filtering Groups with HAVING
- Lab: Grouping and Aggregating
Using Subqueries
- Writing Self-Contained Subqueries
- Writing Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
- Lab: Using Subqueries
Using Table Expressions
- Using Views
- Using Inline TVFs
- Using Derived Tables
- Using CTEs
- Lab: Using Table Expressions
Using Set Operators
- Writing Queries with the UNION Operator
- Using EXCEPT and INTERSECT
- Using APPLY
- Lab: Using Set Operators
Using Window Ranking, Offset, and Aggregate Functions
- Creating Windows with OVER
- Exploring Window Functions
- Lab: Using Window Ranking, Offset, and Aggregate Functions
Pivoting and Grouping Sets
- Writing Queries with PIVOT and UNPIVOT
- Working with Grouping Sets
- Lab: Pivoting and Grouping Sets
Executing Stored Procedures
- Querying Data with Stored Procedures
- Passing Parameters to Stored Procedures
- Creating Simple Stored Procedures
- Working with Dynamic SQL
- Lab: Executing Stored Procedures
Programming with T-SQL
- T-SQL Programming Elements
- Controlling Program Flow
- Lab: Programming with T-SQL
Implementing Error Handling
- Implementing T-SQL Error Handling
- Implementing Structured Exception Handling
- Lab: Implementing Error Handling
Implementing Transactions
- Transactions and the Database Engine
- Controlling Transactions
- Lab: Implementing Transactions
Requirements
- Basic knowledge of relational databases.
35 Hours
Testimonials (2)
The training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
He is very good at what he does, highly skilled, patient, and knowledgeable. He takes the time to explain things clearly and ensures everything is done to the highest standard. His professionalism and dedication truly stand out.
