Online training - access your course anytime, anywhere! Call us on 1300 009 924
Enrol now
Enquire now
Enquire

Microsoft DP-080T00 - Querying Data with Microsoft Transact-SQL

This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Covering both querying and modifying data in relational databases hosted in Microsoft SQL Server-based systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics, this course is designed to provide a strong foundation in Transact-SQL.

Enquire now
*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.
100% online
Enrol now
Vendor Aligned Technical Training
2 Day Virtual Classroom
6 Modules
Purchase online now

$1,650.00

ONE EASY PAYMENT
 

Advance your SQL skills with our Introduction to Transact-SQL course. Enrol today to master querying and modifying data within Microsoft SQL Server-based systems.

Enrol Now & Gain Essential Transact-SQL Skills!

 
Enrol now

Enrol in the Introduction to Transact-SQL course to gain essential skills in querying and modifying data within Microsoft SQL Server-based systems. This comprehensive two-day course covers fundamental topics such as writing SELECT statements, sorting and filtering data, using built-in functions, creating data groups, and modifying data with Transact-SQL commands. Ideal for data analysts, engineers, scientists, and database professionals, this course will enhance your ability to work with data effectively.

What will you learn? 

  • Use SQL Server query tools effectively
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Use built-in functions to return data values
  • Create groups of data and aggregate the results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE, and MERGE commands

Who is this course for?

  • Data analysts, data engineers, data scientists, database administrators, and database developers
  • Solution architects, students, and technology managers involved with data
  • Anyone needing to write basic SQL or Transact-SQL queries
  • Individuals seeking to improve their data management skills

Course Detail

The Microsoft DP-080T00 - Querying Data with Microsoft Transact-SQL course is designed to provide learners with essential skills in querying and modifying data using Transact-SQL. This hands-on course covers SQL Server query tools, writing SELECT statements, sorting and filtering data, using built-in functions, and modifying data, ensuring participants can manage data efficiently.

Instructional Formats:

  • Virtual Instructor-Led: Participate in live, instructor-led sessions from the comfort of your home or office.
  • In-person Instructor-Led: Join us in person at one of our training centres for a hands-on learning experience.

 

Course Structure

This course will delve into the following key topics:

  • Introduction to Transact-SQL
  • Sort and filter results in T-SQL
  • Combine multiple tables with JOINs in T-SQL
  • Write Subqueries in T-SQL
  • Use built-in functions and GROUP BY in Transact-SQL
  • Modify data with T-SQL
Upskilled Certificate of Attendance

Entry requirements

Start date

Participants should have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of relational databases

FAQs

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

The Microsoft DP-080T00 course teaches the basics of Microsoft's Transact-SQL language, covering querying and modifying data in relational databases hosted in SQL Server-based systems.

 

Who will benefit from this Transact-SQL course?

  • Data analysts, engineers, and scientists
  • Database administrators and developers
  • Solution architects and technology managers
  • Students and individuals wanting to learn data querying

 

Do I need any prior knowledge of SQL?

Basic knowledge of the Microsoft Windows operating system and relational databases is required to get the most out of this course.

 

Is this course suitable for both individuals and organisations?

Yes, this course is suitable for both individuals and organisations. Whether you're looking to enhance your personal data querying skills or upskill your team, the Microsoft DP-080T00 course offers valuable benefits.

 

What can I expect after completing this course?

Upon completion, you will have a strong foundation in Transact-SQL, enabling you to query and modify data efficiently. These skills are valuable for personal and professional use and can enhance your career opportunities.

If you have any further questions or need additional information, feel free to reach out to an Upskilled Education Consultant.

 

Enquire today

Sounds just like the course you're after? Speak with a career consultant to discover what it's like to study the Microsoft DP-080T00Querying Data with Microsoft Transact-SQL. Send us an enquiry and we'll get in touch.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Download course guide

Want to know all about this course? Get our course brochure to discover what it's like to study Microsoft DP-080T00Querying Data with Microsoft Transact-SQL. Submit your details and simply click 'Download'.

Download course guide

Want to know all about this course? Get our course brochure to discover what it's like to study . Submit your details and simply click 'Download'.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Enrol Online Now - It's easy and simple.

Thank you for choosing Microsoft DP-080T00 - Querying Data with Microsoft Transact-SQL.

Fill out your details below to enrol today. Once we have your payment details, one of our consultants will get in touch with you to process your enrolment.

Course price (GST inclusive):
1650.00
Credit card details:
Payment succeeded, Please wait.

 
We value your security
When purchasing from Upskilled Pty Ltd, your credit card information is entered into a secure server encrypted using 128-bit Secure Socket Layer (SSL) technology - the current state of the art for Internet security.

The information is sent to your card issuer's bank over a secure, proprietary connection. When the authorisation process is complete - this takes around five seconds - you receive an approval or decline response in your browser, and Upskilled is informed appropriately to initiate the enrolment process.

If you have any questions regarding this payment, please contact our customer support centre at support@upskilled.edu.au.

Privacy
By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Terms and Conditions
Please click the following link to review the Terms and Conditions of Upskilled Tech Academy:
Upskilled Tech Academy Terms and Conditions

Enquire now

Start your next course with Upskilled. Enter your details in the form below.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.

Enquire now

Start your next course with Upskilled. Enter your details in the form below.

*By providing your information, you agree to our Privacy Policy and to receiving email and other forms of communication from Upskilled. You are able to opt-out at any time.
Processing