Last updated 11/2018MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 2.73 GB | Duration: 4h 58m
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 eeer 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 D 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 Pr 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 Deteing an Appropriate Service Tier Lecture 16 Deteing Compatibility Issues Lecture 17 Deteing 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. HomePage:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.