Professional Azure SQL Database Administration

Professional Azure SQL Database Administration, available at $64.99, has an average rating of 3.95, with 66 lectures, 9 quizzes, based on 523 reviews, and has 2061 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful 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.

Enroll now: Professional Azure SQL Database Administration

Summary

Title: Professional Azure SQL Database Administration

Price: $64.99

Average Rating: 3.95

Number of Lectures: 66

Number of Quizzes: 9

Number of Published Lectures: 66

Number of Published Quizzes: 9

Number of Curriculum Items: 75

Number of Published Curriculum Objects: 75

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 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

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

Lecture 1: Lesson Overview

Lecture 2: Migration Methodology

Lecture 3: Azure SQL Database Service Tiers

Lecture 4: Determining an Appropriate Service Tier

Lecture 5: Determining Compatibility Issues

Lecture 6: Determining the Migration Method

Lecture 7: Summary

Chapter 3: Backing up the Azure SQL Database

Lecture 1: Lesson Overview

Lecture 2: Automatic Backups

Lecture 3: Manual Backups

Lecture 4: DACPAC and BACPAC

Lecture 5: Summary

Chapter 4: Restoring an Azure SQL Database

Lecture 1: Lesson Introduction

Lecture 2: Restore Types

Lecture 3: Restore Databases

Lecture 4: Summary

Chapter 5: Securing an Azure SQL Database

Lecture 1: Lesson Introduction

Lecture 2: Access Control

Lecture 3: Restore Databases

Lecture 4: SQL Authentication and Azure Active Directory

Lecture 5: Row Level Security

Lecture 6: Dynamic Data Masking

Lecture 7: Proactive Security

Lecture 8: Summary

Chapter 6: Scaling out Azure SQL Database

Lecture 1: Lesson Introduction

Lecture 2: Vertical Scaling

Lecture 3: Horizontal Scaling

Lecture 4: Data Dependent Routing

Lecture 5: Creating Shards part 1

Lecture 6: Creating Shards part 2

Lecture 7: Creating Shards part 3

Lecture 8: Summary

Chapter 7: Elastic Pools

Lecture 1: Lesson Introduction

Lecture 2: Elastic Pools

Lecture 3: Elastic Database Transaction Units

Lecture 4: Sizing Best Practices

Lecture 5: Elastic Jobs

Lecture 6: Elastic Job Workflow

Lecture 7: Summary

Chapter 8: High Availability and Disaster Recovery

Lecture 1: Lesson Introduction

Lecture 2: High Availability

Lecture 3: Disaster Recovery

Lecture 4: Auto Failover Groups

Lecture 5: Configuring Active Geo-Replication

Lecture 6: Configuring Auto Failover Group

Lecture 7: Summary

Chapter 9: Monitoring and Tuning Azure SQL Database

Lecture 1: Lesson Introduction

Lecture 2: Monitoring an Azure SQL Database Using the Azure Portal

Lecture 3: Database Size

Lecture 4: Using DMVs

Lecture 5: Monitoring Connections and Query Performance

Lecture 6: Monitoring Blocking

Lecture 7: Tuning an Azure SQL Database

Lecture 8: In-Memory Technologies

Lecture 9: Summary

Instructors

Packt Publishing
Tech Knowledge in Motion

Rating Distribution

1 stars: 27 votes

2 stars: 33 votes

3 stars: 113 votes

4 stars: 192 votes

5 stars: 158 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!