O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Professional Azure SQL Database Administration

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.

Table of Contents

  1. Chapter 1 : Functional Programming and Lazy Operations
    1. Introduction 00:03:20
    2. Installation and Setup 00:03:31
    3. Course Overview 00:01:13
    4. Microsoft Azure SQL Database Primer 00:01:32
    5. Azure SQL Database Architecture 00:05:34
    6. Database Request Flow and Provisioning 00:02:00
    7. Creating, Connecting and Querying the Database from the Azure Portal 00:06:52
    8. Deleting Resources 00:05:47
    9. Differences between Azure SQL Database and SQL Server 00:08:52
    10. Unsupported Features 00:05:19
    11. Summary 00:00:55
  2. Chapter 2 : Migrating a SQL Server Database to an Azure SQL Database
    1. Lesson Overview 00:01:08
    2. Migration Methodology 00:04:00
    3. Azure SQL Database Service Tiers 00:12:30
    4. Determining an Appropriate Service Tier 00:07:55
    5. Determining Compatibility Issues 00:03:43
    6. Determining the Migration Method 00:06:11
    7. Summary 00:00:41
  3. Chapter 3 : Backing up the Azure SQL Database
    1. Lesson Overview 00:01:20
    2. Automatic Backups 00:05:24
    3. Manual Backups 00:03:42
    4. DACPAC and BACPAC 00:04:12
    5. Summary 00:01:35
  4. Chapter 4 : Restoring an Azure SQL Database
    1. Lesson Introduction 00:01:37
    2. Restore Types 00:07:57
    3. Restore Databases 00:05:31
    4. Summary 00:00:55
  5. Chapter 5 : Securing an Azure SQL Database
    1. Lesson Introduction 00:02:03
    2. Access Control 00:11:59
    3. Restore Databases 00:04:40
    4. SQL Authentication and Azure Active Directory 00:06:09
    5. Row Level Security 00:05:45
    6. Dynamic Data Masking 00:02:57
    7. Proactive Security 00:05:15
    8. Summary 00:01:05
  6. Chapter 6 : Scaling out Azure SQL Database
    1. Lesson Introduction 00:01:33
    2. Vertical Scaling 00:07:02
    3. Horizontal Scaling 00:07:52
    4. Data Dependent Routing 00:07:56
    5. Creating Shards part 1 00:11:35
    6. Creating Shards part 2 00:12:46
    7. Creating Shards part 3 00:10:59
    8. Summary 00:00:26
  7. Chapter 7 : Elastic Pools
    1. Lesson Introduction 00:00:39
    2. Elastic Pools 00:03:42
    3. Elastic Database Transaction Units 00:07:12
    4. Sizing Best Practices 00:05:57
    5. Elastic Jobs 00:03:28
    6. Elastic Job Workflow 00:01:22
    7. Summary 00:00:29
  8. Chapter 8 : High Availability and Disaster Recovery
    1. Lesson Introduction 00:00:36
    2. High Availability 00:02:19
    3. Disaster Recovery 00:05:22
    4. Auto Failover Groups 00:06:27
    5. Configuring Active Geo-Replication 00:02:44
    6. Configuring Auto Failover Group 00:03:38
    7. Summary 00:01:02
  9. Chapter 9 : Monitoring and Tuning Azure SQL Database
    1. Lesson Introduction 00:00:55
    2. Monitoring an Azure SQL Database Using the Azure Portal 00:05:54
    3. Database Size 00:03:54
    4. Using DMVs 00:01:08
    5. Monitoring Connections and Query Performance 00:08:10
    6. Monitoring Blocking 00:09:03
    7. Tuning an Azure SQL Database 00:02:53
    8. In-Memory Technologies 00:07:32
    9. Summary 00:01:15