DP-080: Querying Data with Microsoft Transact-SQL

Job role: Database Administrator

Course Level: Beginner

Start Date: Contact Us

Duration: 2 Days

Format: Instructor-Led

shutterstock_220546897

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

Audience Profile

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.

Course Outline

Related Courses

PL-400: Microsoft Power Platform Developer

PL-400: Microsoft Power Platform Developer Candidates for this exam design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution, including application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Microsoft…

PL-200: Microsoft Power Platform Functional Consultant

PL-200: Microsoft Power Platform Functional Consultant Candidates for this exam perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Microsoft Power Platform solutions and apps. They create application enhancements, custom user experiences, system integrations, data…

PL-900: Microsoft Power Platform Fundamentals

PL-900: Microsoft Power Platform Fundamentals Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences. Microsoft Certified: Power Platform Fundamentals…

Build An In-house Team Of Cloud Experts With Dedicated Courses!

Learn fundamental to advanced skills using Azure, Microsoft 365, and related business applications. Meet with a Microsoft Certified Training Specialist to design a custom learning plan for your organization!