Professional Azure SQL Database Administration 2018

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.
https://www.udemy.com/course/professional-azure-sql-database-administration/


Professional Azure SQL Database Administration 2018 Fast Download
Professional Azure SQL Database Administration 2018 Full Download