Home
Courses
Querying Data with Microsoft Transact-SQL Training (DP-080)

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

Course 8597

Duration: 2 days
Language: English
Level: Foundation

This 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.

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.

Microsoft Transact-SQL Training (DP-080) Delivery Methods

In-Person
Online

Microsoft Transact-SQL Training (DP-080) Course Information

In this course, you will learn how to:

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.

Prerequisites

None.

Microsoft Transact-SQL Training (DP-080) Training Outline

Module 1: Introduction to Transact-SQL

This module provides an introduction to relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.

After completing this module, you'll be able to:

Understand what SQL is for
Identify database objects in schemas
Identify SQL statement types
Use the SELECT statement
Work with data types
Handle NULLs

Module 2: Sort and filter results in T-SQL

Learn how to sort and filter query results

After completing this module, you will be able to:

Sort your results
Limit the sorted results
Return paged results
Remove duplicates
Filter data with predicates

Module 3: Combine multiple tables with JOINs in T-SQL

Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.

After completing this module, you will be able to:

Describe join concepts and syntax
Write queries that use inner and outer joins
Write queries that use cross joins
Write queries that use self joins

Module 4: Write Subqueries in T-SQL

Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.

After completing this module, you will be able to:

Understand what subqueries are
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries

Module 5: Use built-in functions and GROUP BY in Transact-SQL

Learn how to use functions in Transact-SQL, and how to group aggregated results.

After completing this module, you will be able to:

Categorise built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarise data with GROUP BY
Filter groups with HAVING

Module 6: Modify data with T-SQL

Learn how to use Transact-SQL to insert, update, and delete data in a database.

After completing this module, you will be able to:

Insert data into a table
Generate automatic values
Update data in a table
Delete data from a table
Merge data based on multiple tables

Get This Course 17 430 kr

2-Day Instructor-Led Training Course
Microsoft Official Course content
After-course instructor coaching included

Get the Advantage 37 295 kr

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

Include dates with afternoon start times

#8597

feb 3 - 4 15:00 - 22:30 CET

Herndon, VA or AnyWare
mar 24 - 25 10:00 - 17:30 CET

London or AnyWare
mar 24 - 25 9:00 - 16:30 CET

Stockholm or AnyWare
apr 28 - 29 15:00 - 22:30 CEST

Herndon, VA or AnyWare
jun 23 - 24 10:00 - 17:30 CEST

London or AnyWare
jun 23 - 24 9:00 - 16:30 CEST

Stockholm or AnyWare
aug 11 - 12 15:00 - 22:30 CEST

Herndon, VA or AnyWare
sep 22 - 23 10:00 - 17:30 CEST

London or AnyWare
sep 22 - 23 9:00 - 16:30 CEST

Stockholm or AnyWare
dec 8 - 9 9:00 - 16:30 CET

Stockholm or AnyWare
dec 8 - 9 10:00 - 17:30 CET

London or AnyWare

Scroll to view additional course dates

Bring this or any training to your organisation
Full-scale programme development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

Get the Advantage 37 295 kr

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#8597

Questions about this course?

Customise Your Team Training Experience

Fill out the form below or call +46 (0)8 506 668 00

* Required Fields

Preferred method of contact:

Phone

Email

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Microsoft Transact-SQL Training (DP-080) Course FAQs

Yes! This class will help you write basic SQL or Transact-SQL queries.

Yes! This is a beginner class for anyone who needs to write basic SQL or Transact-SQL queries.