Professional Azure SQL Database Administration
3.7 (227 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,015 students enrolled

Professional Azure SQL Database Administration

Master your skills to efficiently manage and maintain data on the cloud
3.7 (227 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,016 students enrolled
Created by Packt Publishing
Last updated 11/2018
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 66 lectures 04:58:26
+ Functional Programming and Lazy Operations
11 lectures 44:49

This video gives a brief introduction of what we will be covering in this course.   

Preview 03:19

This video shows you to install and setup the required software’s for this course.   

Installation and Setup
03:30

This video will show you the lessons that will be covered in this course.   

Course Overview
01:13

This video gives an introduction and objectives for this lesson.   

Microsoft Azure SQL Database Primer
01:32

In this video, you will learn about the different layers in the database architecture.   

Azure SQL Database Architecture
05:34

In this video, you will take a look at the SQL database request flow and provisioning an SQL database.   

Database Request Flow and Provisioning
02:00

This video shows you how to create, connect and query the database from the Azure portal.   

Creating, Connecting and Querying the Database from the Azure Portal
06:51

This video shows you how to delete Azure SQL Database, Azure SQL Server, and Azure Resource group.   

Deleting Resources
05:46

This video shows you some of the important features which differs from on premises SQL Server.   

Differences between Azure SQL Database and SQL Server
08:52

This video shows you some of the main features not supported by Azure SQL Database or Azure SQL Server.   

Unsupported Features
05:18

This video summarizes your learning of this lesson.   

Summary
00:54
Test Your Knowledge
3 questions
+ Migrating a SQL Server Database to an Azure SQL Database
7 lectures 36:04

This video gives you an overview of this lesson.   

Preview 01:08

This video shows you the ideal migration methodology.      

Migration Methodology
03:59

This video shows you about the different service tiers for Azure SQL Database Service and how to scale up and change them.   

Azure SQL Database Service Tiers
12:29

In this video you will learn how to choose the right service tier by using the Azure Database DTU calculator.   

Determining an Appropriate Service Tier
07:54

In this video you will see the different tools to detect compatibility issues.   

Determining Compatibility Issues
03:43

This video shows you the comparison of various migration methods to help you correctly choose a migration method.   

Determining the Migration Method
06:10

This video summarizes your learning of this lesson.   

Summary
00:41
Test Your Knowledge
4 questions
+ Backing up the Azure SQL Database
5 lectures 16:10

This video will show you the topics that will be covered.   

Preview 01:19

This video shows you the functions of automatic backups, storage and retention period.   

Automatic Backups
05:23

This video will show you the methods of manual backups.   

Manual Backups
03:41

In this video you will have an understanding of dacpac and bacpac.   

DACPAC and BACPAC
04:12

This video summarizes your learning of this lesson.     

Summary
01:35
Test Your Knowledge
2 questions
+ Restoring an Azure SQL Database
4 lectures 15:58

This video will give an introduction to this lesson.   

Preview 01:36

This video shows you the different types of restore available in Azure SQL Database   

Restore Types
07:57

This video will show you about restoring deleted database using the Azure portal.   

Restore Databases
05:30

This video summarizes your learning of this lesson.   

Summary
00:55
Test Your Knowledge
4 questions
+ Securing an Azure SQL Database
8 lectures 39:53

This video will give an introduction to this lesson.   

Preview 02:03

This video shows you the functionalities of Firewall rules.

Access Control
11:59

This video will show you about restoring deleted database using the Azure portal.   

Restore Databases
04:40

In this video you will have an understanding of SQL authentication and active directory.   

SQL Authentication and Azure Active Directory
06:09

This video shows you about the Login manager, Groups and Roles and advantages of Row level security.   

Row Level Security
05:45

In this video you will understand Dynamic Data Masking types and its limitations.   

Dynamic Data Masking
02:57

This video shows you that Azure SQL Database provides Auditing and Threat detection to proactively protect it from malicious attacks.   

Proactive Security
05:15

This video summarizes the topics covered in this lesson

Summary
01:05
Test Your Knowledge
2 questions
+ Scaling out Azure SQL Database
8 lectures 01:00:05

This video will give an introduction to this lesson.   

Preview 01:33

This video shows you different types of scaling and using the T-sql to change the service tier.   

Vertical Scaling
07:01

This video will tell you about the horizontal scaling and what is sharding and components of shard.   

Horizontal Scaling
07:51

This video shows you what is data dependent routing and their parameters. Also it covers the types of Multi-Tenant Data Models.   

Data Dependent Routing
07:56

This video shows you how to create shards.

Creating Shards part 1
11:34

This video shows you how to create shards.

Creating Shards part 2
12:46

This video shows you how to create shards.

Creating Shards part 3
10:58

This video summarizes the topics covered in this lesson.   

Summary
00:26
Test Your Knowledge
3 questions
+ Elastic Pools
7 lectures 22:46

This video will give an introduction to this lesson.   

Preview 00:39

This video briefs you about elastic pools and when should you consider it.   

Elastic Pools
03:41

This video explains you about elastic database transaction units and sizing an elastic pool.   

Elastic Database Transaction Units
07:11

This video shows you about best practices of sizing and changing the service tier using T-SQL.   

Sizing Best Practices
05:57

This video shows you the uses and architecture of elastic job.   

Elastic Jobs
03:28

This video shows you how an elastic job works.

Elastic Job Workflow
01:22

This video summarizes the topics covered in this lesson.

Summary
00:28
Test Your Knowledge
3 questions
+ High Availability and Disaster Recovery
7 lectures 22:03

This video will give an introduction to this lesson.   

Preview 00:36

This video tells you about providing business continuity when the physical server hosting the Azure SQL Database fails.   

High Availability
02:18

This video explains you about business continuity in case of a natural disaster or hacking that terminates an entire Azure region.

Disaster Recovery
05:21

This video shows you the different types of auto failover group.   

Auto Failover Groups
06:27

This video shows you how to configure active geo replication and performing a manual failover.   

Configuring Active Geo-Replication
02:43

This video shows you how to configure auto failover group for a standalone Azure SQL Database.   

Configuring Auto Failover Group
03:37

This video summarizes the topics covered in this lesson.   

Summary
01:01
Test Your Knowledge
2 questions
+ Monitoring and Tuning Azure SQL Database
9 lectures 40:38

This video will give an introduction to this lesson.

Preview 00:54

This video tells you about providing business continuity when the physical server hosting the Azure SQL Database fails.   

Monitoring an Azure SQL Database Using the Azure Portal
05:53

This video shows you how to change the database size and also covers the diagnostic settings.   

Database Size
03:53

This video shows you how to monitor an Azure SQL Database Using DMVs.   

Using DMVs
01:07

This video tells you about how to monitor connections and also about the Dynamic management function.   

Monitoring Connections and Query Performance
08:10

This video shows you how to monitor the blockings and about the extended events and its components.   

Monitoring Blocking
09:02

This video shows you about automatic tuning and how to enable it.   

Tuning an Azure SQL Database
02:53

This video tells you about In-memory technologies and its different types.   

In-Memory Technologies
07:32

This video summarizes the topics covered in this lesson.   

Summary
01:14
Test Your Knowledge
4 questions
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 Authors

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

Who this course is for:
  • 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.