Over

155,000

Africa & Middle East

7Days 10.00 A.M - 10.00 P.M

Call us

Enquire Now



Azure SQL Database Administration


by pallvi
Free
0 Lessons
0 Students

Azure SQL Database is a highly scalable, high performing SQL Server-based Managed Cloud Database Service offering from Microsoft.

Accelebrate’s Azure SQL Database Administration training teaches attendees everything they need to administer SQL Database to get the most out of features that it provides. Students learn the different management aspects of an Azure SQL Database such as Migration, Backup and Restore, Pricing, Security, Scalability, Monitoring and Performance Optimization, High Availability, and Disaster Recovery.

Prerequisites:

No previous experience is presumed, however, having prior experience working with On-Premise SQL Server, PowerShell, and C# would be beneficial.

Azure SQL Training Objectives

All students will:

  • Understand Azure SQL Database Configuration and Pricing options
  • Provision a new SQL Database or Migrate an existing On-Premise SQL Server database to Azure SQL Database
  • Backup and Restore Azure SQL Database
  • Secure an Azure SQL Database
  • Scale an Azure SQL Database
  • Monitor and Tune an Azure SQL Database
  • Implement High Availability and Disaster Recovery with Azure SQL Database
  • Automate common management task with PowerShell
  • Develop a scalable cloud solution with Azure SQL Databas


Introduction

Azure SQL Database Primer

  • Introduction to Azure SQL Database
  • Difference between SQL Server and Azure SQL Database
  • Unsupported Features
  • Provision an Azure SQL Database
  • Azure SQL Database Configuration Options
  • Understanding Azure SQL Database Pricing
  • Provisioning & connection to Azure SQL Database using PowerShell

Migrating An On-Premise SQL Server Database To Azure SQL Database

  • Deciding an appropriate service tier
  • Determining compatibility issues
  • Determining migration method
  • Verifying the database migration
  • Using Database Migration Assistant to find the compatibility issues
  • Migrate database using SQL Data-Tier Application
  • Migrate database using SQL Server Management Studio
  • Migrate database using Transactional Replication

Backup An Azure SQL Database

  • Automated Backups
  • Export Azure SQL Database to Azure Storage
  • Transactional consistent backup
  • Exporting BACPAC to Azure Storage using PowerShell
  • Perform a transactional consistent backup using PowerShell

Restore An Azure SQL Database

  • Point-In-Time Restore from automated backup
  • Geo-Restore Azure SQL Database
  • Deleted-Database Restore
  • Import Azure SQL Database from a BACPAC file
  • Point-In-Time Restore of Azure SQL Database
  • Geo-Restore of Azure SQL Database
  • Geo-Restore of Azure SQL Database

SQL Database

  • Auditing and Thread detection
  • Encryption, Dynamic Data Masking and Row Level Security
  • Configuring Firewall
  • SQL Authentication & Azure AD Integration and Authentication
  • Implementing Auditing
  • Implement Dynamic Data Masking & Row Level Security
  • Configuring Firewall using PowerShell
  • Managing Users and Logins for SQL Authentication
  • Implementing Azure AD authentication

Scaling Azure SQL Database

  • What is a SQL Elastic Pool?
  • When to consider Elastic Pools
  • Choosing the correct pool size
  • Understanding Elastic Jobs
  • Vertical Scaling
  • Horizontal Scaling or Sharding
  • Multi-tenant design patterns with Azure SQL Database
  • Introduction to Elastic database tools
  • Adding & Modifying Shard Maps & Shards
  • Data Dependent Routing
  • Multi-Shard Queries
  • Elastic Queries
  • Elastic Transactions
  • Split & Merge Tool
  • Manage and Monitor elastic pools using Azure Portal
  • Add & Remove shards from an Elastic database
  • Executing a query against a shard
  • Running a distributed transaction

High Availability and Disaster Recovery

  • Built-In high availability in Azure SQL Database
  • Scenarios for building highly available services with Azure SQL Database
  • Standard & Active Geo-Replication
  • Automatic Failover
  • Implement and test a DR Solution

Monitoring And Tuning Azure SQL Database

  • Monitoring database using the Azure Portal
  • Monitoring database using DMVs
  • Extended Events
  • Diagnostic Logging
  • Analyzing and implementing performance recommendations
  • Tuning database using Query Performance Insight
  • Automatic tuning
  • In-Memory OLTP Overview and Concepts – Memory-Optimized Tables & Natively Compiled Stored Procedures
  • Performance Improvement with In-Memory OLTP
  • Using Extended Events to Monitor Azure SQL Database
  • Implementing Performance Recommendations
  • Tuning database using Query Performance Insight
  • Migrating Disk-Based tables to Memory Optimized Table
  • Migrating Interpreted Stored Procedures to Natively Compiled Stored Procedures

Automating Common Administration Tasks With PowerShell

  • Automation using PowerShell
  • Automation using Linked Server
  • Automation using Azure Automation
  • Automation using Elastic Jobs

Lessons

APPLY TO COURSE

Sum the simple Operation :
15 + 7 =