title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Professional Azure SQL Database
Duration
1 Day
Course
C11659
Available Formats
Self-Paced Training (Video)
Course Description
Overview
Become a data administration expert by learning the nuances of migrating, optimizing, and recovering data from the cloud with Azure SQL Database. Built with a narrative of a DBA, who is migrating from a traditional on-premises system to Azure SQL Database, this course helps you become a pro at managing your database on the cloud.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.
This is a fast-paced, practical hands-on course aimed at experienced developers. As you progress you’ll find helpful tips and tricks, and useful self-assessment material, exercises, and activities to help benchmark your progress and reinforce what you’ve learned. This is a self-paced video course. Any files needed for exercises or activities will be available for download from the course page.
Objectives
- 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
Audience
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. 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#.
Topics
Lesson 1: MICROSOFT AZURE SQL DATABASE PRIMER
- Azure SQL Database Architecture
- Azure SQL Database Service Tiers
- Determining an Appropriate Service Tier
- Determining Compatibility Issues
- Determining the Migration Method
- Automatic Backups
- Manual Backups
- Restore Types
- Access Control
- Proactive Security
- Scaling Out Azure SQL Database
- Vertical Scaling
- Horizontal Scaling
- Introducing Elastic Pools
- Elastic Jobs
- High Availability
- Disaster Recovery
- Monitoring an Azure SQL Database Using the Azure Portal
- Tuning an Azure SQL Database
Related Courses
-
Developing Solutions for Microsoft Azure
MOC-AZ-204T00- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,975.00 USD
-
Deploy cloud-native apps using Azure Container Apps
MOC-AZ-2003- Duration: 1
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
WEB BASED TRAINING (WBT) IS SELF-DIRECTED AND SELF-PACED. Before you enroll, review the system requirements to ensure that your system meets the minimum requirements for this course. AFTER YOU ARE ENROLLED IN THIS COURSE, YOU WILL NOT BE ABLE TO CANCEL YOUR ENROLLMENT. You are billed for the course when you submit the enrollment form. Web Based Training courses are non-refundable. Once you purchase a Web Based Training course, you will be charged the full price.
Web Based Training courses are sold on a per-user basis. WBT courses provide a training advantage for you and your teams, helping you get up to speed quickly. Take the courses you need, at your convenience and at your own pace.
Web Based Training courses are sold on a per-user basis. WBT courses provide a training advantage for you and your teams, helping you get up to speed quickly. Take the courses you need, at your convenience and at your own pace.
After you register for the course, an access instructions email will be sent within 1-2 business days. Within the enrollment period, this self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours per day.
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.