DP-900: Microsoft Azure Data Fundamentals (Aug 2022 version)

Focused View

Phillip Burton,I Do Data Limited

7:28:42

129 View

1 - Introduction

1 - Introduction.mp4

02:22

2 - Welcome to Udemy.html

3 - The Udemy Interface.mp4

02:00

4 - Do you want autotranslated subtitles in more languages.html

5 - Curriculum.mp4

10:16

6 - Lets have a Udemy Mashup.mp4

05:06

7 - DP900ExamRequirements220804.pdf

7 - DP-900Notes220525.pdf

7 - Resources.html

2 - Lets start using Microsoft Azure

8 - What is Azure.mp4

04:10

9 - Creating an Azure account.mp4

06:12

10 - 15 Install Azure SQL Database with sample data.mp4

09:46

3 - Creating SELECT statements

11 - 13 Query relational data in PostgreSQL MySQL and Azure SQL Database SELECT.mp4

11:27

4 - Programs used for querying relational data

12 - Programs used for querying relational data SQL Server Management Studio.mp4

04:42

13 - Programs used for querying relational data Azure Data Studio.mp4

03:19

14 - Differences between SSMS and Azure Data Studio.mp4

04:59

5 - Describe relational data workloads

15 - 1 11 12 Describe the characteristics of relational data Tables.mp4

02:31

16 - 1 11 12 Describe the characteristics of relational data Normalization.mp4

03:34

17 - 1 11 12 Characteristics of relational data Primary and Foreign Keys.mp4

03:41

18 - 14 Describe relational data structures Indexes.mp4

07:32

19 - 14 Describe relational data structures Views.mp4

02:24

20 - 14 Other relational data structures.mp4

06:09

6 - Describe relational Azure data services SQL Server

21 - On Prem versus the Cloud.mp4

07:22

22 - Describe and compare PaaS IaaS and SaaS delivery models.mp4

08:11

23 - 15 Creating Azure SQL Database in detail Part 1 including Regions.mp4

04:05

24 - 15 Creating Azure SQL Database Elastic Pools compute and storage.mp4

05:09

25 - 15 Creating Azure SQL Database other settings.mp4

07:21

26 - 15 Describe Azure SQL Managed Instance.mp4

08:39

27 - 15 Describe SQL Server on Azure Virtual Machine.mp4

10:13

7 - Describe relational Azure data services Other Azure relational Databases

28 - 16 Describe Azure Database for PostgreSQL.mp4

06:44

29 - 16 Describe Azure Database for MySQL.mp4

02:24

30 - 16 Describe Azure Database for MariaDB.mp4

03:41

31 - 4 5 Identify the right data offering for a relational workload.mp4

03:28

32 - 810 Identify roles and responsibilities for data workloads.mp4

05:55

8 - Nonrelational Data Semistructured Data

33 - 2 3 Nonrelational data an introduction.mp4

08:50

34 - 20 21 Azure Cosmos DB APIs Creating a Core SQL Cosmos DB.mp4

07:16

35 - 20 21 Azure Cosmos DB APIs Querying a Core SQL Cosmos DB.mp4

06:42

36 - 20 21 Replicating Data Globally.mp4

05:07

37 - 20 21 Azure Cosmos DB APIs Gremlin API Graph.mp4

06:27

38 - 20 21 Other Azure Cosmos DB APIs.mp4

06:05

39 - 4 5 Recommend the correct data store.mp4

07:50

9 - Describe nonrelational data offerings on Azure

40 - Storage Accounts.mp4

06:33

41 - Replication Options.mp4

06:32

42 - 19 Describe Azure Table storage.mp4

08:49

43 - 17 Creating and uploading to Azure Blob storage.mp4

06:57

44 - 17 Accessing and assigning access tiers to BLOB Storage.mp4

07:07

45 - 18 Describe Azure File storage.mp4

06:13

10 - Describe analytics workloads

46 - 6 What is a transaction.mp4

04:29

47 - 6 Describe transactional workloads ACID Locks and Distributed Databases.mp4

04:48

48 - 22 Describe data warehousing workloads Ingestion and common practices.mp4

02:18

49 - 25 Describe the difference between batch and real time streaming.mp4

04:24

50 - 7 Describe the difference between a transactional and an analytics workload.mp4

03:49

11 - Describe the components of a modern data warehouse

51 - Azure Data Factory and concepts of data processing.mp4

05:37

52 - SQL Server Integration Services SSIS.mp4

02:52

53 - Azure Data Lake.mp4

06:20

54 - 24b Azure Databricks.mp4

06:03

55 - 26b Azure Synapse Data Explorer.mp4

03:46

56 - 24a Azure Synapse Analytics.mp4

07:48

57 - 26c Spark structured streaming.mp4

03:37

58 - SQL Server Analysis Services SSAS.mp4

04:39

59 - 24c Azure HDInsight.mp4

02:19

12 - Describe data visualization in Microsoft Power BI

