View all courses

Learn basic Transact-SQL queries for Microsoft SQL Server. This 2-day instructor-led course will teach participants 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.

Target 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.

What You'll Learn

  • Use SQL Server query tools
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data

*Request Detailed Syllabus

Register for this course
View all courses
  • Course Number DP-080
  • Course Length 2 days
  • Course Fee $1,295.00
  • Delivery Format VLT (Instructor Led; Virtual LIVE Online; Remote Training)
  • Course Topic Data Management and Analytics
  • Vendor Microsoft
  • Technology SQL Server
Need a different date? This course is also offered on these dates
Date Course ID Course Name Duration Delivery Format Registration
09/27/2022 DP-080 Querying Data with Microsoft Transact-SQL (DP-080) 2 days VLT Register
12/20/2022 DP-080 Querying Data with Microsoft Transact-SQL (DP-080) 2 days VLT Register

Register for course: DP-080

"*" indicates required fields

Training Agreement*
This field is for validation purposes and should be left unchanged.