Microsoft Query and modify data with Transact-SQL (DP-080)

On this accelerated Microsoft Query and modify data with Transact-SQL (DP-080) course, you will learn 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, Azure Synapse Analytics, and Microsoft Fabric.

Through Firebrand’s Lecture | Lab | Review method, you’ll get certified faster than with traditional training and access official courseware, learn from certified instructors, and train in a distraction-free environment.

This course is ideal for:

• Anyone who needs to write basic SQL or Transact-SQL queries
• Anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer
• Anyone involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.

• Module 1: Introduction to Transact SQL
• Module 2: Sort and filter results in T SQL
• Module 3: Combine multiple tables with JOINs in T SQL
• Module 4: Write Subqueries in T SQL
• Module 5: Use built-in functions and GROUP BY in Transact SQL
• Module 6: Modify data with T SQL

There is no exam for this course.

Before attending this accelerated course, you should be familiar with working with tables of data – for example, in a spreadsheet.

Your accelerated course includes:

• Accommodation *
• Meals, unlimited snacks, beverages, tea and coffee *
• On-site exams **
• Exam vouchers **
• Practice tests **
• Certification Guarantee ***
• Courseware
• Up to 12 hours of instructor-led training each day
• 24-hour lab access
• Digital courseware **

* For residential training only. Accommodation is included from the night before the course starts. This doesn't apply to online courses.
** Some exceptions apply. Please refer to the Exam Track or speak with our experts.
*** Pass the first time or train again for free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.

Seven reasons why you should sit your course with Firebrand Training

• Two training options. Choose between residential classroom-based and online courses
• You'll be certified fast. With us, you’ll be trained in record time
• Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
• Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
• You’ll learn more. A day with a traditional training provider generally runs from 9am–5pm, with a nice long break for lunch. With Firebrand, you’ll get at least 12 hours/day of quality learning time with your instructor
• You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
• You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals

*For residential training only. Doesn't apply for online courses
**Some exceptions apply. Please refer to the Exam Track or speak with our experts

Are you ready for the course? 

Get access to free practice tests for your course  Free Practice Test