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	2:56
	2. Exam 70-473 Requirements	4:11
	3. What You Should Already Know	3:32

Hybrid SQL Server Options
	1. Introduction to Hybrid Databases	6:31
	2. Hybrid Disaster Recovery	6:23
	3. Hybrid Data Storage	2:58
	4. Hybrid Security	2:36
	5. Hybrid Data Load	4:10
	6. Hybrid Data Sync	1:14

SQL Server in a Virtual Machine (VM)
	1. SQL Server in a Virtual Machine (VM)	3:38
	2. Creating a VM with SQL Server in Azure	9:02
	3. Connecting to the SQL Server VM	4:08
	4. Configuring Firewall Settings	5:34
	5. SQL Server Storage	2:47
	6. SQL Server Migration	2:46
	7. SQL Server VM Sizes	1:40

Design Azure SQL Database
	1. Introduction to Azure SQL Database	3:41
	2. Design a Solution Architecture	6:10
	3. Design Geo/DR Topology	1:34
	4. Design Security Architecture	6:13
	5. Design Data Load Strategy	3:54
	6. Choose an Appropriate Service Tier	8:31
	7. Deployment Scenarios	2:35
	8. IaaS vs PaaS	3:57
	9. Determine Application Access	2:37

Implement Azure SQL Database
	1. Provision Azure SQL Database	4:49
	2. Configure Firewall Rules	2:53
	3. Configure Geo-Replication	3:19
	4. Migrate On-Premises SQL to SQL Database	2:46
	5. Configure Scaling and Performance	6:42

Azure SQL Database for MySQL and PostgreSQL
	1. Design and Implement MySQL and PostgreSQL	2:54
	2. MySQL and PostgreSQL Security	1:46
	3. MySQL and PostgreSQL Data Load	2:50
	4. MySQL and PostgreSQL Service Tiers	1:53
	5. MySQL and PostgreSQL Provisioning	7:05
	6. MySQL and PostgreSQL Firewalls	1:59
	7. MySQL and PostgreSQL Migration	2:58
	8. MySQL and PostgreSQL Scaling	2:03

SQL Server Security
	1. Overview of Security	3:06
	2. Firewalls	5:08
	3. Connecting to SQL Server	4:39
	4. Logins, Users and Roles	3:05
	5. Assign Permissions	3:12
	6. Auditing	2:02
	7. Transparent Data Encryption (TDE)	1:23
	8. Row Level Security	1:16
	9. Data Encryption	2:18
	10. Data Masking	2:21
	11. Always Encrypted	3:15

SQL Database Security
	1. Differences Between SQL Server and Azure Database Security	1:54
	2. Firewalls	2:30
	3. Threat Detection	3:33

High Availability
	1. Overview of High Availability	5:02
	2. Design an HA Topology	7:28
	3. Design an HA Solution on SQL Server for VM	4:54
	4. Implement AlwaysOn Availability Groups	6:52

Scalability
	1. Overview of Scalability	3:31
	2. Design a Scale-Out Solution	5:27
	3. Multi-Master Scenarios	4:51
	4. Elastic Scale for Azure SQL Database	2:39

Disaster Recovery
	1. Introduction to Disaster Recovery	1:46
	2. Azure SQL Database Data Recovery	1:41
	3. Copy and Export	1:53
	4. Long Term Backups	1:12

Monitor SQL Server
	1. Monitoring SQL Server	1:34
	2. Monitor Database Activity	5:44
	3. DMVs and DMFs	5:28
	4. Monitor Performance	7:06

Congratulations!
	1. Thank you!	1:23

About This Course

Microsoft offers the Designing and Implementing Cloud Data Platform Solutions (70-473) exam. After passing this test, you will acquire the MCSE: Cloud Platform and Infrastructure or the MCSE: Data Management and Analytics certifications. These are high-level Microsoft credentials that can prove you have the abilities required to manage data center, work with cloud technologies, networking, identity management, systems management, and much more. The relevant course will help you prepare for the exam and become a Microsoft certified specialist.

Description

The MCSE: Cloud Platform and Infrastructure certificate approves the abilities in enterprise-scale data solutions and SQL administration. Before gaining MCSE, one should achieve the MCSA certification. The MCSE credentials are legitimate for a long time. As indicated by Microsoft, recertification exams cover the material from similar tests taken initially. With the new elective exam structure, the students have the chance to take the test based on their personal preference every year to "re-procure" the certificate.
The Microsoft training course is designed to understand how to design and implement solutions for data in Microsoft Azure, become a certified specialist, and remain updated with the latest news regarding the platform.

Requirements

