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.

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

  1. Chapter 1 : Functional Programming and Lazy Operations
    1. Introduction
    2. Installation and Setup
    3. Course Overview
    4. Microsoft Azure SQL Database Primer
    5. Azure SQL Database Architecture
    6. Database Request Flow and Provisioning
    7. Creating, Connecting and Querying the Database from the Azure Portal
    8. Deleting Resources
    9. Differences between Azure SQL Database and SQL Server
    10. Unsupported Features
    11. Summary
  2. Chapter 2 : Migrating a SQL Server Database to an Azure SQL Database
    1. Lesson Overview
    2. Migration Methodology
    3. Azure SQL Database Service Tiers
    4. Determining an Appropriate Service Tier
    5. Determining Compatibility Issues
    6. Determining the Migration Method
    7. Summary
  3. Chapter 3 : Backing up the Azure SQL Database
    1. Lesson Overview
    2. Automatic Backups
    3. Manual Backups
    4. DACPAC and BACPAC
    5. Summary
  4. Chapter 4 : Restoring an Azure SQL Database
    1. Lesson Introduction
    2. Restore Types
    3. Restore Databases
    4. Summary
  5. Chapter 5 : Securing an Azure SQL Database
    1. Lesson Introduction
    2. Access Control
    3. Restore Databases
    4. SQL Authentication and Azure Active Directory
    5. Row Level Security
    6. Dynamic Data Masking
    7. Proactive Security
    8. Summary
  6. Chapter 6 : Scaling out Azure SQL Database
    1. Lesson Introduction
    2. Vertical Scaling
    3. Horizontal Scaling
    4. Data Dependent Routing
    5. Creating Shards part 1
    6. Creating Shards part 2
    7. Creating Shards part 3
    8. Summary
  7. Chapter 7 : Elastic Pools
    1. Lesson Introduction
    2. Elastic Pools
    3. Elastic Database Transaction Units
    4. Sizing Best Practices
    5. Elastic Jobs
    6. Elastic Job Workflow
    7. Summary
  8. Chapter 8 : High Availability and Disaster Recovery
    1. Lesson Introduction
    2. High Availability
    3. Disaster Recovery
    4. Auto Failover Groups
    5. Configuring Active Geo-Replication
    6. Configuring Auto Failover Group
    7. Summary
  9. Chapter 9 : Monitoring and Tuning Azure SQL Database
    1. Lesson Introduction
    2. Monitoring an Azure SQL Database Using the Azure Portal
    3. Database Size
    4. Using DMVs
    5. Monitoring Connections and Query Performance
    6. Monitoring Blocking
    7. Tuning an Azure SQL Database
    8. In-Memory Technologies
    9. Summary

Product information

  • Title: Professional Azure SQL Database Administration
  • Author(s): Gethyn Ellis
  • Release date: September 2018
  • Publisher(s): Packt Publishing
  • ISBN: 9781789535495