Home > Microsoft Technical
>
DP-080T00 Querying Data with Microsoft Transact-SQL

DP-080T00 Querying Data with Microsoft Transact-SQL

$595 - $1,295

Upgrade your tech skills with this Microsoft Technical training course. Launch your career to the stars with AstraTech IT Certification Training!

Please select a Learning Method below to get started:

There are currently no upcoming course dates scheduled. Please complete the form to request a date/receive schedule update notifications:

On-Demand Learning (ODL) is a self-paced training solution designed to work around your individual schedule, budget, and learning needs. Our ODL courses provide you with exclusive access to interactive platforms combining high-quality instructor videos from subject matter experts, official courseware and study materials, hands-on labs, practice exercises, skill assessments and knowledge checks. The modular, self-paced ODL course structure adapts to your unique learning needs and style, providing an optimal training experience.

$595.00

Train your entire team with our Private Group Training solutions. AstraTech specializes in creating customized training programs to fit your organization’s unique learning needs and business objectives. Take advantage of multiple student discounts, customized curriculum and flexible scheduling with Private Group Training from AstraTech!

Microsoft Technical

Course Highlights

ILT DURATION: 2 Day(s)

SKILL LEVEL:

Intermediate

BRAND/TECHNOLOGY:

Microsoft Technical

TOPICS:

Data & Analytics

DP-080T00 Querying Data with Microsoft Transact-SQL Course Outline

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.

1 – Introduction to Transact-SQL

Work with schemas
Explore the structure of SQL statements
Examine the SELECT statement
Work with data types
Handle NULLs

2 – Sort and filter results in T-SQL

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

3 – Combine multiple tables with JOINs in T-SQL

Understand joins concepts and syntax
Use inner joins
Use outer joins
Use cross joins
Use self joins

4 – Write Subqueries in T-SQL

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

5 – Use built-in functions and GROUP BY in Transact-SQL

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

6 – Modify data with T-SQL

Insert data
Generate automatic values
Update data
Delete data
Merge data based on multiple tables

DP-080T00 Querying Data with Microsoft Transact-SQL

DP-080T00 Querying Data with Microsoft Transact-SQL Course Outline

1 – Introduction to Transact-SQL

2 – Sort and filter results in T-SQL

3 – Combine multiple tables with JOINs in T-SQL

4 – Write Subqueries in T-SQL

5 – Use built-in functions and GROUP BY in Transact-SQL

6 – Modify data with T-SQL

SQL Querying Fundamentals – Part 1

Live, Instructor-Led (ILT)

Power BI for Data-driven Decision Makers

Live, Instructor-Led (ILT)

SQL Querying Fundamentals – Part 2

Live, Instructor-Led (ILT)

Contact Info

Our Company

DP-080T00 Querying Data with Microsoft Transact-SQL

DP-080T00 Querying Data with Microsoft Transact-SQL Course Outline

1 – Introduction to Transact-SQL

2 – Sort and filter results in T-SQL

3 – Combine multiple tables with JOINs in T-SQL

4 – Write Subqueries in T-SQL

5 – Use built-in functions and GROUP BY in Transact-SQL

6 – Modify data with T-SQL

Related Data & Analytics Training Courses

Related products

SQL Querying Fundamentals – Part 1

Live, Instructor-Led (ILT)

Power BI for Data-driven Decision Makers

Live, Instructor-Led (ILT)

SQL Querying Fundamentals – Part 2

Live, Instructor-Led (ILT)

Contact Info

Our Company