Query and modify data with Transact-SQL Training (DP-080)

Course 8597 Advantage Plan Course

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, Azure Synapse Analytics, and Microsoft Fabric.

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.

Query and modify data with Transact-SQL Training (DP-080) Delivery Methods

In-Person
Online

Query and modify data with 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.

Query and modify data with Transact-SQL Training (DP-080) 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:

Categorize built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarize 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

Commercial Pricing

£1,415

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

Would you like to take this course as a team?

Include dates with afternoon start times

Dec 7 - 8 9:00 am - 4:30 pm GMT

London or AnyWare
Jan 25 - 26 2:00 pm - 9:30 pm GMT

Herndon, VA or AnyWare
Mar 24 - 25 9:00 am - 4:30 pm GMT

London or AnyWare
Apr 26 - 27 2:00 pm - 9:30 pm BST

Herndon, VA or AnyWare
Jun 23 - 24 9:00 am - 4:30 pm BST

London or AnyWare
Jul 19 - 20 2:00 pm - 9:30 pm BST

Herndon, VA or AnyWare

Speak with a Learning Consultant

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Query and modify data with Transact-SQL Training (DP-080) 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.