Querying Data with Microsoft Transact-SQL

Querying Data with Microsoft Transact-SQL (DP-080T00)

Course Length: 2 days
Delivery Methods: Multiple delivery options
Course Overview

This course provides a detailed introduction to Transact-SQL (T-SQL), the powerful language used for managing and manipulating data in SQL Server. Designed for data professionals, developers, and anyone interested in SQL Server, this course covers essential T-SQL skills, including querying, sorting, filtering, joining tables, and modifying data.

The course begins with an Introduction to Transact-SQL, where you'll learn to work with schemas, understand the structure of SQL statements, and explore the SELECT statement. You’ll also learn about data types and how to handle NULL values, providing a solid foundation in the basics of T-SQL.

Next, in the Sort and Filter Results in T-SQL module, you’ll explore techniques for sorting, limiting, and paging results. You’ll learn to remove duplicates and filter data using predicates, equipping you with the skills to refine query results and display data that meets specific criteria.

The Combine Multiple Tables with JOINs in T-SQL section covers the concepts and syntax of various JOIN operations. You’ll learn how to use inner joins, outer joins, cross joins, and self joins, allowing you to combine data from multiple tables to create comprehensive query results.

In the Write Subqueries in T-SQL module, you'll dive into subqueries, exploring scalar and multi-valued subqueries as well as self-contained and correlated subqueries. These skills are essential for writing complex queries that can dynamically filter and shape your data.

The Use Built-in Functions and GROUP BY in Transact-SQL section covers the use of scalar, ranking, rowset, and aggregate functions. You’ll learn to summarize data using the GROUP BY clause and filter groups with the HAVING clause, enabling you to perform advanced data analysis directly within your queries.

The course concludes with Modify Data with T-SQL, where you’ll learn how to insert, update, and delete data within your tables. You’ll also explore generating automatic values and using the MERGE statement to modify data based on multiple tables, providing you with the tools to manage data efficiently and accurately.

By the end of this course, you will have developed a solid understanding of Transact-SQL, enabling you to write efficient and complex queries, manipulate data, and manage SQL Server databases effectively. You’ll be equipped with the skills needed to handle a wide range of data-related tasks in SQL Server environments.

Course Benefits
  • Use SQL Server query tools.
  • Write SELECT statements to retrieve columns from one or more tables.
  • Sort and filter selected data.
  • Use built-in functions to returned data values.
  • Create groups of data and aggregate the results.
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Course Outline
  1. Introduction to Transact-SQL
    1. Work with schemas
    2. Explore the structure of SQL statements
    3. Examine the SELECT statement
    4. Work with data types
    5. Handle NULLs
  2. Sort and filter results in T-SQL
    1. Sort your results
    2. Limit the sorted results
    3. Page results
    4. Remove duplicates
    5. Filter data with predicates
  3. Combine multiple tables with JOINs in T-SQL
    1. Understand joins concepts and syntax
    2. Use inner joins
    3. Use outer joins
    4. Use cross joins
    5. Use self joins
  4. Write Subqueries in T-SQL
    1. Understand subqueries
    2. Use scalar or multi-valued subqueries
    3. Use self-contained or correlated subqueries
  5. Use built-in functions and GROUP BY in Transact-SQL
    1. Categorize built-in functions
    2. Use scalar functions
    3. Use ranking and rowset functions
    4. Use aggregate functions
    5. Summarize data with GROUP BY
    6. Filter groups with HAVING
  6. Modify data with T-SQL
    1. Insert data
    2. Generate automatic values
    3. Update data
    4. Delete data
    5. Merge data based on multiple tables
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

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

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
Live Public Class
$1,269.10 / student
Please select a class.
Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal