Video description
Master your skills to efficiently manage and maintain data on the cloud
About This Video
- Explains data management aspects, such as security, high availability, and disaster recovery
- Explains various features using everyday work scenarios as examples
- Paves an easy-to-follow path for navigating through concepts
In Detail
Azure SQL Database is the cloud version of SQL Server. It differs in terms of management, maintenance and administration. It’s important to know how to administer SQL Database so that you can get the most out of the features that it provides. You will learn different management aspects of an Azure SQL Database, such as migration, backup and restoration, pricing, security, scalability, monitoring and performance optimization, high availability and disaster recovery. You’ll start by understanding the architecture of the Azure SQL Database and its service tiers. Through a narrative of a DBA, who is migrating from a traditional on-premises system to Azure SQL Database, this course will explain the concepts by using different scenarios you might come across while working with Azure SQL Database. If you are interested in developing new or migrating existing applications with Azure SQL Database, then this course is for you.
Audience
This course is designed for database administrators, database developers, and application developers, who want to develop applications with Azure SQL Database, or migrate from their old applications. To gain maximum benefits from this course, you should have prior experience of working on an on-premises SQL Server and you know PowerShell and C#.
Table of Contents
Chapter 1 : Functional Programming and Lazy Operations
Introduction
Installation and Setup
Course Overview
Microsoft Azure SQL Database Primer
Azure SQL Database Architecture
Database Request Flow and Provisioning
Creating, Connecting and Querying the Database from the Azure Portal
Deleting Resources
Differences between Azure SQL Database and SQL Server
Unsupported Features
Summary
Chapter 2 : Migrating a SQL Server Database to an Azure SQL Database
Lesson Overview
Migration Methodology
Azure SQL Database Service Tiers
Determining an Appropriate Service Tier
Determining Compatibility Issues
Determining the Migration Method
Summary
Chapter 3 : Backing up the Azure SQL Database
Lesson Overview
Automatic Backups
Manual Backups
DACPAC and BACPAC
Summary
Chapter 4 : Restoring an Azure SQL Database
Lesson Introduction
Restore Types
Restore Databases
Summary
Chapter 5 : Securing an Azure SQL Database
Lesson Introduction
Access Control
Restore Databases
SQL Authentication and Azure Active Directory
Row Level Security
Dynamic Data Masking
Proactive Security
Summary
Chapter 6 : Scaling out Azure SQL Database
Lesson Introduction
Vertical Scaling
Horizontal Scaling
Data Dependent Routing
Creating Shards part 1
Creating Shards part 2
Creating Shards part 3
Summary
Chapter 7 : Elastic Pools
Lesson Introduction
Elastic Pools
Elastic Database Transaction Units
Sizing Best Practices
Elastic Jobs
Elastic Job Workflow
Summary
Chapter 8 : High Availability and Disaster Recovery
Lesson Introduction
High Availability
Disaster Recovery
Auto Failover Groups
Configuring Active Geo-Replication
Configuring Auto Failover Group
Summary
Chapter 9 : Monitoring and Tuning Azure SQL Database
Lesson Introduction
Monitoring an Azure SQL Database Using the Azure Portal
Database Size
Using DMVs
Monitoring Connections and Query Performance
Monitoring Blocking
Tuning an Azure SQL Database
In-Memory Technologies
Summary