TypeClassroom Training
Time5 Days

Contact Us

Fields marked with an * are required
Querying Data with Transact SQL Training Course & Certification

Querying Data with Transact SQL Training Course & Certification


Audience & Prerequisites


Querying Data with Transact SQL Training Overview

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Objectives of Querying Data with Transact SQL Training

  • Describe key capabilities and components of SQL Server 2016.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to combine query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.

Intended Audience for Objectives of Querying Data with Transact – SQL

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

For more info kindly contact us.

Section 1Introduction to Microsoft SQL Server 2016
Lecture 1The Basic Architecture of SQL Server
Lecture 2SQL Server Editions and Versions
Lecture 3Getting Started with SQL Server Management Studio
Section 2Introduction to T-SQL Querying
Lecture 4Introducing T-SQL
Lecture 5Understanding Sets
Lecture 6Understanding Predicate Logic
Lecture 7Understanding the Logical Order of Operations in SELECT statements
Section 3Writing SELECT Queries
Lecture 8Writing Simple SELECT Statements
Lecture 9Eliminating Duplicates with DISTINCT
Lecture 10Using Column and Table Aliases
Lecture 11Writing Simple CASE Expressions
Section 4Querying Multiple Tables
Lecture 12Understanding Joins
Lecture 13Querying with Inner Joins
Lecture 14Querying with Outer Joins
Lecture 15Querying with Cross Joins and Self Joins
Section 5Sorting and Filtering Data
Lecture 16Sorting Data
Lecture 17Filtering Data with Predicates
Lecture 18Filtering Data with TOP and OFFSET-FETCH
Lecture 19Working with Unknown Values
Section 6Working with SQL Server 2016 Data Types
Lecture 20Introducing SQL Server 2016 Data Types
Lecture 21Working with Character Data
Lecture 22Working with Date and Time Data
Section 7Using DML to Modify Data
Lecture 23Inserting Data
Lecture 24Modifying and Deleting Data
Section 8Using Built-In Functions
Lecture 25Writing Queries with Built-In Functions
Lecture 26Using Conversion Functions
Lecture 27Using Logical Functions
Lecture 28Using Functions to Work with NULL
Section 9Grouping and Aggregating Data
Lecture 29Using Aggregate Functions
Lecture 30Using the GROUP BY Clause
Lecture 31Filtering Groups with HAVING
Section 10Using Subqueries
Lecture 32Writing Self-Contained Subqueries
Lecture 33Writing Correlated Subqueries
Lecture 34Using the EXISTS Predicate with Subqueries
Section 11Using Table Expressions
Lecture 35Using Views
Lecture 36Using Inline Table-Valued Functions
Lecture 37Using Derived Tables
Lecture 38Using Common Table Expressions
Section 12Using Set Operators
Lecture 39Writing Queries with the UNION operator
Lecture 40Using EXCEPT and INTERSECT
Lecture 41Using APPLY
Section 13Using Windows Ranking, Offset, and Aggregate Functions
Lecture 42Creating Windows with OVER
Lecture 43Exploring Window Functions
Section 14Pivoting and Grouping Sets
Lecture 44Writing Queries with PIVOT and UNPIVOT
Lecture 45Working with Grouping Sets
Section 15Executing Stored Procedures
Lecture 46Querying Data with Stored Procedures
Lecture 47Passing Parameters to Stored procedures
Lecture 48Creating Simple Stored Procedures
Lecture 49Working with Dynamic SQL
Section 16Programming with T-SQL
Lecture 50T-SQL Programming Elements
Lecture 51Controlling Program Flow
Section 17Implementing Error Handling
Lecture 52Implementing T-SQL error handling
Lecture 53Implementing structured exception handling
Section 18Implementing Transactions
Lecture 54Transactions and the database engines
Lecture 55Controlling transactions