Query and modify data with Transact-SQL (DP-080)
- Course Code M-DP080
- Duration 2 days
Course Delivery
Course Delivery
This course is available in the following formats:
-
Company Event
Event at company
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopThis 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.
Virtual Learning
This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.
Course Schedule
TopTarget Audience
TopThis 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.
Course Objectives
TopStudents will learn to,
- Get Started Querying with Transact-SQL
Course Content
TopModule 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