Courses > Microsoft > SQL Server > Querying Data with Transact SQL

Course DP-080T00: Querying Data with Transact SQL course

Microsoft Certified Trainers • Microsoft Official Curriculum

Microsoft Gold Partner logo for Influential Training

Duration:

Two days

Delivery:

Instructor-led

Format:

Virtual course

Price:

£1150 (+VAT)

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.

Like to know more?

If you’re ready to book, you can look at the scheduled course dates. Or if you’d like to learn more, please send an enquiry to our Microsoft training team.

Like to know more?

If you’re ready to book, you can look at the scheduled course dates. Or if you’d like to learn more, please send an enquiry to our Microsoft training team.

Make an enquiry


  1. Plenty of student-trainer interaction, thanks to small class sizes
  2. Learn from top-rated technical trainers (satisfaction rate of 96 percent)
  3. Take Transact SQL training from anywhere with our virtual classroom
  4. Get real-life Transact SQL tips beyond the official Microsoft curriculum
  5. 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 Certified Fundamentals badge for Microsoft Azure Fundamentals Course

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

£60k

average 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

Learning goals

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

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.

Prerequisites

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.  

Course outline

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.

    *Required


    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    “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

    Government Digital Service - Influential Training client
    Middlesex University - Influential Software client
    Gilead - Influential client
    CERN - Influential client
    US Embassy London - Influential Training client
    The American School in London - Influential Training client

    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.

    influential logo for it training

    Want to hear more from us?
    Follow us on social:

    TEL: 0203 507 1728

    Office hours 09:00 - 17:30
    Monday-Friday
    Closed bank holidays

    LONDON TRAINING CENTRE

    50 Liverpool Street,
    London
    EC2M 7PY