Microsoft Azure SQL Database Administration

Focused View

Emar Morrison,Adrianna Parchment

4:33:17

120 View

1. Introduction

2. Getting Started with Azure SQL

1. What is Azure zone & regions.mp4

04:36

2. Azure SQL deployment options.mp4

06:19

3. Purchasing models, service tiers, and hardware choices.mp4

05:50

4. Getting Started with Azure Free Tier.mp4

04:18

5. Management interfaces Azure Portal.mp4

03:30

3. Deploy and configure servers, instances, and databases for Azure SQL

1. Introduction.mp4

00:18

2. Deploying Azure SQL Databases.mp4

12:09

3. Exploring SQL Server Management Studio.mp4

06:47

4. Exploring Azure Data Studio.mp4

05:49

5. Deploying SQL Server Managed Instance.mp4

02:24

6. Deploy SQL Server on Azure VM.mp4

05:20

4. Configure database authentication and authorization

1. Introduction.mp4

01:04

2. Authentication with Azure Active Directory.mp4

09:57

3.1 create user from aad.zip

3. Configure and Create AAD Users.mp4

08:14

4. Securables and Database Roles.mp4

05:24

5. Managing Security with Firewall Rules.mp4

03:11

6.1 granting permissions.zip

6. Granting Permissions on Securables.mp4

09:46

5. Implement compliance controls for sensitive data

1. Introduction.mp4

00:22

2.1 data classification.zip

2. Data classification and Discovery.mp4

08:38

3.1 auditing test.zip

3. Auditing Azure SQL Databases.mp4

11:07

4. Implement Row Level security.mp4

06:29

5. Microsoft Defender for Cloud.mp4

07:05

6. Protect data in-transit and at rest and in-transit

1. Explore Transparent Data Encryption.mp4

03:36

2. Object encryption and secure enclaves.mp4

11:50

3. Dynamic Data Masking.mp4

05:01

4. Enable encrypted connections.mp4

02:08

7. Deploy highly available solutions by using Azure SQL

1. Backup and restore strategies.mp4

07:00

2. Disaster Recovery.mp4

04:15

3. Restore to Point-in-Time and deleted databases.mp4

07:10

4. High Availability by service tier.mp4

06:36

8. Migrating to Azure

1. Migration using Application Data Tier.mp4

05:44

2.1 Migration With SQL Package.txt

2.2 SQL Package Documentation.html

2. Migration using SQL Package.mp4

07:36

3.1 Download Microsoft Integration Service.html

3. Migration using Azure Data Studio.mp4

06:48

4. Migration using Data Migration Assistant.mp4

06:24

9. Performance & Monitoring with Azure SQL

1. Monitoring Using Azure Portal.mp4

08:09

2. Intelligent Performance.mp4

06:30

3. Database Console Commands for SQL Server.mp4

02:20

4. Monitoring with Dynamic Management Views (DMVs).mp4

03:31

5. Introduction to Azure SQL Query Store.mp4

08:05

6.1 index tutorial.zip

6. Performance Tuning with Indexes.mp4

19:34

7.1 monitering blocking.zip

7.2 monitering uncomminted transactions.zip

7.3 simulating blocking script 1.zip

7.4 simulating blocking script 2.zip

7. Monitoring and Resolving Blocking.mp4

08:16

10. Automation & Maintenance

1. Introduction.mp4

01:18

2. Azure Automation Account.mp4

02:13

3. Automating Task With Runbooks.mp4

09:24

4. Unsupported Features in Azure SQL.html

11. Conclusion

1. Last Words.mp4

01:12

Description

Azure SQL Database Administration

What You'll Learn?

Students will learn how to create and manage databases in Azure dents and individuals who are interested in learning about databases and SQL as a career path
Students will learn how to migrate data from on-premises databases to Azure SQL Database, including best practices and considerations for the migration process.
Students will learn how to monitor and troubleshoot Azure SQL Database
Students will learn how to scale and configure high availability solutions in Azure SQL Database, including how to set up geo-replication and failover groups.

Who is this for?

SQL Server DBA

Aspiring DBAs

Microsoft DP300 students

Cloud Engineers

What You Need to Know?

Knowledge of database objects would be great but not required.

More details

Description
The Microsoft Certified: Azure Database Administrator Associate course is designed for individuals who want to gain expertise in managing and maintaining cloud-based databases using Microsoft Azure. This course provides a comprehensive understanding of database management in Azure and prepares students for the Azure Database Administrator Associate certification exam.
The course covers the following topics:
Introduction to Azure Databases: This section provides an overview of Azure databases and their benefits. Students will learn about different types of databases available in Azure, such as Azure SQL Database, Azure Database for MySQL, and Azure Database for PostgreSQL.
Designing and Implementing Azure Databases: This section covers the design and implementation of Azure databases. Students will learn how to create and configure databases, implement security measures, and optimize database performance.
Monitoring and Optimizing Azure Databases: This section covers techniques for monitoring and optimizing Azure databases. Students will learn how to use Azure Monitor to track database performance, implement backup and recovery strategies, and manage database growth.
Managing and Maintaining Azure Databases: This section covers the day-to-day management and maintenance of Azure databases. Students will learn how to manage database users and permissions, troubleshoot common issues, and implement disaster recovery measures.
Upon completion of the course, students will have a thorough understanding of managing and maintaining Azure databases and be prepared to take the Microsoft Certified: Azure Database Administrator Associate certification exam. This certification validates the student's skills in implementing and managing databases in Azure and demonstrates their expertise in cloud-based database administration.

Who this course is for:
SQL Server DBA
Aspiring DBAs
Microsoft DP300 students
Cloud Engineers

User Reviews

Rating

average 0

Total votes0

Focused display

Emar J. Morrison is a 30-year-old investor with a love for personal finance and investment. For the past four years, he has been investing in the stock market. In 2016, he bought his first stocks with little idea what he was doing. He was, nevertheless, completely enthralled, and he buried himself in it.He read a lot of books and researched investors like RULE 1 Investing’s Phil Town, Peter Lynch, Michael Lee-Chin, and, of course, Warren Buffet over the next few years. He has read George S. Clason’s The Richest Man in Babylon, Benjamin Graham’s The Intelligent Investor, Money Master The Game, and Tony Robbins’ The Unshakable.

Adrianna Parchment

Instructor's Courses

I am an Azure presales consultant with experience in Azure Networking and Administration. I help organizations understand cloud concepts, how to utilize and integrate cloud into their environments. I am certified in AZ700, AZ104 And AZ-500 My aim is to teach students how to understand and use cloud concepts and tools as well as to implement these in their organisations.

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.