1­-855­-778­-7246
> > > MOC 20761

Querying Data with Transact-SQL

 

Product Description

This self-paced 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

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

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
E-Learning MOC on Demand
Price
  • US$ 795

Subscription duration: 90 days
Grace period: 3 months

 
...