Understanding Relational Data with Azure
Offered By: Pluralsight
Course Description
Overview
Relational databases are still the most common way to store data. This course will teach you how to handle relational data in Azure and make a smooth transition from on-prem solutions to a cloud environment.
Are you a seasoned data professional heading towards a cloud environment? Do you have profound SQL knowledge, but you're not sure how it can be applied in Azure Data Services? Or do you simply want to acquire the skills necessary to successfully pass the DP-900 exam? In this course, Understanding Relational Data with Azure, you’ll gain the ability to identify key concepts and features in the Azure relational ecosystem. First, you’ll explore the main characteristics of OLTP and OLAP systems. Next, you’ll discover the difference between various Azure delivery models, such as PaaS, IaaS, and SaaS. You'll also understand key characteristics of various relational Data Services within Azure, namely Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL. Finally, you’ll learn how to connect and query relational data from Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL. When you’re finished with this course, you’ll have the foundational understanding of relational data in Azure that will enable you to make a smooth transition from on-prem to a cloud environment, and get you ready for the DP-900 exam.
Are you a seasoned data professional heading towards a cloud environment? Do you have profound SQL knowledge, but you're not sure how it can be applied in Azure Data Services? Or do you simply want to acquire the skills necessary to successfully pass the DP-900 exam? In this course, Understanding Relational Data with Azure, you’ll gain the ability to identify key concepts and features in the Azure relational ecosystem. First, you’ll explore the main characteristics of OLTP and OLAP systems. Next, you’ll discover the difference between various Azure delivery models, such as PaaS, IaaS, and SaaS. You'll also understand key characteristics of various relational Data Services within Azure, namely Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL. Finally, you’ll learn how to connect and query relational data from Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL. When you’re finished with this course, you’ll have the foundational understanding of relational data in Azure that will enable you to make a smooth transition from on-prem to a cloud environment, and get you ready for the DP-900 exam.
Syllabus
- Course Overview 1min
- Understand Core Concepts of Relational Data Workloads 20mins
- Understand Different Delivery Models in Azure 13mins
- Explore Relational Data Services in Azure 19mins
- Querying Azure SQL Database 14mins
Taught by
Nikola Ilic
Related Courses
Delivering a Relational Data WarehouseMicrosoft via edX Recovering Data in Azure and SQL Server
Microsoft via edX Databases in Azure
Microsoft via edX Introduction to Data Modeling
Microsoft via edX Extend Your Application with REST Services
Microsoft via edX