1­-855­-778­-7246

Querying Data with Transact-SQL (20761)

 

Course Content

This three-day, instructor led course will give you 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.

Who should attend

  • Database Administrators
  • Database Developers
  • BI professionals

Certifications

This course is part of the following Certifications:

Prerequisites

  • Working knowledge of relational databases
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Course Objectives

  • Describe the basic architecture and concepts of Microsoft SQL Server 2016
  • Understand the similarities and differences between Transact-SQL and other computer languages
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

Follow On Courses

Outline: Querying Data with Transact-SQL (20761)

Module 1: Introduction to Microsoft SQL Server 2016

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio

Module 2: Introduction to T-SQL

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements

Module 3: Writing SELECT Queries

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions

Module 4: Querying Multiple Tables

  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins

Module 5: Sorting and Filtering Data

  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values

Module 6: Working with SQL Server 2016 Data Types

  • Introducing SQL Server 2016 Data Types
  • Working with Character Data
  • Working with Date and Time Data

Module 7: Using DML to Modify Data

  • Inserting Data
  • Modifying and Deleting Data

Module 8: Using Built-In Functions

  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL

Module 9: Grouping and Aggregating Data

  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING

Module 10: Using Subqueries

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries

Module 11: Using Set Operators

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY

Labs

  • Working with SQL Server 2016 Tools
  • Introduction to Transact-SQL Querying
  • Writing Basic SELECT Statements
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2016 Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using SET Operators
Online Training

Duration 5 days

Price
  • CAD 1,750
  • SA Voucher: 3
Classroom Training

Duration 5 days

Price
  • Canada: CAD 1,750
  • SA Voucher: 5
 
Click on town name to book Schedule
This is an Instructor-Led Classroom course
This is a FLEX course, which is delivered both virtually and in the classroom.
  *   This class is delivered by a partner.
Canada

Currently there are no training dates scheduled for this course.  For enquiries please write to info@fastlaneca.com.

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.