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

سرفصل های دوره

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

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - The Udemy Interface

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

5 - Curriculum

6 - Lets have a Udemy Mashup

7 - DP900ExamRequirements220804.pdf

7 - DP-900Notes220525.pdf

7 - Resources.html

2 - Lets start using Microsoft Azure

8 - What is Azure

9 - Creating an Azure account

10 - 15 Install Azure SQL Database with sample data

3 - Creating SELECT statements

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

4 - Programs used for querying relational data

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

13 - Programs used for querying relational data Azure Data Studio

14 - Differences between SSMS and Azure Data Studio

5 - Describe relational data workloads

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

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

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

18 - 14 Describe relational data structures Indexes

19 - 14 Describe relational data structures Views

20 - 14 Other relational data structures

6 - Describe relational Azure data services SQL Server

21 - On Prem versus the Cloud

22 - Describe and compare PaaS IaaS and SaaS delivery models

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

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

25 - 15 Creating Azure SQL Database other settings

26 - 15 Describe Azure SQL Managed Instance

27 - 15 Describe SQL Server on Azure Virtual Machine

7 - Describe relational Azure data services Other Azure relational Databases

28 - 16 Describe Azure Database for PostgreSQL

29 - 16 Describe Azure Database for MySQL

30 - 16 Describe Azure Database for MariaDB

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

32 - 810 Identify roles and responsibilities for data workloads

8 - Nonrelational Data Semistructured Data

33 - 2 3 Nonrelational data an introduction

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

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

36 - 20 21 Replicating Data Globally

37 - 20 21 Azure Cosmos DB APIs Gremlin API Graph

38 - 20 21 Other Azure Cosmos DB APIs

39 - 4 5 Recommend the correct data store

9 - Describe nonrelational data offerings on Azure

40 - Storage Accounts

41 - Replication Options

42 - 19 Describe Azure Table storage

43 - 17 Creating and uploading to Azure Blob storage

44 - 17 Accessing and assigning access tiers to BLOB Storage

45 - 18 Describe Azure File storage

10 - Describe analytics workloads

46 - 6 What is a transaction

47 - 6 Describe transactional workloads ACID Locks and Distributed Databases

48 - 22 Describe data warehousing workloads Ingestion and common practices

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

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

11 - Describe the components of a modern data warehouse

51 - Azure Data Factory and concepts of data processing

52 - SQL Server Integration Services SSIS

53 - Azure Data Lake

54 - 24b Azure Databricks

55 - 26b Azure Synapse Data Explorer

56 - 24a Azure Synapse Analytics

57 - 26c Spark structured streaming

58 - SQL Server Analysis Services SSAS

59 - 24c Azure HDInsight

12 - Describe data visualization in Microsoft Power BI

60 - 27 Identify capabilities of Power BI

61 - 28 Describe the workflow in Power BI

62 - 27 Describe the role of interactive reports

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

64 - 29 Advanced Chart Types

65 - 27 Describe the role of paginated reporting

66 - 27 Describe the role of dashboards

13 - Congratulations

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

68 - Well done

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

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

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

15 - Additional Identify basic management tasks for relational data

73 - Describe provisioning and deployment of relational data services

74 - Identify data security components and connectivity issues

75 - Authentication and Authorization

16 - Additional Identify basic management tasks for nonrelational data

76 - Identify management tools for nonrelational data

77 - Describe provisioning and deployment of nonrelational data services

78 - Describe method for deployment

79 - Identify data security components and basic connectivity issues

17 - Additional Analytics workloads and Power BI

80 - Describe ELT and ETL processing

81 - Determine when a data warehouse solution is needed

82 - Describe modern data warehousing architecture and workload

83 - Describe analytics techniques

18 - Bonus Lecture

84 - Bonus Lecture

84 - idodatabonuslecture230113.zip

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training