Overview
This DP-080T00: Querying Data with Microsoft Transact-SQL course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Skills Covered
After completing this module, students will be able to:
- 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 Should Attend
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
Course Curriculum
Course Modules
This module provides an introduction to relational databases, the SQL language and Transact-SQL. You will learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.
Learning objectives
After completing this module, you will be able to:
- Understand what SQL is for
- Identify database objects in schemas
- Identify SQL statement types
- Use the SELECT statement
- Work with data types
- Handle NULLs
Prerequisites
Before starting this module, it is helpful to have experience of working with tables with data; for example in a spreadsheet.
Learn how to sort and filter query results
Learning objectives
After completing this module, you will be able to:
- Sort your results
- Limit the sorted results
- Return paged results
- Remove duplicates
- Filter data with predicates
Prerequisites
Before starting this module, you should be familiar with the basic syntax of the SELECT Transact-SQL statement.
Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.
Learning objectives
After completing this module, you will be able to:
- Describe join concepts and syntax
- Write queries that use inner and outer joins
- Write queries that use cross joins
- Write queries that use self joins
Prerequisites
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve and filter data from a table in a database.
Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.
Learning objectives
After completing this module, you will be able to:
- Understand what subqueries are
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
Prerequisites
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve and filter data from a table in a database
Learn how to use functions in Transact-SQL, and how to group aggregated results.
Learning objectives
After completing this module, you will be able to:
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
Prerequisites
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve data from tables in a database.
Learn how to use Transact-SQL to insert, update, and delete data in a database.
Learning objectives
After completing this module, you will be able to:
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
Prerequisites
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve data from tables in a database.
Request More Information
Training Options
- ILT: Instructor-Led Training
- VILT: Virtual Instructor-Led Training
RM2,100.00Enroll Now
RM2,100.00Enroll Now
RM2,100.00Enroll Now
RM2,100.00Enroll Now
RM2,100.00Enroll Now
RM2,100.00Enroll Now
RM2,100.00Enroll Now
RM2,100.00Enroll Now
Exam & Certification
This course is not associated with any Certification. If you’d like to learn more about Azure certification roadmap, do check out our Microsoft Azure Training Certifications blog post.
Training & Certification Guide
Azure Strategy & Implementation Guide
Get a step-by-step introduction to using Azure for your cloud infrastructure with this Pack e-book. Read the latest edition of the Azure Strategy and Implementation Guide for detailed guidance on how to create a successful cloud adoption strategy with new innovations, capabilities, and security features from Microsoft Azure.
Microsoft Azure SQL Jumpstart Guide
Find out how to get started launching your first Azure SQL database or find ways to make your existing SQL database work harder. Download the Azure SQL Jumpstart Guide for detailed instructions and in-depth insights to help you make your Azure SQL deployment, migration, or enhancement run smoothly.
Low-code Application Development – Microsoft PowerApps and Azure
Build production-ready apps faster with a low-code environment. Quickly stand up your applications with Power Apps and get more time to apply your technical expertise to extending and optimizing those apps in Azure.
Azure Cloud Native Architecture Mapbook
Grow your cloud architecture skills with guidance from Azure Experts. Go beyond developing cloud-native applications to planning and implementing cloud application infrastructure. In this free e-book from Packt Publishing, you’ll find best practices for infrastructure design and patterns for building a complete solution.
Windows Virtual Desktop Security
Find out how to secure your Windows Virtual Desktop environment when migrating your virtual desktop infrastructure (VDI) to Azure. Read this security handbook to get technical hands-on guidance on how to help protect your apps and data in your Windows Virtual Desktop deployment.
Discover how to get more value from your on premises Windows Server and SQL Server investments and move some or all of your workloads to the cloud using your existing skills. See how to start using the cloud to support new ways of doing business and help ensure business continuity even if you need to keep some of your IT assets on-premises due to regulatory or data governance requirements.
Discover how to build highly scalable applications using containers and how to deploy and manage those containers at scale with Kubernetes on Azure. Read the completely reviewed and updated Packet e-book, Hands-On Kubernetes on Azure, Third Edition and discover what’s new, including security enhancements, continuous integration and continuous delivery (CI/CD) automation, and the latest supported technologies. Gain insight into building reliable applications in the new foreword by Kubernetes co-founder Brendan Burns.
Azure Synapse Analytics Proof of Concept Playbook
Learn how to perform a proof of concept efficiently and economically with Azure Synapse Analytics. Read the Azure Synapse Analytics Proof of Concept Playbook to understand the key concepts involved in deploying data warehousing, data lake, and big data workloads with Azure Synapse and get the evidence you need to make the case for implementation at your organization.
Spend less time managing server infrastructure and more time building great apps. Get your solutions to market faster using Azure Functions, a fully managed compute platform for processing data, integrating systems, and building simple APIs and microservices. The Azure Serverless Computing Cookbook will, through the development of basic back-end wep API that performs simple operations, helps you understand how to persist data in Azure Storage services.
Frequently Asked Questions
DP-050T00: Migrate SQL workloads to Azure
Learn about migrating SQL workloads to SQL Services on Azure in this 2-days Microsoft Official Course. Get guidance on how to migrate data platform technologies on Azure and how existing SQL based workloads can be migrated and modernized.
DP-060T00: Migrate NoSQL Workloads to Azure Cosmos DB
This DP-060T00: Migrate NoSQL Workloads to Azure Cosmos DB course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB.
DP-070T00: Migrate Open Source Data Workloads to Azure
This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.
DP-090T00: Implementing a Machine Learning Solution with Microsoft Azure Databricks
Master the art and science of how to use machine learning to deliver valuable insights based on your organization’s data with Microsoft Azure Databricks. Learn the key concepts behind Azure Databricks to prepare data for modeling and analytics; model predictive analytics solution for real-world customer scenarios; and implement an end-to-end machine learning pipeline.
DP-100T01: Designing and Implementing a Data Science Solution on Azure
Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This DP-100T01: Designing and Implementing a Data Science Solution on Azure course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring in Microsoft Azure.
DP-900T00: Microsoft Azure Data Fundamentals
In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data.
DP-203T00: Data Engineering on Microsoft Azure
In this DP-203T00 Data Engineering on Microsoft Azure course, the student will learn about the data engineering patterns and practices as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies. Students will begin by understanding the core compute and storage technologies that are used to build an analytical solution.
DP-300T00: Administering Relational Databases on Microsoft Azure
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
DP-420T00: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
Unlock opportunities with Azure Cosmos DB.
This course teaches developers how to create application using the SQL API and SDK for Azure Cosmos DB. Students will learn how to write efficient queries, create indexing policies, manage and provisioned resources, and perform common operations with the SDK.
