Professional Azure SQL Database Administration [eLearning]

September 30, 2018 Courses
Professional Azure SQL Database Administration [eLearning]

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 4h 58m | 1.28 GB

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

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
Table of Contents

1 Introduction
2 Installation and Setup
3 Summary
4 Lesson Overview
5 Migration Methodology
6 Azure SQL Database Service Tiers
7 Determining an Appropriate Service Tier
8 Determining Compatibility Issues
9 Determining the Migration Method
10 Summary
11 Lesson Overview
12 Automatic Backups
13 Course Overview
14 Manual Backups
15 DACPAC and BACPAC
16 Summary
17 Lesson Introduction
18 Restore Types
19 Restore Databases
20 Summary
21 Lesson Introduction
22 Access Control
23 Restore Databases
24 Microsoft Azure SQL Database Primer
25 SQL Authentication and Azure Active Directory
26 Row Level Security
27 Dynamic Data Masking
28 Proactive Security
29 Summary
30 Lesson Introduction
31 Vertical Scaling
32 Horizontal Scaling
33 Data Dependent Routing
34 Creating Shards part 1
35 Azure SQL Database Architecture
36 Creating Shards part 2
37 Creating Shards part 3
38 Summary
39 Lesson Introduction
40 Elastic Pools
41 Elastic Database Transaction Units
42 Sizing Best Practices
43 Elastic Jobs
44 Elastic Job Workflow
45 Summary
46 Database Request Flow and Provisioning
47 Lesson Introduction
48 High Availability
49 Disaster Recovery
50 Auto Failover Groups
51 Configuring Active Geo-Replication
52 Configuring Auto Failover Group
53 Summary
54 Lesson Introduction
55 Monitoring an Azure SQL Database Using the Azure Portal
56 Database Size
57 Creating, Connecting and Querying the Database from the Azure Portal
58 Using DMVs
59 Monitoring Connections and Query Performance
60 Monitoring Blocking
61 Tuning an Azure SQL Database
62 In-Memory Technologies
63 Summary
64 Deleting Resources
65 Differences between Azure SQL Database and SQL Server
66 Unsupported Features

Resolve the captcha to access the links!