info@infoventure.com +1 905 625 2727 Login Support
Company logo

Infoventure

DP-080: Query and modify data with Transact-SQL

Learn new skills and discover the power of Microsoft Azure with step-by-step guidance.

Learn data concepts

Hands-On Learning

Learn from AI Experts

  • Instructor-led

  • Official Courseware

  • Flexible Schedule

  • Guaranteed To Run

The DP-080T00 Microsoft Azure Data Fundamentals course is designed for individuals seeking to enhance their understanding of data concepts in the cloud. This beginner-level course focuses on foundational skills in Azure data services, data management, and analytics, equipping learners with the knowledge needed to work with various types of data. By the end of the course, participants will be well-versed in core data concepts, relational and non-relational data, and Azure’s data storage and processing solutions, offering value to those entering the data and cloud industry.

  • Course : DP-080: Query and modify data with Transact-SQL

  • Level : Intermediate

  • Type : Instructor led Live online or Classroom

  • Length : 1 day

  • Labs : Included

  • Practice Test : Included

Who should take this course

  • Beginners interested in cloud and data technologies

  • IT professionals wanting to expand their data knowledge

  • Data analysts aiming for Azure certification

  • Developers looking to work with cloud data

  • Business intelligence professionals seeking to upskill

  • Data architects aspiring to build data solutions

  • Project managers overseeing data initiatives

  • Students pursuing a career in cloud computing

  • Anyone interested in Microsoft Azure data services

Prerequisites

  • Familiarity with basic IT concepts

What you'll learn

  • Understanding core data concepts

  • Exploring relational data concepts and structures

  • Differentiating between relational and non-relational data

  • Working with Azure SQL Database and Cosmos DB

  • Basics of data storage and data lakes

  • Introduction to Azure data services for analytics

  • Configuring and managing data in the cloud

  • Querying data using SQL and other tools

  • Data security and privacy concepts in Azure

  • Exploring real-time data processing with Azure

  • Setting up Azure Data Factory pipelines

  • Using Power BI for data visualization

Certificate

  • Not applicable

Training Mode

Instructor-led Virtual online live Training.

  • Weekend Classes

  • Evening Classes

  • Weekdays Classes

Course Outline

Module 1: Introduction to Transact-SQL

  • Work with schemas

  • Explore the structure of SQL statements

  • Examine the SELECT statement

  • Work with data types

  • Handle NULLs

Module 2: Sort and filter results in T-SQL

  • Sort your results

  • Limit the sorted results

  • Page results

  • Remove duplicates

  • Filter data with predicates

Module 3: Combine multiple tables with JOINs in T-SQL

  • Understand joins concepts and syntax

  • Use inner joins

  • Use outer joins

  • Use cross joins

  • Use self joins

Module 4: Write Subqueries in T-SQL

  • Understand subqueries

  • Use scalar or multi-valued subqueries

  • Use self-contained or correlated subqueries

Module 5: Use built-in functions and GROUP BY in Transact-SQL

  • Categorize built-in functions

  • Use scalar functions

  • Use ranking and rowset functions

  • Use aggregate functions

  • Summarize data with GROUP BY

  • Filter groups with HAVING

Module 6: Modify data with T-SQL

  • Insert data

  • Generate automatic values

  • Update data

  • Delete data

  • Merge data based on multiple tables

Best Value offer

  • Official Courseware

  • Instructor-led live online / Classroom

  • Flexible Schedule

  • Course Completion Certification

US$ 1250

Buy now, pay later with PayPal

Our upcoming class schedule is currently being finalized.

Let us know your preferred start date, and we'll update you.

We’re Here to Assist You

4 days

Advanced

5 days

Intermediate

4 days

Advanced

What are the prerequisites for the training?

Some courses may require basic knowledge of IT infrastructure. Check the specific course details for prerequisites.

Can I start even if I am new to Cloud computing?

Yes, our expert instructor will help you from scratch, the course is designed in a way that you will get understanding of Cloud.

Can I get support after course?

Sure, we would happy to assist you. Please direct your queries to info@infoventure.com

AWS Authorized Partner

Microsoft Authorized Partner

CompTIA Authorized Partner

EC-Council Authorized Partner

PECB Authorized Partner

Quick links

Info@infoventure.com

+1 905 625 2727

www.infoventure.com

Mississauga, CANADA

Follow us

Newsletter

Technology moves fast. Make sure you are up to speed with IT Trainings.

All rights reserved. © 2016 - 2026 - Infoventure Technologies Inc.