Simple play icon Course

Understanding Relational Data with Azure

by Nikola Ilic

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.

What you'll learn

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

Nikola Ilic is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI - but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed "Data-Mozart". As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer's last name as part of his nickname. That'... more

Ready to upskill? Get started