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 Fundamental 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
- Introduction to 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
- Constructing Simple SELECT Statements
- Eliminating Duplicates with DISTINCT
- Using Column and Table Aliases
- Creating 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
- Handling Unknown Values
- Lab: Sorting and Filtering Data
Working with SQL Server 2016 Data Types
- Introduction to SQL Server 2016 Data Types
- Handling Character Data
- Handling Date and Time Data
- Lab: Working with SQL Server 2016 Data Types
Using DML to Modify Data
- Inserting Data into Tables
- Updating and Deleting Data
- Generating Automatic Column Values
- Lab: Using DML to Modify Data
Using Built-In Functions
- Constructing Queries with Built-In Functions
- Utilizing Conversion Functions
- Applying Logical Functions
- Using Functions to Handle NULL Values
- Lab: Using Built-in Functions
Grouping and Aggregating Data
- Employing Aggregate Functions
- Using the GROUP BY Clause
- Filtering Groups with HAVING
- Lab: Grouping and Aggregating
Using Subqueries
- Constructing Self-Contained Subqueries
- Creating Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
- Lab: Using Subqueries
Using Table Expressions
- Utilizing Views
- Using Inline TVFs
- Using Derived Tables
- Implementing CTEs
- Lab: Using Table Expressions
Using Set Operators
- Constructing Queries with the UNION Operator
- Applying 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
- Constructing 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 Basic Stored Procedures
- Working with Dynamic SQL
- Lab: Executing Stored Procedures
Programming with T-SQL
- T-SQL Programming Components
- 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
- Managing Transactions
- Lab: Implementing Transactions
Requirements
- A foundational understanding 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.