60 - 27 Identify capabilities of Power BI.mp4

02:51

61 - 28 Describe the workflow in Power BI.mp4

08:01

62 - 27 Describe the role of interactive reports.mp4

06:03

63 - 29 Describe basic chart types such as bar charts and pie charts.mp4

04:55

64 - 29 Advanced Chart Types.mp4

04:05

65 - 27 Describe the role of paginated reporting.mp4

06:21

66 - 27 Describe the role of dashboards.mp4

07:35

13 - Congratulations

67 - Youve finished this course what should you do to prepare for the exam.mp4

04:50

68 - Well done.mp4

01:29

14 - Additional Describe query techniques for data using SQL language

69 - No longer needed for DP900 exam.html

70 - Programs used for querying relational data sqlcmd.mp4

05:15

71 - Programs used for querying relational data Excel and Visual Studio.mp4

04:34

72 - Compare Data Definition Language DDL versus Data Manipulation Language DML.mp4

06:00

15 - Additional Identify basic management tasks for relational data

73 - Describe provisioning and deployment of relational data services.mp4

07:05

74 - Identify data security components and connectivity issues.mp4

05:42

75 - Authentication and Authorization.mp4

07:41

16 - Additional Identify basic management tasks for nonrelational data

76 - Identify management tools for nonrelational data.mp4

04:03

77 - Describe provisioning and deployment of nonrelational data services.mp4

07:16

78 - Describe method for deployment.mp4

05:40

79 - Identify data security components and basic connectivity issues.mp4

06:45

17 - Additional Analytics workloads and Power BI

80 - Describe ELT and ETL processing.mp4

06:40

81 - Determine when a data warehouse solution is needed.mp4

03:07

82 - Describe modern data warehousing architecture and workload.mp4

04:01

83 - Describe analytics techniques.mp4

03:32

18 - Bonus Lecture

84 - Bonus Lecture.mp4

08:32

84 - idodatabonuslecture230113.zip

Description

Work with Azure data in the cloud, inc. relational (Azure SQL) and non-relational (Cosmos DB) databases. For exam DP-900

What You'll Learn?

Understand types of core data workloads and data analytics core concepts
Understand how to work with relational data on Azure, including Azure SQL Database and Managed Instance
Understand how to work with non-relational data on Azure, including Cosmos DB APIs, Table, Blob and File storage
Describe analytics workloads, including data warehouses, data ingestion and processing on Azure
Describe data visualization in Microsoft Power BI, including reports and dashboards

Who is this for?

This course is for you if you use data, and want to understand what is available on Azure.

By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official DP-900 exam.

Wouldn't the "Microsoft Certified: Azure Data Fundamentals" certification look good on your CV or resume?

More details

Description
This course is the foundation for the Microsoft Certificate DP-900 "Azure Data Fundamentals", and focuses on relational and non-relational data, together with analytics workloads. It is updated in line with the exam updates as of August 4, 2022.

What do people like you say about this course?
Girma says: "Great! â€“ Azure would never be difficult (as most of us think) after thoroughly going through this course."
Ankona says:Â "Very good course. Philip proves why is indeed the go to guy for everything to do with databases. I have taken a couple of his courses on various aspects of databases and he never disappoints."
Karen says:Â "This course helped me to clear the exam with 903."

We'll start off with looking at relational data. We'll create an Azure account, install an Azure SQLÂ Database and query it. We'll then look at the 6 different clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. After this, we'll have a look at other relational databases, including Azure Databases for PostgreSQL, MariaDB and MySQL.
After that, we'll look at non-relational data using semi-structured and non-structured data. We'll look at the five different Cosmos DBÂ databaseÂ interfaces or APIs, and which one you should use for your particular needs. We'll also look at Table, Blob and File storage.
We'll then look at analytics workloads, including Azure data services for modern data warehouses such as Azure Data Lake, Synapse Analytics, Databricks and HDInsight.
Finally, we'll look at Microsoft Power BI and how to create basic reports and dashboards.
No prior knowledge is required - we'll even see how to get a free Azure trial!
There are regular quizzes to help you remember the information, so you can be sure that you are learning.
Once you have finished this course, you will have a good introductory knowledge of core data concepts and how they are implemented using Microsoft Azure data services. And with some practice, you could even go for an official Microsoft certification - wouldn't that look good on your CVÂ or resume? And if you are an American college student, you might even get college credit for passing that exam.
Who this course is for:
This course is for you if you use data, and want to understand what is available on Azure.
By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official DP-900 exam.
Wouldn't the "Microsoft Certified: Azure Data Fundamentals" certification look good on your CV or resume?

User Reviews

Rating

average 0

Total votes0

Focused display

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 500,000 students and more than 40 video courses, including over a dozen Bestseller courses.My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

I Do Data Limited

Instructor's Courses

I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies. That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job. I Do Data courses are dedicated to enabling you to succeed.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.