DP-201: Designing an Azure Data Solution

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The DP-201 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft DP-201 test with flying colors.

111 Students Enrolled 69 Lectures 04:15:28 Hours

Curriculum For This Course

Introduction

3Lectures

Time 00:10:39

Hybrid SQL Server Options

6Lectures

Time 00:23:52

SQL Server in a Virtual Machine (VM)

7Lectures

Time 00:29:35

Design Azure SQL Database

9Lectures

Time 00:39:12

Implement Azure SQL Database

5Lectures

Time 00:20:29

Azure SQL Database for MySQL and PostgreSQL

8Lectures

Time 00:23:28

SQL Server Security

11Lectures

Time 00:31:45

SQL Database Security

3Lectures

Time 00:07:57

High Availability

4Lectures

Time 00:24:16

Scalability

4Lectures

Time 00:16:28

Disaster Recovery

4Lectures

Time 00:06:32

Monitor SQL Server

4Lectures

Time 00:19:52

Congratulations!

1Lectures

Time 00:01:23

Introduction
	1. Introduction	02:38
	2. Exam 70-473 Requirements	03:58
	3. What You Should Already Know	03:17

Hybrid SQL Server Options
	1. Introduction to Hybrid Databases	06:22
	2. Hybrid Disaster Recovery	06:16
	3. Hybrid Data Storage	02:52
	4. Hybrid Security	02:30
	5. Hybrid Data Load	04:05
	6. Hybrid Data Sync	01:09

SQL Server in a Virtual Machine (VM)
	1. SQL Server in a Virtual Machine (VM)	03:33
	2. Creating a VM with SQL Server in Azure	08:54
	3. Connecting to the SQL Server VM	04:08
	4. Configuring Firewall Settings	05:28
	5. SQL Server Storage	02:41
	6. SQL Server Migration	02:41
	7. SQL Server VM Sizes	01:34

Design Azure SQL Database
	1. Introduction to Azure SQL Database	03:36
	2. Design a Solution Architecture	06:04
	3. Design Geo/DR Topology	01:24
	4. Design Security Architecture	06:06
	5. Design Data Load Strategy	03:48
	6. Choose an Appropriate Service Tier	08:25
	7. Deployment Scenarios	02:15
	8. IaaS vs PaaS	03:51
	9. Determine Application Access	02:21

Implement Azure SQL Database
	1. Provision Azure SQL Database	04:43
	2. Configure Firewall Rules	02:45
	3. Configure Geo-Replication	03:12
	4. Migrate On-Premises SQL to SQL Database	02:41
	5. Configure Scaling and Performance	06:37

Azure SQL Database for MySQL and PostgreSQL
	1. Design and Implement MySQL and PostgreSQL	02:47
	2. MySQL and PostgreSQL Security	01:37
	3. MySQL and PostgreSQL Data Load	02:44
	4. MySQL and PostgreSQL Service Tiers	01:45
	5. MySQL and PostgreSQL Provisioning	06:59
	6. MySQL and PostgreSQL Firewalls	01:53
	7. MySQL and PostgreSQL Migration	02:43
	8. MySQL and PostgreSQL Scaling	01:59

SQL Server Security
	1. Overview of Security	02:59
	2. Firewalls	04:59
	3. Connecting to SQL Server	04:32
	4. Logins, Users and Roles	02:58
	5. Assign Permissions	03:03
	6. Auditing	01:54
	7. Transparent Data Encryption (TDE)	01:16
	8. Row Level Security	01:07
	9. Data Encryption	02:07
	10. Data Masking	02:13
	11. Always Encrypted	03:09

SQL Database Security
	1. Differences Between SQL Server and Azure Database Security	01:49
	2. Firewalls	02:18
	3. Threat Detection	03:21

High Availability
	1. Overview of High Availability	04:55
	2. Design an HA Topology	07:22
	3. Design an HA Solution on SQL Server for VM	04:49
	4. Implement AlwaysOn Availability Groups	06:46

Scalability
	1. Overview of Scalability	03:22
	2. Design a Scale-Out Solution	05:15
	3. Multi-Master Scenarios	04:32
	4. Elastic Scale for Azure SQL Database	02:17

Disaster Recovery
	1. Introduction to Disaster Recovery	01:35
	2. Azure SQL Database Data Recovery	01:36
	3. Copy and Export	01:47
	4. Long Term Backups	01:05

Monitor SQL Server
	1. Monitoring SQL Server	01:26
	2. Monitor Database Activity	05:39
	3. DMVs and DMFs	05:18
	4. Monitor Performance	06:54

Congratulations!
	1. Thank you!	01:17

Student Feedback

5.0

Excellent

64%

36 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

DP-201: Designing an Azure Data Solution

Curriculum For This Course

Student Feedback

Add Comments

Get 40% Discount on All Your Purchases

This is ONE TIME OFFER

Enter your email address to receive your 40% off discount code:

DP-201: Designing an Azure Data Solution

Curriculum For This Course

Student Feedback

Add Comments

Get Premium Membership

Enter your email address to receive your 40% off discount code: