Description
Course info
Level
Intermediate
Updated
May 6, 2021
Duration
1h 8m
Description

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.

About the author
About the author

Nikola has multi-year experience working with various flavors of data, predominantly with Microsoft BI stack. Started with SQL Server, then brushed himself with SSAS Multidimensional, SSIS, SSRS, Power BI, Azure, etc. Nikola is really curious by nature and always trying to learn something new.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Nikola Ilic, and welcome to my course, Understanding Relational Data with Azure. I work as a business intelligence developer and making music from the data. Are your data professional looking to switch from traditional to cloud relational databases environment? Want to learn how to leverage your SQL skills in Azure? In this course, we are going to learn how to work with relational data in the Azure ecosystem. Some of the major topics that we will cover include: difference between online transaction processing system and online analytic processing system, various types of Azure delivery models and Azure services, connecting and querying relational databases in Azure. By the end of this course, you'll know more about relational data workloads in Azure and be able to make a smooth transition from on‑prem to cloud databases environment. Before beginning the course, you should be familiar with relational databases in general and have basic SQL skills. From here, you should feel comfortable diving further into the Azure Data Fundamentals path and other Azure courses at Pluralsight. I hope you'll join me on this journey to learn more about relational data workloads with the Understanding Relational Data with Azure course, at Pluralsight.