Hands-On - Azure SQL Database Training for IT Architect

Hands-On : Azure SQL Database Training for IT Architect, available at $19.99, has an average rating of 5, with 27 lectures, based on 3 reviews, and has 11 subscribers.

You will learn about Understanding Service tiers and Availability models of Azure SQL Database Learning about how to do scale-up and read scale-out Understanding elastic pool and elastic query Gaining an understanding of high availability and disaster recovery Learning about security-related features Understanding how to do automated deployment Learning about tools for monitoring and troubleshooting This course is ideal for individuals who are The course is ideal for IT Architects, Database Administrators, Developers, and anyone interested in designing and managing Azure SQL Database solutions. It is particularly useful for The course is ideal for IT Architects, Database Administrators, Developers, and anyone interested in designing and managing Azure SQL Database solutions.

Enroll now: Hands-On : Azure SQL Database Training for IT Architect

Summary

Title: Hands-On : Azure SQL Database Training for IT Architect

Price: $19.99

Average Rating: 5

Number of Lectures: 27

Number of Published Lectures: 27

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Understanding Service tiers and Availability models of Azure SQL Database

Learning about how to do scale-up and read scale-out

Understanding elastic pool and elastic query

Gaining an understanding of high availability and disaster recovery

Learning about security-related features

Understanding how to do automated deployment

Learning about tools for monitoring and troubleshooting

Who Should Attend

The course is ideal for IT Architects, Database Administrators, Developers, and anyone interested in designing and managing Azure SQL Database solutions.

Target Audiences

The course is ideal for IT Architects, Database Administrators, Developers, and anyone interested in designing and managing Azure SQL Database solutions.

Azure SQL Database is Platform as a Service for Relational Database Management System (RDBMS) developed by Microsoft. This comprehensive training will equip you with the skills and knowledge needed to design and manage “Performance & Scalability”, “Redundancy and Fault-tolerance”, “Security”, “Portability and Deployment” and “Monitoring and Troubleshooting”.

1. Introduction

Gain a fundamental understanding of Azure SQL Database. Understand the difference between Azure SQL Database, SQL Managed Instance and SQL virtual machine.

2. Performance & Scalability

Understand “Service tiers and Availability models” of Azure SQL Database. Learn how to do scale-up/read scale-out can be done on each availability model, and implementing elastic pool and elastic query.

3. Redundancy and Fault-tolerance

Understand architecture of each availability model, and how to implement “High Availability and Disaster Recovery”. Learn Azure SQL Database backup/restore mechanism.

4. Security

Explore Azure SQL Database comprehensive security functionalities, including authentication/authorization, service/private endpoint, always encrypted, dynamic data masking, ledger table, auditing.

5. Portability and Deployment

Learn how to do automated-deployment of Azure SQL Database with Azure DevOps Pipeline. Integrate Azure Key Vault and Azure DevOps Pipeline to mask credential information.

6. Monitoring and Troubleshooting

Learn about Azure SQL Databases built-in monitoring and troubleshooting tools such as dashboard using metrics, alerts, dynamic management views (DMV) and extended events.

Course Curriculum

Chapter 1: Introduction

Lecture 1: What is Azure SQL Database?

Lecture 2: Preparation for using Microsoft Azure

Lecture 3: Learning contents of the course

Chapter 2: A. Performance and Scalability

Lecture 1: Service tiers and Availability models

Lecture 2: Scale-up and Read scale-out

Lecture 3: Elastic pool

Lecture 4: Elastic query

Chapter 3: B. Redundancy and Fault-tolerance

Lecture 1: High Availability and Disaster Recovery

Lecture 2: Backup and Restore

Lecture 3: Export and Import

Chapter 4: C. Security

Lecture 1: SQL authentication

Lecture 2: Azure AD authentication

Lecture 3: Managed Identity authentication

Lecture 4: Public network access

Lecture 5: Service endpoint access

Lecture 6: Private endpoint access

Lecture 7: Always Encrypted

Lecture 8: Dynamic Data Masking

Lecture 9: Ledger

Lecture 10: Auditing

Chapter 5: D. Portability and Deployment

Lecture 1: Deployment with ARM Template

Lecture 2: Deployment with Azure DevOps

Lecture 3: Parameterization on DevOps pipeline using Azure Key Vault

Chapter 6: E. Monitoring and Troubleshooting

Lecture 1: Metrics and Dashboard

Lecture 2: Alerts

Lecture 3: Dynamic Management Views (DMV)

Lecture 4: Extended Events

Instructors

DFirst Education
Cloud implementation and IT Architecting

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!