Name: DP-080T00 Querying Data with Microsoft Transact-SQL
Price: 1295.00 EUR
Availability: InStock
Rating: 4.6 (5878 reviews)

Duration:

16.00 hours

13.0 CPD hours

Overview:

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.

Description:

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.

Course Outline:

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

,

1 - Introduction to Transact-SQL

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

2 - Sort and filter results in T-SQL

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

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
Module assessment

4 - Write Subqueries in T-SQL

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

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
Module assessment

6 - Modify data with T-SQL

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

, LAB Outline, Get Started Querying with Transact-SQL, Modify data with T-SQL, Introduction to Transact-SQL, Sort and filter results in T-SQL, Combine multiple tables with JOINs in T-SQL, Write Subqueries in T-SQL, Use built-in functions and GROUP BY in Transact-SQL

What You'll Learn:

Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE., Course ObjectivesUse SQL Server query toolsWrite SELECT statements to retrieve columns from one or more tablesSort and filter selected dataUse built-in functions to returned data valuesCreate groups of data and aggregate the resultsModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE.

Available Delivery Options for DP-080T00 Querying Data with Microsoft Transact-SQL

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

What certification does DP-080T00 Querying Data with Microsoft Transact-SQL prepare you for?

The DP-080T00 Querying Data with Microsoft Transact-SQL course helps prepare you for the Microsoft Applied Skills: Query data using Microsoft Transact-SQL certification path.

Which exam does DP-080T00 Querying Data with Microsoft Transact-SQL prepare you for?

The DP-080T00 Querying Data with Microsoft Transact-SQL prepares you for the 'DP-080' official exam. You can take this exam at any exam center across United Kingdom including London, Manchester, Birmingham, Edinburgh or live online wherever you are.

How many CPD hours does DP-080T00 Querying Data with Microsoft Transact-SQL provide?

The 2 day DP-080T00 Querying Data with Microsoft Transact-SQL course gives you up to 13.0 CPD hours/structured learning hours.

Who is the correct audience for DP-080T00 Querying Data with Microsoft Transact-SQL?

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.

Do you provide training for DP-080T00 Querying Data with Microsoft Transact-SQL?

Yes, we provide corporate training, dedicated training and closed classes for DP-080T00 Querying Data with Microsoft Transact-SQL. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of DP-080T00 Querying Data with Microsoft Transact-SQL?

The DP-080T00 Querying Data with Microsoft Transact-SQL training takes place over 2 day(s), with each day lasting approximately 16.00 hours including breaks.

What other terms do people search for?

Popular related searches include: dp80 dp080 sql fundamentals getting started with sql beginnners sql dp 80 dp 080 querying for beginners, DP-080T00: Query and modify data with Transact-SQL, Microsoft, vILT, DP-080T00

Why are Nexus Human the best provider for DP-080T00 Querying Data with Microsoft Transact-SQL?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for DP-080T00 Querying Data with Microsoft Transact-SQL?

Yes, the discount code PENPAL5 is currently available for DP-080T00 Querying Data with Microsoft Transact-SQL training. Only one discount code can be used per booking.

DP-080T00 Querying Data with Microsoft Transact-SQL