Video description
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 cloud
Mark 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.
Table of contents
- Introduction
- SQL Server Basics
- Getting And Installing SQL Server 2016
- Cloud Computing Overview
- Microsoft Azure
- Azure SQL Database
-
SQL Server Virtualization
- Azure Virtual Machines
- Azure Resource Groups
- Creating A VM Part - 1
- Creating A VM Part - 2
- Accessing The VM
- VM Storage Planning
- Virtual Networking
- On-Premises Vs. SQL Server VM
- Provisioning A SQL Server VM
- Manual SQL Server Install
- Max Server Memory
- Manually Configuring Memory
- SQL Server Agent
- Configuring Operators
- Configuring Alerts
- Azure Alerts
- Azure Security
- Migration And Performance
- Conclusion
Product information
- Title: Provisioning SQL Databases- Exam 70-765 Certification Training
- Author(s):
- Release date: August 2017
- Publisher(s): Infinite Skills
- ISBN: 9781491994962
You might also like
video
Developing SQL Databases - Exam 70-762 Certification
Microsoft exam 70-762 is one of two exams you must pass to earn a Microsoft Certified …
book
Exam Ref 70-765 Provisioning SQL Databases, First Edition
Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both …
video
Microsoft SQL Server 2012 Certification Training - Exam 70-462
In this SQL Server 70-462 exam training course, expert author Denny Cherry teaches you everything you …
book
Exam Ref 70-764 Administering a SQL Database Infrastructure
Prepare for Microsoft Exam 70-764—and help demonstrate your real-world mastery of skills for database administration. This …