Understanding Relational Data with Azure

Are you a data professional looking to leverage the power of the cloud? Do you possess strong SQL skills but need to understand how to apply them within Azure Data Services? Or are you preparing to take the DP-900 exam? This course, Understanding Relational Data with Azure, provides the essential knowledge to navigate the Azure relational ecosystem.

You'll begin by exploring the fundamental characteristics of OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems, gaining a clear understanding of their differences and use cases.

Next, we'll break down the various Azure delivery models:

• PaaS (Platform as a Service)
• IaaS (Infrastructure as a Service)
• SaaS (Software as a Service)

Understanding these models is crucial for choosing the right approach for your data needs.

The course then dives into key relational Data Services offered within Azure:

• Azure SQL Database: A fully managed relational database service.
• Azure DB for MySQL: A fully managed MySQL-compatible database service.
• Azure DB for PostgreSQL: A fully managed PostgreSQL-compatible database service.

Finally, you'll gain practical skills in connecting to and querying data from each of these services.

Upon completion, you'll have a solid foundation in relational data in Azure, empowering you to seamlessly transition from on-premises environments to the cloud. This course is specifically designed to prepare you for the DP-900 Azure Data Fundamentals certification exam.