Understanding Relational Data with Azure

Focused View

Nikola Ilic

1:08:54

179 View

1. Course Overview

1. Course Overview.mp4

01:25

2. Understand Core Concepts of Relational Data Workloads

1. Core Concepts of Relational Data Workloads.mp4

03:41

2. Structured, Semi-structured, and Non-structured Data.mp4

02:27

3. Relational Databases General Overview.mp4

03:41

4. Normalization.mp4

01:52

5. OLTP.mp4

02:45

6. OLAP.mp4

05:49

3. Understand Different Delivery Models in Azure

1. Understand Different Delivery Models in Azure.mp4

05:01

2. Infrastructure as a Service.mp4

02:02

3. Platform as a Service.mp4

02:41

4. Software as a Service.mp4

02:48

5. Summary.mp4

00:48

4. Explore Relational Data Services in Azure

1. Explore Relational Data Services in Azure.mp4

03:30

2. Understand Azure SQL DB.mp4

03:13

3. Understand Azure DB for MySQL.mp4

01:14

4. Demo - Azure DB for MySQL.mp4

04:05

5. Understand Azure DB for PostgreSQL.mp4

02:16

6. Demo - Azure DB for PostgreSQL.mp4

03:56

7. Summary.mp4

00:57

5. Querying Azure SQL Database

1. Querying Azure SQL Database.mp4

02:29

2. Querying Relational Data.mp4

01:24

3. Demo - Querying Azure DB for PostgreSQL.mp4

03:39

4. Demo - Querying Azure DB for MySQL.mp4

02:03

5. Demo - Querying Azure SQL DB.mp4

03:15

6. Summary.mp4

01:53

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Azure

Nikola Ilic

Instructor's Courses

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's why Nikola's professional motto is: "Make Music from your Data!" Coming from the business environment, Nikola holds a Bachelor’s degree in both Communicology and Computer Science. He is regularly blogging on data-mozart.com and speaking at global data conferences. Nikola is also a Microsoft Data Platform MVP, Microsoft Certified Trainer, and a certified Data Analyst.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.