Video 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.
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
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#.
About The Author
Gethyn Ellis: Gethyn Ellis has over eighteen years of experience with SQL Server and for past ten years he has been working on Azure. He is an 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" , "Microsoft Azure laaS Essentials", and Professional Azure SQL Database Administration.
Table of contents
-
Chapter 1 : Functional Programming and Lazy Operations
- Introduction
- Installation and Setup
- Course Overview
- Microsoft Azure SQL Database Primer
- Azure SQL Database Architecture
- Database Request Flow and Provisioning
- Creating, Connecting and Querying the Database from the Azure Portal
- Deleting Resources
- Differences between Azure SQL Database and SQL Server
- Unsupported Features
- Summary
- Chapter 2 : Migrating a SQL Server Database to an Azure SQL Database
- Chapter 3 : Backing up the Azure SQL Database
- Chapter 4 : Restoring an Azure SQL Database
- Chapter 5 : Securing an Azure SQL Database
- Chapter 6 : Scaling out Azure SQL Database
- Chapter 7 : Elastic Pools
- Chapter 8 : High Availability and Disaster Recovery
- Chapter 9 : Monitoring and Tuning Azure SQL Database
Product information
- Title: Professional Azure SQL Database Administration
- Author(s):
- Release date: September 2018
- Publisher(s): Packt Publishing
- ISBN: 9781789535495
You might also like
book
Professional Azure SQL Database Administration - Second Edition
Leverage the features of Azure SQL database and become an expert in data management Key Features …
book
Professional Azure SQL Managed Database Administration - Third Edition
Master data management by effectively utilizing the features of Azure SQL database. Key Features Learn to …
book
Azure SQL Revealed: A Guide to the Cloud for SQL Server Professionals
Access detailed content and examples on Azure SQL, a set of cloud services that allows for …
video
Introducing Azure SQL Database: From Deployment over Migration to Monitoring
Discover everything you need to know to get started with Azure SQL Database, from deployment, to …