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
Overview of Microsoft SQL Server 2016
- Foundations of SQL Server Architecture
- SQL Server Editions and Versions
- Initial Setup in SQL Server Management Studio
- Lab: Utilizing SQL Server 2016 Tools
Basics of T-SQL Querying
- Introduction to T-SQL
- Concepts of Sets
- Principles of Predicate Logic
- Logical Execution Order in SELECT Statements
- Lab: T-SQL Querying Fundamentals
Constructing SELECT Queries
- Formulating Basic SELECT Statements
- Removing Duplicates Using DISTINCT
- Applying Column and Table Aliases
- Implementing Simple CASE Expressions
- Lab: Creating Basic SELECT Statements
Querying Across Multiple Tables
- Understanding Join Mechanisms
- Executing Queries with Inner Joins
- Executing Queries with Outer Joins
- Executing Queries with Cross and Self Joins
- Lab: Multi-Table Querying
Ordering and Filtering Results
- Sorting Data
- Filtering via Predicates
- Filtering with TOP and OFFSET-FETCH
- Handling Unknown Values
- Lab: Sorting and Filtering Techniques
Managing 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
Modifying Data with DML
- Inserting Data into Tables
- Updating and Deleting Records
- Generating Automatic Column Values
- Lab: Data Manipulation with DML
Utilizing Built-In Functions
- Querying with Built-In Functions
- Applying Conversion Functions
- Using Logical Functions
- Handling NULLs with Functions
- Lab: Application of Built-in Functions
Aggregating and Grouping Data
- Applying Aggregate Functions
- Using the GROUP BY Clause
- Filtering Groups with HAVING
- Lab: Grouping and Aggregation
Employing Subqueries
- Writing Independent Subqueries
- Writing Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
- Lab: Implementing Subqueries
Working with Table Expressions
- Utilizing Views
- Using Inline TVFs
- Using Derived Tables
- Using CTEs
- Lab: Applying Table Expressions
Applying Set Operators
- Querying with the UNION Operator
- Using EXCEPT and INTERSECT
- Using APPLY
- Lab: Working with Set Operators
Leveraging Window Ranking, Offset, and Aggregate Functions
- Defining Windows with OVER
- Exploring Window Functions
- Lab: Window Functions in Action
Pivoting and Grouping Sets
- Querying with PIVOT and UNPIVOT
- Working with Grouping Sets
- Lab: Pivoting and Grouping Sets
Running Stored Procedures
- Querying Data via Stored Procedures
- Passing Parameters to Procedures
- Developing Basic Stored Procedures
- Working with Dynamic SQL
- Lab: Executing Stored Procedures
Programming in T-SQL
- T-SQL Programming Components
- Managing Program Flow
- Lab: T-SQL Programming
Integrating Error Handling
- T-SQL Error Handling Strategies
- Structured Exception Handling
- Lab: Error Handling Implementation
Managing Transactions
- Transactions in the Database Engine
- Controlling Transaction Behavior
- Lab: Transaction Management
Requirements
- Fundamental 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.
