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
Module 1: Overview of Microsoft SQL Server 2016
- Lesson 1: Fundamentals of SQL Server Architecture
- Lesson 2: SQL Server Editions and Versions
- Lesson 3: Initial Configuration with SQL Server Management Studio
- Lab: Utilizing SQL Server 2016 Tools for Government Systems
Module 2: Fundamentals of T-SQL Querying
- Lesson 1: Overview of T-SQL
- Lesson 2: Conceptualizing Data Sets
- Lesson 3: Principles of Predicate Logic
- Lesson 4: Logical Processing Order in SELECT Statements
- Lab: Introduction to T-SQL Querying for Government Audits and Reporting
Module 3: Developing SELECT Queries
- Lesson 1: Constructing Basic SELECT Statements
- Lesson 2: Removing Duplicate Records Using DISTINCT
- Lesson 3: Applying Column and Table Aliases
- Lesson 4: Implementing Simple CASE Expressions
- Lab: Developing Standard SELECT Statements for Government Data Retrieval
Module 4: Querying Multiple Tables
- Lesson 1: Understanding Join Operations
- Lesson 2: Executing Inner Joins
- Lesson 3: Executing Outer Joins
- Lesson 4: Executing Cross Joins and Self Joins
- Lab: Querying Multiple Tables for Integrated Government Databases
Module 5: Sorting and Filtering Data
- Lesson 1: Sorting Result Sets
- Lesson 2: Applying Predicates to Filter Data
- Lesson 3: Utilizing TOP and OFFSET-FETCH for Data Limitation
- Lesson 4: Managing Unknown Values (NULLs)
- Lab: Sorting and Filtering Data for Government Reporting Requirements
Module 6: Using SQL Server 2016 Data Types
- Lesson 1: Overview of SQL Server 2016 Data Types
- Lesson 2: Manipulating Character Data
- Lesson 3: Manipulating Date and Time Data
- Lab: Managing SQL Server 2016 Data Types for Government Records
Module 7: Modifying Data with DML
- Lesson 1: Inserting Data into Tables
- Lesson 2: Updating and Deleting Data
- Lesson 3: Configuring Auto-Incrementing Column Values
- Lab: Modifying Data with DML for Government Database Maintenance
Module 8: Leveraging Built-In Functions
- Lesson 1: Utilizing Built-In Functions in Queries
- Lesson 2: Employing Conversion Functions
- Lesson 3: Employing Logical Functions
- Lesson 4: Managing NULL Values with Functions
- Lab: Applying Built-In Functions for Government Data Processing
Module 9: Grouping and Aggregating Data
- Lesson 1: Utilizing Aggregate Functions
- Lesson 2: Implementing the GROUP BY Clause
- Lesson 3: Filtering Groups Using HAVING
- Lab: Grouping and Aggregating Data for Government Financial Analysis
Module 10: Utilizing Subqueries
- Lesson 1: Constructing Self-Contained Subqueries
- Lesson 2: Constructing Correlated Subqueries
- Lesson 3: Applying the EXISTS Predicate with Subqueries
- Lab: Using Subqueries for Government Data Validation
Module 11: Utilizing Table Expressions
- Lesson 1: Implementing Views
- Lesson 2: Implementing Inline Table-Valued Functions (TVFs)
- Lesson 3: Implementing Derived Tables
- Lesson 4: Implementing Common Table Expressions (CTEs)
- Lab: Utilizing Table Expressions for Government Query Optimization
Module 12: Using Set Operators
- Lesson 1: Constructing Queries with the UNION Operator
- Lesson 2: Utilizing EXCEPT and INTERSECT
- Lesson 3: Utilizing APPLY
- Lab: Using Set Operators for Government Data Integration
Module 13: Utilizing Window Ranking, Offset, and Aggregate Functions
- Lesson 1: Defining Windows with the OVER Clause
- Lesson 2: Analyzing Window Functions
- Lab: Applying Window Ranking, Offset, and Aggregate Functions for Government Analytics
Module 14: Pivoting and Grouping Sets
- Lesson 1: Constructing Queries with PIVOT and UNPIVOT
- Lesson 2: Working with GROUPING SETS
- Lab: Pivoting and Grouping Sets for Government Summary Reports
Module 15: Executing Stored Procedures
- Lesson 1: Retrieving Data via Stored Procedures
- Lesson 2: Passing Parameters to Stored Procedures
- Lesson 3: Creating Basic Stored Procedures
- Lesson 4: Working with Dynamic SQL
- Lab: Executing Stored Procedures for Government Application Support
Module 16: T-SQL Programming Techniques
- Lesson 1: Core Elements of T-SQL Programming
- Lesson 2: Managing Program Flow
- Lab: Programming with T-SQL for Government Automation Tasks
Module 17: Implementing Error Handling
- Lesson 1: T-SQL Error Handling Strategies
- Lesson 2: Structured Exception Handling
- Lab: Implementing Robust Error Handling for Government Systems
Module 18: Implementing Transactions
- Lesson 1: Transactions and the Database Engine
- Lesson 2: Managing Transaction Control
- Lab: Implementing Transactions for Government Data Integrity Assurance
Requirements
- Fundamental understanding of relational database systems required for government applications.
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.
