Welcome to ONLC Training Centers
  1. Home
  2. Courses
  3. SQL Server
  4. DP-080: Transact-SQL Querying

DP-080: Transact-SQL Querying Course

Class Dates
(click date for class times)
(click Enroll for locations)
4/24-4/25
Class Dates and Times
04/24/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
04/25/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
Last Reg Date4/21
 
5/22-5/23
Class Dates and Times
05/22/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
05/23/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
6/19-6/20
Class Dates and Times
06/19/2025Thursday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
06/20/2025Friday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
Fee:  $1195

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


  1. Home
  2. Courses
  3. SQL Server
  4. DP-080: Transact-SQL Querying

DP-080: Transact-SQL Querying Course

 

Overview

This two-day course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Audience Profile

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.

Job role

Database Administrator

Skills gained

Use SQL Server query tools
Write SELECT statements to retrieve columns from one or more tables
Sort and filter selected data

Course outline

Module 1: Getting Started with Transact-SQL

  • In this module you will learn about the basics of the Transact-SQL (T-SQL) language, as well as general properties and terminology of relational databases. This module will also introduce the basic SELECT statement for retrieving data from a table.
  • Lessons
  • Introduction to Transact-SQL
  • Using the SELECT statement
  • Lab : Get started with SQL Server query tools and writing queries in T-SQL

Module 2: Sorting and Filtering Query Results

  • In the module you will learn how to control what data is returned, the order in which it is returned. You will use the ORDER BY clause, with and without paging. You will learn about various kinds of filters that can be used in the WHERE clause to control which data rows are returned. You will also learn how to manage the results by removing duplicates with DISTINCT.
  • Lessons
  • Sorting query results
  • Filtering the data
  • Lab : Sort and filter data returned by SELECT queries

Module 3: Using Joins and Subqueries

  • In this module, you will explore T-SQL queries which access data from multiple tables with various kinds of JOIN operations and simple subqueries.
  • Lessons
  • Using JOIN operations
  • Using subqueries
  • Lab : Write queries with JOIN operations
  • Lab : Write SELECT statements using subqueries

Module 4: Using Built-in Functions

  • In the module you will explore the use of built-in functions for returning computed or special values in the SELECT list or in the WHERE clause. Functions include math functions, string functions and system functions. There are other types of functions that will be mentioned, but not discussed in detail. You will also learn how to combine rows of data into a single group, providing summary information for the group such as SUM, MIN or MAX.
  • Lessons
  • Getting started with scalar functions
  • Grouping aggregated results
  • Lab : Built-in functions

Module 5: Modifying Data

  • In this module, you will learn the T-SQL statements for modifying table data including UPDATE, DELETE and MERGE as well as various options for INSERT including creating a new table with data from an existing table. You will also look at how to have the system automatically supply values for columns as the data is inserted.
  • Lessons
  • Inserting data into tables
  • Modifying and deleting data
  • Lab : Modify data

 

View outline in Word

ADP080

Attend hands-on, instructor-led DP-080: Transact-SQL Querying training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of SQL Server Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews

HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment


ONLC TRAINING CENTERS
800-288-8221
www.onlc.com
Our Classes
Why Register with ONLC
Other Information
For Companies
For Professionals
For Government
Live Classes from Home or Office
About ONLC
Other Details
Connect