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
- Core Architecture of SQL Server
- SQL Server Editions and Versions
- Initial Steps with SQL Server Management Studio
- Lab: Utilizing SQL Server 2016 Tools
Introduction to T-SQL Querying
- Overview of T-SQL
- Concepts of Sets
- Predicate Logic Explained
- Logical Order of Operations in SELECT Statements
- Lab: Basics of T-SQL Querying
Writing SELECT Queries
- Constructing Simple SELECT Statements
- Removing Duplicates using DISTINCT
- Implementing Column and Table Aliases
- Creating Basic CASE Expressions
- Lab: Writing Fundamental SELECT Statements
Querying Multiple Tables
- Understanding Join Concepts
- Querying using Inner Joins
- Querying using Outer Joins
- Querying using Cross and Self Joins
- Lab: Querying Across Multiple Tables
Sorting and Filtering Data
- Data Sorting Techniques
- Filtering Data using Predicates
- Filtering 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
- Managing 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: Modifying Data with DML
Using Built-In Functions
- Querying with Built-In Functions
- Utilizing Conversion Functions
- Applying Logical Functions
- Handling NULL with Functions
- Lab: Using Built-in Functions
Grouping and Aggregating Data
- Applying Aggregate Functions
- Using the GROUP BY Clause
- Filtering Groups with HAVING
- Lab: Grouping and Aggregation
Using Subqueries
- Writing Self-Contained Subqueries
- Creating Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
- Lab: Utilizing Subqueries
Using Table Expressions
- Leveraging Views
- Using Inline TVFs
- Implementing Derived Tables
- Utilizing CTEs
- Lab: Using Table Expressions
Using Set Operators
- Querying 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
- Querying with PIVOT and UNPIVOT
- Working with Grouping Sets
- Lab: Pivoting and Grouping Sets
Executing Stored Procedures
- Querying Data via Stored Procedures
- Passing Parameters to Stored Procedures
- Creating Basic Stored Procedures
- Working with Dynamic SQL
- Lab: Executing Stored Procedures
Programming with T-SQL
- Core T-SQL Programming Elements
- Managing Program Flow
- Lab: Programming with T-SQL
Implementing Error Handling
- T-SQL Error Handling Strategies
- Structured Exception Handling
- Lab: Implementing Error Handling
Implementing Transactions
- Transactions and the Database Engine
- Controlling Transactions
- Lab: Implementing Transactions
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.
