Databases in Azure – Microsoft Professional Program

With this Databases in Azure course you can learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure’s data services, from a single database instance to a massive scale data warehouse for working with Big Data.

Microsoft Professional Program - Databases in Azure

About This Course

This course focuses primarily on Azure SQL Database as a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software.

You’ll be introduced to data services that Azure provides to store, manage, and analyze data. As an alternative to the cost and complexity of managing on-site SQL Server installations, you’ll learn how to quickly set up and start using database applications in Azure. You’ll gain an understanding of how to configure firewall rules, manage log-ins and users, as well as roles and permissions, perform a database restore, and generally secure an Azure SQL database.

Ongoing monitoring of your database applications is essential so you’ll be introduced to tools and techniques that will help you determine usage requirements, plan upgrades, and troubleshoot performance and security issues.

Finally, you’ll be introduced to Azure SQL Data Warehouse, a fully managed and scalable cloud service, that is compatible with other Azure offerings, such as Machine Learning and Data Factory, as well as existing SQL Server tools. As a distributed database management system that can handle large amounts of data in which analytics play a significant role, Azure SQL Data Warehouse provides an ideal solution for organizations that work with Big Data and need to scale up and down quickly.

The production of this course would not have been possible without the generous contribution of Microsoft

Prerequisites

  • General understanding of cloud computing models.
  • Familiarity with database concepts: relational databases, tables, queries, and schemas.
  • Proficiency in PowerShell and command line scripting.

What you’ll learn

  • How to plan for, deploy, and provision Azure SQL Database.
  • How to implement, secure, and manage Azure SQL Database.
  • How to use metrics, alerts, auditing, and dynamic management views to monitor Azure SQL Database.
  • How to use Azure SQL Data Warehouse for Big Data solutions.

Meet the instructors

Cynthia Staley

Cynthia Staley

 

Senior Content Developer
Microsoft

Cindy is a Senior Content Developer for Microsoft specializing in Windows Server IT professional online training.

Tony Jamieson

Tony Jamieson

 

Content Developer
Microsoft

Tony is a Content Developer for Microsoft with over 15 years specializing in IT professional online training.

Corey Hynes

Corey Hynes

 

Infrastructure Consultant

 

Corey J Hynes is an infrastructure consultant who has been working in IT for 17 years. Corey specializes in core infrastructure and virtualization technologies including Windows Server, Hyper-V, VDI, and System Center.

Start learning about Databases in Azure

You can enroll now for the Databases in Azure course at our DataChangers Academy! Do you want to learn more? Then check out the other Cloud Administration courses.

Please use a Windows Live ID email address to register at the DataChangers Academy if you want to obtain a certificate after finishing the courses.

Show what you know and get a certificate

After finishing this course, you can obtain a Microsoft Professional Program certificate. In order to obtain a certificate, you can buy a voucher from us (in collaboration with MD2C).

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.