Overview of Course

The DP-080T00: Querying Data with Microsoft Transact-SQL course teaches you how to query data using Transact-SQL in a Microsoft SQL Server database. This course is designed for database administrators and developers who need to retrieve and manipulate data in a SQL Server database.

Watch Full Course

Course Highlights

Highlight Icon

Learn to write and execute Transact-SQL queries

Highlight Icon

Gain hands-on experience with SQL Server Management Studio

Highlight Icon

Understand common table expressions and window functions

Key Differentiators

  • Checked Icon

    Personalized Learning with Custom Curriculum

    Training curriculum to meet the unique needs of each individual

  • Checked Icon

    Trusted by over 100+ Fortune 500 Companies

    We help organizations deliver right outcomes by training talent

  • Checked Icon

    Flexible Schedule & Delivery

    Choose between virtual/offline with Weekend options

  • Checked Icon

    World Class Learning Infrastructure

    Our learning platform provides leading virtual training labs & instances

  • Checked Icon

    Enterprise Grade Data Protection

    Security & privacy are an integral part of our training ethos

  • Checked Icon

    Real-world Projects

    We work with experts to curate real business scenarios as training projects

Contact Learning Advisor!

Inquiry for :

Skills You’ll Learn


Writing and executing Transact-SQL queries


Retrieving and manipulating data in a SQL Server database


Working with common table expressions and window functions


Creating and executing stored procedures


Debugging and troubleshooting Transact-SQL code

Training Options

Training Vector
Training Vector
Offer Vector

1-on-1 Training

INR 15000/USD 200
  • Option Item Access to live online classes
  • Option Item Flexible schedule including weekends
  • Option Item Hands-on exercises with virtual labs
  • Option Item Session recordings and learning courseware included
  • Option Item 24X7 learner support and assistance
  • Option Item Book a free demo before you commit!
Offer Vector

Corporate Training

  • Option Item Everything in 1-on-1 Training plus
  • Option Item Custom Curriculum
  • Option Item Extended access to virtual labs
  • Option Item Detailed reporting of every candidate
  • Option Item Projects and assessments
  • Option Item Consulting Support
  • Option Item Training aligned to business outcomes
For Corporates
vectorsg Unlock Organizational Success through Effective Corporate Training: Enhance Employee Skills and Adaptability
  • Choose customized training to address specific business challenges and goals, which leads to better outcomes and success.
  • Keep employees up-to-date with changing industry trends and advancements.
  • Adapt to new technologies & processes and increase efficiency and profitability.
  • Improve employee morale, job satisfaction, and retention rates.
  • Reduce employee turnovers and associated costs, such as recruitment and onboarding expenses.
  • Obtain long-term organizational growth and success.

Course Reviews


  • Overview of Transact-SQL
  • Using SELECT statement
  • Introduction to SQL Server query tools
  • Writing queries in T-SQL

  • Sorting query results
  • Filtering data using WHERE
  • Sorting and filtering data returned by SELECT queries

  • Using JOIN operations to combine data
  • Using subqueries to filter data
  • Writing queries with JOIN operations
  • Writing SELECT statements using subqueries

  • Getting started with scalar functions
  • Grouping aggregated results
  • Built-in functions for data manipulation

  • Inserting data into tables
  • Updating and deleting data in tables.
Hanger Icon
Contact Learning Advisor
  • RedtickMeet the instructor and learn about the course content and teaching style.
  • RedtickMake informed decisions about whether to enroll in the course or not.
  • RedtickGet a perspective with a glimpse of what the learning process entails.
Phone Icon
Contact Us
(Toll Free)
Inquiry for :


Section Icon

Target Audience:

  • Database administrators
  • Developers
  • Data analysts
  • Data scientists
Section Icon


  • Familiarity with relational database concepts
  • Basic knowledge of SQL Server
Section Icon

Benefits of the course:

  • Learn to query data using Transact-SQL in a SQL Server database
  • Gain hands-on experience with SQL Server Management Studio
  • Prepare for the Microsoft Certified: Azure Database Administrator Associate certification exam
  • Increase your career prospects
Section Icon

Exam details to pass the course:

  • Exam Name: Microsoft Certified: Azure Database Administrator Associate
  • Exam Code: DP-300
  • Exam format: Multiple choice questions
  • Exam duration: 180 minutes
  • Passing score: 700/1000
  • Exam fee: $165
Section Icon

Certification path:

  • Microsoft Certified: Azure Database Administrator Associate
Section Icon

Career options after doing the course:

  • Database Administrator
  • SQL Developer
  • Data Analyst
  • Data Scientist
  • Business Intelligence Developer

Why should you take this course from Skillzcafe:

Why should you take this course from Skillzcafe:
  • Bullet Icon Expert instructors with industry experience
  • Bullet Icon Hands-on labs and exercises
  • Bullet Icon Flexible learning options
  • Bullet Icon Interactive and engaging content
  • Bullet Icon Preparation for the certification exam
  • Bullet Icon Lifetime access to course materials


DP-080T00 is a course offered by Microsoft that teaches participants how to use Transact-SQL to query and manipulate data in Microsoft SQL Server.

This course is designed for individuals who work with data in a database management role and want to learn how to query data using Transact-SQL.

Participants should have basic knowledge of relational databases and some experience working with SQL Server.

Question Vector
Equip your employees with the right skills to be prepared for the future.

Provide your workforce with top-tier corporate training programs that empower them to succeed. Our programs, led by subject matter experts from around the world, guarantee the highest quality content and training that align with your business objectives.

  • 1500+

    Certified Trainers

  • 200+


  • 2 Million+

    Trained Professionals

  • 99%

    Satisfaction Score

  • 2000+


  • 120+


  • 180+


  • 1600%