Query and modify data with Transact-SQL (DP-080) [M-DP080]
- Total time
- Location
- At location, Online
- Starting date and place
Query and modify data with Transact-SQL (DP-080) [M-DP080]
Provider rating:
Starting dates and places
computer Online: VIRTUAL TRAINING CENTER 1 Apr 2026 until 2 Apr 2026 |
place(Virtual Training Centre) 23 Apr 2026 until 24 Apr 2026 |
computer Online: VIRTUAL TRAINING CENTER 2 Jul 2026 until 3 Jul 2026 |
place(Virtual Training Centre) 9 Jul 2026 until 10 Jul 2026 |
computer Online: VIRTUAL TRAINING CENTER 1 Oct 2026 until 2 Oct 2026 |
place(Virtual Training Centre) 8 Oct 2026 until 9 Oct 2026 |
Description
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.
OBJECTIVES
Students will learn to,
- Get Started Querying with Transact-SQL
AUDIENCE
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 invol…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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.
OBJECTIVES
Students will learn to,
- Get Started Querying with Transact-SQL
AUDIENCE
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.
CONTENT
Module 1: Query and modify data with Transact-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
- Modify data with T-SQL
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.