Professional Azure Sql Database Administration

Master your skills to efficiently manage and maintain data on the cloud

What you'll learn

Build a new Azure SQL Database or migrate to it from an on-premise SQL Database

Backup, restore, secure, and scale an Azure SQL Database

Monitor and tune an Azure SQL Database

Implement the high availability and disaster recovery features

Automate common management tasks with PowerShell

Develop a scalable cloud solution with SQL Database

Requirements

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#.

Description

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. About the AuthorsGethyn Ellis has over eighteen years of experience wit SQL Server and for past ten years he has been working on Azure. He is Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" and, "Microsoft Azure laaS Essentials".Ahmad Osama is an independent consultant for Microsoft data platform stack. He has provided consulting, training, content development and SQL support services to more than 120 SQL Server customers globally. An expert in SQL Server and related technologies, he frequently speaks at user group events and conferences. Over the last 9 years, he has worked on countless SQL Server projects, consulted, trained, and mentored more than 1000 IT professionals on SQL Server, delivered more than 50 workshops. Ahmad has been a Microsoft Most Valuable Professional (MVP) awardee for SQL Server from 2014 - 2016.Currently, he works for Pitney Bowes Pvt. Ltd. as a database engineer and is a Microsoft Data Platform rMVP. In his day to day job at Pitney Bowes, he works on developing and maintaining high performance on-premise and cloud SQL Server OLTP environments, building CI/CD environments for databases and automation.Other than his day to day work, Ahmad has written over 100 blogs, including SQL Server Administration/Development, Azure SQL Database, and Azure Data Factory. He regularly speaks at user group events and webinars conducted by the Dataplatformlabs community.

Overview

Section 1: Functional Programming and Lazy Operations

Lecture 1 Introduction

Lecture 2 Installation and Setup

Lecture 3 Course Overview

Lecture 4 Microsoft Azure SQL Database Primer

Lecture 5 Azure SQL Database Architecture

Lecture 6 Database Request Flow and Provisioning

Lecture 7 Creating, Connecting and Querying the Database from the Azure Portal

Lecture 8 Deleting Resources

Lecture 9 Differences between Azure SQL Database and SQL Server

Lecture 10 Unsupported Features

Lecture 11 Summary

Section 2: Migrating a SQL Server Database to an Azure SQL Database

Lecture 12 Lesson Overview

Lecture 13 Migration Methodology

Lecture 14 Azure SQL Database Service Tiers

Lecture 15 Determining an Appropriate Service Tier

Lecture 16 Determining Compatibility Issues

Lecture 17 Determining the Migration Method

Lecture 18 Summary

Section 3: Backing up the Azure SQL Database

Lecture 19 Lesson Overview

Lecture 20 Automatic Backups

Lecture 21 Manual Backups

Lecture 22 DACPAC and BACPAC

Lecture 23 Summary

Section 4: Restoring an Azure SQL Database

Lecture 24 Lesson Introduction

Lecture 25 Restore Types

Lecture 26 Restore Databases

Lecture 27 Summary

Section 5: Securing an Azure SQL Database

Lecture 28 Lesson Introduction

Lecture 29 Access Control

Lecture 30 Restore Databases

Lecture 31 SQL Authentication and Azure Active Directory

Lecture 32 Row Level Security

Lecture 33 Dynamic Data Masking

Lecture 34 Proactive Security

Lecture 35 Summary

Section 6: Scaling out Azure SQL Database

Lecture 36 Lesson Introduction

Lecture 37 Vertical Scaling

Lecture 38 Horizontal Scaling

Lecture 39 Data Dependent Routing

Lecture 40 Creating Shards part 1

Lecture 41 Creating Shards part 2

Lecture 42 Creating Shards part 3

Lecture 43 Summary

Section 7: Elastic Pools

Lecture 44 Lesson Introduction

Lecture 45 Elastic Pools

Lecture 46 Elastic Database Transaction Units

Lecture 47 Sizing Best Practices

Lecture 48 Elastic Jobs

Lecture 49 Elastic Job Workflow

Lecture 50 Summary

Section 8: High Availability and Disaster Recovery

Lecture 51 Lesson Introduction

Lecture 52 High Availability

Lecture 53 Disaster Recovery

Lecture 54 Auto Failover Groups

Lecture 55 Configuring Active Geo-Replication

Lecture 56 Configuring Auto Failover Group

Lecture 57 Summary

Section 9: Monitoring and Tuning Azure SQL Database

Lecture 58 Lesson Introduction

Lecture 59 Monitoring an Azure SQL Database Using the Azure Portal

Lecture 60 Database Size

Lecture 61 Using DMVs

Lecture 62 Monitoring Connections and Query Performance

Lecture 63 Monitoring Blocking

Lecture 64 Tuning an Azure SQL Database

Lecture 65 In-Memory Technologies

Lecture 66 Summary

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.