Databases in Azure

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.
  • Self-Paced Learning

    Learning Style
  • Intermediate

    Difficulty
  • 16 Hours

    Course Duration
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
$0.00
$0.00
/ Each
When you subscribe, you get:
Learn Subscription Plan gives you access to this course, PLUS:

  • 620+ high impact technical, end user and leadership courses
  • Peer to peer learning and access to expert mentors
  • Learner and Manager Analytics
  • Access to Cognitive Learning Research platform to troubleshoot project issues
7-Day FREE Trial
On Sale!
Now Only $14.99 Regular Price $24.99
Now Only $14.99 Regular Price $24.99
/ Month
Team
Pricing
  • Buy 5-9 Enrollments And Save 15% ($12.74 monthly.)
  • Buy 10-19 Enrollments And Save 25% ($11.24 monthly.)
  • Buy 20-above Enrollments And Save 40% ($8.99 monthly.)
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.

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. This course also prepares the students for the Microsoft 70-464: Developing Microsoft SQL Server Databases certification exam.

The average salary for a Database Administrator (DBA) is $71,429 per year. 

Course Objective:

After completing this course, students will have a working understanding of:

  • 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.

Audience:

This course is intended for

  • Cloud Administrator

Prerequisites:

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

Suggested prerequisites courses:

More Information
Brand Microsoft
Lab Access No
Technology Microsoft
Learning Style Self-Paced Learning
Difficulty Intermediate
Course Duration 16 Hours
Language English
VPA Eligible VPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's