Plan a half breed SQL Server arrangement
Screen and investigate databases on Azure
Execute SQL Server on VMs (Azure Virtual Machines)
Structure a database arrangement on Azure SQL database
Structure and actualize Database security
Structure and actualize adaptable arrangements
Structure and actualize high accessibility arrangements
Structure and actualize Azure SQL Database information recuperation
Structure and actualize MySQL and PostgreSQL database arrangements in Azure

Exam details

The exam comes with approximately 40-60 questions.
The questions can be multiple choice, drag and drop, hot areas, case study, etc.
The candidates are given two hours to answer the questions.
The students need to score 700 points out of 1000 to pass the exam.

Exam topics

Designing and implementing database solutions for Cloud Data Platform Solutions
Designing and implementing security
Designing for high disaster recovery, scalability, and availability
Monitoring and managing database implementations for Azure

Target audience

The IT professionals who have the competences, knowledge, and credentials to show their abilities in administering, managing, and designing cloud and infrastructure. It is possible to say that MCSE: Cloud Platform and Infrastructure prepares its holders for the positions, such as a network administrator, a systems engineer, a network engineer, an IT manager, a system administrator, an IT support specialist, and etc. The MCSE: Data Management and Analytics certification is essential for a database designer and a database analyst.

Conclusion

The MCSE: Cloud Platform and Infrastructure and MCSE: Data Management and Analytics credentials show that you have got the abilities for an advancing IT industry. These MCSE certifications will open up professional perspectives and give you the chance to go further in your career. The aptitudes will enhance with the help of this Microsoft training course, and your learning will undoubtedly bring outstanding results.

Career path:

IT Directors
IT Managers
Sr. Systems Engineers
Systems Administrators

The certification provides the holder with an opportunity to earn from around $47,428 to $146,157 on an annual basis.

Pass Microsoft MCP 70-473 Exam in First Attempt Guaranteed!

Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!

$18.00

Get Unlimited Access to ALL Premium Files Not Convinced?

Free 70-473 Exam Questions & Microsoft 70-473 Dumps
Microsoft.test-king.70-473.v2019-01-21.by.lauren.75q.ete	Views: 131 Downloads: 66	Size: 482.57 KB Votes: 2
Microsoft.prep4sure.70-473.v2018-10-17.by.lastborn223.57q.ete	Views: 388 Downloads: 141	Size: 342.61 KB Votes: 2
Microsoft.Passcertification.70-473.v2017-12-11.by.ksenia.28qs.ete	Views: 1135 Downloads: 627	Size: 867.17 KB Votes: 6

Student Feedback

4.5

Good

52%

48 %

Comments * The most recent comment are at the top

Stella

South Africa

Jan 22, 2019

Great and compact correspondence. I an extremely happy that the instructor was effective and clear to understand explanations. You do not need to continue perusing like a news speaker. However, the result is quite good anyway! In addition to these, the dialect utilized by the educator is very informative and easy to catch. So, it’s worth choosing. Much appreciated.

devonta freeman

Egypt

Jan 20, 2019

A great substance with clarification about Azure SQL and Provisional SQL database and administration levels and scaling the database. Everyone should attempt it at least once.

alex

India

Jan 11, 2019

This course was useful in getting comfortable with the broadness of themes to enable you to comprehend the extent of 70-473. I do feel like it could utilize somewhat more points of interest on the arrangement as I feel a greater part of the test concentrated on PowerShell directions to do the organizations as opposed to the Azure entryway. Be that as it may, this course joined with a Measure Up training exam was an extraordinary combo to pass the exam. Thanks.

marcus

United States

Jan 09, 2019

It improved the Cloud technology as a concept. The slides are not bad but difficult to pursue, with accentuation on the exam’s targets. I can add that the straightforward yet compelling dialect tone makes me understand the ideas effortlessly. A debt of gratitude is for supporting functional tests, which made the preparation and passing much simpler. So, it was great to run with.

julian edelman

Qatar

Jan 04, 2019

I have experienced your impressive course for IaaS and PaaS, which was great. However, this course is just useful not with precedent and less demo. This makes focus on taking in the themes well. A debt of gratitude is for this astounding chance.

calais campbell

Australia

Dec 27, 2018

I appreciated the material. It was immediate to the point, and the dialect utilized, alongside the pacing, was impeccable. I can undoubtedly return to the video on the off chance that I require more explicit insights about a specific point without chasing for it. The material ought to be refreshed a bit, especially in light of the fact that since the video was made, Azure has been refreshed somewhat, and a few things may require a re-contact. To add, I might suspect this is impeccable. I would prepare with this teacher once again.

kyle

Nigeria

Dec 11, 2018

This course is very clear and can be learnt with ease. The addresses are very much developed to enable the students to get each idea effortlessly. Very much illustrated.

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:^*

Limited Time Discount Offer
40% Off - Ends in 02:00:00

70-473: Designing and Implementing Cloud Data Platform Solutions

Curriculum For This Course