by Mark Long | Released August 2017 | ISBN: 9781491994962

Microsoft exam 70-765 (aka "Provisioning SQL Databases") is one of two tests you must pass to earn a Microsoft Certified Solutions Associate (MCSA): 2016 Database Administration certification. This course supplies you with the knowledge you need to pass the 70-765. It's also a practical introduction to Microsoft's Azure cloud platform service. It covers the processes, implications, technologies, and actions involved in utilizing SQL Server in the cloud in both PaaS and IaaS environments. After you learn how to create and use a free Microsoft Azure subscription, you will get hands-on experience with SQL Server in various cloud-based configurations, giving you an understanding of the implications and purposes for various options. Survey Microsoft's published objectives required to pass the Microsoft 70-765 exam Gain an operational understanding of Microsoft's Azure platform and administrative interface Learn the impacts and considerations to consider when migrating technologies to the cloud Discover the difference between SQL Database and SQL Server on an Azure VM Explore the dashboard and monitoring tools available on the Azure portal Understand the security options and implementations available with SQL Server in Azure Learn the efficiencies of utilizing SQL Server in the cloudMark Long is a long time contributor to O'Reilly Media having authored more than a dozen book and video titles including "Windows Presentation Foundation Basics", "Learning Windows PowerShell", and "Securing Windows Networks". He solves IT issues for numerous Fortune 500 companies as the head of his own consulting company. Mark holds the A+ certification and many others, including Microsoft's MCSE, MCDBA, and MCT. Show and hide more Publisher resources Download Example Code

1. Introduction
   • Welcome To The Course 00:04:41
   • About The Author 00:04:08
   • Course Overview 00:08:25
   • Microsoft SQL Server 00:05:58
   • SQL Server 2016 Certifications 00:09:23
   • Examples And Code 00:02:44
2. SQL Server Basics
   • SQL Server Platform 00:09:33
   • SQL Server Editions 00:05:56
   • Understanding Databases 00:09:41
   • Database Structures 00:08:44
   • Transact-SQL 00:07:03
3. Getting And Installing SQL Server 2016
   • Getting SQL Server 2016 00:05:56
   • Installing SQL Server 2016 Part - 1 00:08:20
   • Installing SQL Server 2016 Part - 2 00:04:42
   • Installing SQL Server Management Studio 00:05:35
   • Verifying The Installation 00:05:15
   • SQL Server Deployment Options 00:09:05
4. Cloud Computing Overview
   • What Is Cloud Computing? 00:09:20
   • Virtualization 00:09:47
   • Cloud-Based Applications 00:08:14
   • RMA 00:07:54
   • Why Utilize The Cloud? 00:07:21
   • Cloud Modes 00:07:45
   • Service Models 00:03:40
   • IaaS 00:06:43
   • PaaS 00:03:39
   • SaaS 00:05:13
   • Technologies In The Cloud 00:06:29
   • Impact Of The Cloud 00:10:19
5. Microsoft Azure
   • Understanding Azure 00:05:54
   • Azure Terminology 00:06:49
   • Azure Subscriptions 00:05:29
   • Azure Sign-Up 00:07:06
   • Azure Portal Tour 00:06:13
6. Azure SQL Database
   • Intro To SQL Database 00:04:23
   • Understanding DTUs 00:04:58
   • Logical Servers 00:05:25
   • Creating A SQL Database 00:08:24
   • SSMS And SQL Database 00:05:53
   • Understanding Elastic Pools 00:06:29
   • Creating An Elastic Pool 00:05:06
7. SQL Server Virtualization
   • Azure Virtual Machines 00:08:16
   • Azure Resource Groups 00:06:34
   • Creating A VM Part - 1 00:09:10
   • Creating A VM Part - 2 00:04:25
   • Accessing The VM 00:05:09
   • VM Storage Planning 00:05:03
   • Virtual Networking 00:06:59
   • On-Premises Vs. SQL Server VM 00:06:26
   • Provisioning A SQL Server VM 00:07:13
   • Manual SQL Server Install 00:05:13
   • Max Server Memory 00:10:20
   • Manually Configuring Memory 00:03:58
   • SQL Server Agent 00:06:43
   • Configuring Operators 00:04:37
   • Configuring Alerts 00:05:21
   • Azure Alerts 00:08:17
8. Azure Security
   • SQL Database Security 00:07:00
   • Access Control And Authorization 00:08:07
   • Transparent Data Encryption 00:05:35
   • Enabling TDE 00:03:32
   • Understanding DDM 00:07:15
   • Implementing DDM 00:08:00
   • Azure Always Encrypted 00:04:40
9. Migration And Performance
   • Migrating To The Cloud 00:10:42
   • Data Migration Assistant 00:09:46
   • Migrating To SQL Database 00:08:07
   • Migrating To SQL Server VM 00:05:45
   • Azure Performance Tuning 00:07:48
   • Using Azure Monitor Part - 1 00:10:14
   • Using Azure Monitor Part - 2 00:02:48
   • Azure Availability Sets 00:08:17
10. Conclusion
    • Wrap Up 00:06:42
Show and hide more