Course DP-080T00: Querying Data with Transact SQL course
Microsoft Certified Trainers • Microsoft Official Curriculum
Instructor-led Querying Data with Microsoft Transact SQL training
On our two-day Querying Data with Transact SQL course, you’ll learn how to use the Transact SQL language for areas including:
- database administration
- database development
- business intelligence
Our Microsoft Certified Trainers will teach the Transact SQL skills you need to succeed with SQL in an enterprise context.
- Plenty of student-trainer interaction, thanks to small class sizes
- Learn from top-rated technical trainers (satisfaction rate of 96 percent)
- Take Transact SQL training from anywhere with our virtual classroom
- Get real-life Transact SQL tips beyond the official Microsoft curriculum
- Have the course content and delivery tailored to you and your company
Our student satisfaction rating
Based on feedback from 20,000 students in the UK and worldwide.
Microsoft Transact SQL certification
The Querying Data with Transact SQL course was developed to prepare students for the Microsoft 70-761 exam. Although this exam has been retired, this course is still valuable for IT professionals who want to work with SQL. With this official Microsoft course, you’ll show employers and colleagues you have the skills needed to use Transact SQL professionally.
The benefits of Transact SQL training
£60kaverage salary for an SQL database administrator (2021)
23%of Microsoft certified staff earn up to 20 percent more than peers
49%of IT techs think Microsoft certifications boost employability
By the end of this Transact SQL training, you will know all about:
- Use SQL Server query tools
- Write SELECT statements to retrieve columns from one or more tables
- Sort and filter selected data
- Use built-in functions to returned data values
- Create groups of data and aggregate the results
- Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Who will benefit
This Microsoft Transact SQL course is ideal for database administrators, database developers, and BI professionals. You will learn how to use the Transact SQL language to perform all the common tasks performed with SQL Server.
Applicable job roles
Database administrator, database developer, BI professional.
To benefit from this Transact SQL training, students should have:
- basic knowledge of the Windows operating system and its core functionality
- working knowledge of relational databases
Unsure if this course is right for you? Ask for advice from our training team.
Module 1: Getting started with Transact-SQL
Module 2: Sorting and Filtering Query Results
Module 3: Using Joins and Subqueries
Module 4: Using Built-in Functions
Module 5: Modifying Data
Keen to know more about the course content? Get in touch and our training team will be happy to fill you in.
Interested in this course?
Fill in the form below and a member of our sales team will call you back within the next working day.
“The trainer’s real world experience helped make the content relatable and applicable to my needs.”
— Chris B, Falmouth Exeter Plus, 03.03.2021
Our training clients
FAQ about Querying Data with Transact SQL
How will I benefit from this Transact SQL course?
As an IT professional, you’ll gain enterprise-grade skills in Transact SQL. This is a valuable asset for millions of companies globally. And the fact that you’ve taken an official Microsoft course shows that you really have the knowledge required.
In terms of the job market, there is always a demand for SQL administrators and BI professionals. This is a lucrative role that offers many career paths for a qualified IT professional.
What will my company gain from training me in Transact SQL?
Ninety percent of employees who take official Microsoft courses report an increase in work productivity afterwards. On top of this, having Microsoft-certified staff is a recognised mark of quality. The Microsoft certification badges inspire trust among clients and team members.
What is the advantage of instructor-led Transact SQL training?
When you learn from Microsoft Certified Trainers (MCT) who are also real-life Windows technicians, you benefit from their accumulated expertise. Our trainers combine the professional standards of MCT with the practical knowledge of Windows engineers. This gives you the best of both worlds: the Microsoft Official Curriculum and the tips and tricks you need to succeed in the field.
How does Influential's virtual classroom training work?
Our virtual classroom is the closest thing to training at our London centre, but without the need to travel. We run our virtual training on Cisco Webex, a platform used by 130 million professionals every month.
You can interact with the trainer throughout each session via your webcam and microphone. All our virtual training provides the same skills and certifications as the classroom courses.
Want to hear more from us?
Follow us on social:
TEL: 0203 507 1728
Office hours 09:00 - 17:30
Closed bank holidays
1 St Katharine's Way