MOC 20761 - Querying Data with Transact-SQL

Customized Onsite Training

3
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

$1,425.00
or 3 vouchers
  • Live Online Training
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

Upcoming Classes

  • See More Classes

Please select a class.
Overview

The main purpose of this 3-day Querying Data with Transact-SQL training class 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.

The course will very likely be well attended by SQL power users who aren't necessarily database-focused; namely, report writers, business analysts and client application developers.

Goals
  1. Learn to describe the basic architecture and concepts of Microsoft SQL Server 2016.
  2. Learn to understand the similarities and differences between Transact-SQL and other computer languages.
  3. Learn to write SELECT queries.
  4. Learn to query multiple tables.
  5. Learn to sort and filter data.
  6. Learn to describe the use of data types in SQL Server.
  7. Learn to modify data using Transact-SQL.
  8. Learn to use built-in functions.
  9. Learn to group and aggregate data.
  10. Learn to use subqueries.
  11. Learn to use table expressions.
  12. Learn to use set operators.
  13. Learn to use window ranking, offset and aggregate functions.
  14. Learn to implement pivoting and grouping sets.
  15. Learn to execute stored procedures.
  16. Learn to program with T-SQL.
  17. Learn to implement error handling.
  18. Learn to implement transactions.
Outline
  1. Introduction to Microsoft SQL Server 2016
    1. The Basic Architecture of SQL Server
    2. SQL Server Editions and Versions
    3. Getting Started with SQL Server Management Studio
    4. Lab: Working with SQL Server 2016 Tools
  2. Introduction to T-SQL Querying
    1. Introducing T-SQL
    2. Understanding Sets
    3. Understanding Predicate Logic
    4. Understanding the Logical Order of Operations in SELECT statements
    5. Lab: Introduction to Transact-SQL Querying
  3. Writing SELECT Queries
    1. Writing Simple SELECT Statements
    2. Eliminating Duplicates with DISTINCT
    3. Using Column and Table Aliases
    4. Writing Simple CASE Expressions
    5. Lab: Writing Basic SELECT Statements
  4. Querying Multiple Tables
    1. Understanding Joins
    2. Querying with Inner Joins
    3. Querying with Outer Joins
    4. Querying with Cross Joins and Self Joins
    5. Lab: Querying Multiple Tables
  5. Sorting and Filtering Data
    1. Sorting Data
    2. Filtering Data with Predicates
    3. Filtering with the TOP and OFFSET-FETCH Options
    4. Working with Unknown Values
    5. Lab: Sorting and Filtering Data
  6. Working with SQL Server 2016 Data Types
    1. Introducing SQL Server 2016 Data Types
    2. Working with Character Data
    3. Working with Date and Time Data
    4. Lab : Working with SQL Server 2016 Data Types
  7. Using DML to Modify Data
    1. Inserting Data
    2. Modifying and Deleting Data
    3. Lab: Using DML to Modify Data
  8. Using Built-In Functions
    1. Writing Queries with Built-In Functions
    2. Using Conversion Functions
    3. Using Logical Functions
    4. Using Functions to Work with NULL
    5. Lab: Using Built-In Functions
  9. Grouping and Aggregating Data
    1. Using Aggregate Functions
    2. Using the GROUP BY Clause
    3. Filtering Groups with HAVING
    4. Lab: Grouping and Aggregating Data
  10. Using Subqueries
    1. Writing Self-Contained Subqueries
    2. Writing Correlated Subqueries
    3. Using the EXISTS Predicate with Subqueries
    4. Lab: Using Subqueries
  11. Using Set Operators
    1. Writing Queries with the UNION Operator
    2. Using EXCEPT and INTERSECT
    3. Using APPLY
    4. Lab: Using SET Operators
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
Preparing for Class
Certifications
Follow-on Courses

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

74,839

Students who have taken Live Online Training

15,233

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

10.00

Students rated our MOC 20761 - Querying Data with Transact-SQL trainers 10.00 out of 10 based on 1 reviews

Contact Us or call 1-877-932-8228