DP-080 Querying Data with Microsoft Transact-SQL Course

Transact-SQL is the language that sits underneath almost every Microsoft data role. Being able to query and modify data confidently is one of the most portable skills in the industry, useful whether you analyse data in Power BI, build and maintain databases, or move into data engineering. DP-080 proves you can do the practical work: read data out of relational tables, shape it with joins and functions, and change it safely. It is an entry point on the data career path, and it leads naturally toward database administration with DP-300 and toward data analytics roles.

Choosing Logitrain for the DP-080 Querying Data with Microsoft Transact-SQL course gives you a Certificate of Attendance to evidence your training, the full digital course material to keep, and a small class for personalised attention from experienced trainers. The price beat guarantee means you will not pay more than a competitor’s advertised price for the same course. You can attend in-person in Melbourne, Sydney or Brisbane, or join live online from anywhere in Australia, with Adelaide, Perth and Canberra available in person on request. Every session is live and real time with a trainer, never a recording.

There are no hard prerequisites for this course. To get the most from it, Microsoft recommends a basic knowledge of the Windows operating system and its core functionality, and a working knowledge of relational databases (what tables, rows and columns are). You do not need any prior SQL or Transact-SQL experience, as the course starts from the fundamentals.

If you are completely new to data concepts and want a gentler on-ramp first, the broader Microsoft training courses range includes foundational data options. For most learners, DP-080 is itself the correct starting point for SQL.

There is no certification exam associated with this course. You receive a Certificate of Attendance on completion to evidence your training.

The digital course material for DP-080T00 Querying Data with Microsoft Transact-SQL is included and yours to keep. It is provided in digital format for flexible reference during and after the course.

• Use SQL Server query tools to write and run Transact-SQL
• Write SELECT statements to retrieve columns from one or more tables
• Understand relational database concepts, data types and NULL values
• Sort query results using ORDER BY
• Filter rows with WHERE, predicates and pattern matching
• Combine tables using INNER, OUTER and CROSS JOIN operations
• Write subqueries, including correlated and self-contained subqueries
• Apply built-in scalar and aggregate functions to return data values
• Group and summarise data with GROUP BY and HAVING
• Insert new rows into existing tables
• Modify data using the UPDATE statement
• Delete data using the DELETE statement
• Modify data efficiently using MERGE

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

• Data Analysts
• Data Engineers
• Data Scientists
• Database Administrators
• Database Developers
• Business Intelligence and Reporting Professionals
• Solution Architects
• Software Developers who work with databases
• Career changers moving into data and database roles
• Students and technology managers who want practical SQL skills

This is a beginner-level course, so it suits people new to SQL as well as experienced staff who want to formalise their Transact-SQL skills.

• Get started with Transact-SQL: relational database concepts, the SELECT statement, data types and NULL values
• Sort and filter query results: ORDER BY, WHERE, TOP, DISTINCT and paging
• Combine multiple tables with joins: INNER JOIN, OUTER JOIN and CROSS JOIN
• Write subqueries: scalar and multi-valued, correlated and self-contained subqueries
• Use built-in functions and GROUP BY: scalar functions, aggregate functions, grouping and HAVING
• Modify data with Transact-SQL: INSERT, UPDATE, DELETE and MERGE
• Practise writing and executing Transact-SQL against Microsoft SQL Server and Azure SQL Database

• DP-300 Administering Microsoft Azure SQL Solutions course: the clear next step after DP-080 for anyone heading toward database administration on Azure.
• Microsoft training courses: the full Microsoft range, including Azure, data and Power Platform options to continue your path.
• Database Job Ready Program: training, certifications, internship and career counselling combined into a guided route into a database role.
• Data Analytics Job Ready Program: ideal if SQL is your entry into a data analyst career, pairing T-SQL with business intelligence and reporting skills.
• One-on-one training: private DP-080 training scheduled around you, useful if you want a faster or more tailored pace.

Got a team to train? Logitrain can deliver the DP-080 Querying Data with Microsoft Transact-SQL course in house at your premises anywhere in Australia, with the same trainer, course material and hands-on labs as the public courses. In-house delivery suits teams who want everyone learning the same SQL skills together, on dates that suit the business, with content focused on the data your people actually work with. Visit in-house training to discuss your team’s needs.

What is the DP-080 Querying Data with Microsoft Transact-SQL course?

DP-080 is a two-day beginner course that teaches Transact-SQL, the Microsoft dialect of SQL. You learn to query and modify data in Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics and Microsoft Fabric. Microsoft has renamed it Query and Modify Data with Transact-SQL, and this page covers that current version.

Does DP-080 include a certification exam?

No. DP-080 does not have a certification exam and is not a certification. You receive a Certificate of Attendance to evidence your training, and the digital course material is yours to keep.

What are the prerequisites for DP-080?

There are no hard prerequisites. Microsoft recommends a basic knowledge of the Windows operating system and a working knowledge of relational databases. No prior SQL experience is needed, as the course starts from the fundamentals.

Which version of the course is this?

This is the current Microsoft course, code DP-080T00 (revision DP-080T00-A), now titled Query and Modify Data with Transact-SQL. It replaces older Transact-SQL courses such as Microsoft 20761B.

How long is the DP-080 course?

It runs for two days full-time, from 9:30 am to 5 pm. You can also take it part-time over two weeks, either on weeknights from 6 pm to 9 pm or on weekends from 10 am to 5 pm.

Where can I take the DP-080 course?

In-person in Melbourne, Sydney, Brisbane, Adelaide, Perth and Canberra, plus live online across Australia, all delivered live in real time with a trainer. Adelaide, Perth and Canberra are available in person on request.

How much does the DP-080 course cost?

Pricing is shown in the schedule on this page, and the price beat guarantee means you will not pay more than a competitor’s advertised price for the same course. Contact Logitrain for the current dates and price.

Should I do DP-080 or DP-300 first?

Start with DP-080 if you are new to SQL, as it builds the core querying and data-modification skills. Move on to the DP-300 Administering Microsoft Azure SQL Solutions course once you want to administer databases on Azure.