Sale!

Azure SQL Database Administration Class

$500.00 $350.00

Azure SQL Database is a cloud database as a service offering from Microsoft and differs from the conventional on premise SQL Server.

In this 2 day online class, you’ll learn to create, manage, shard, secure, optimize and maintain Azure SQL Database.

The class is power packed with Hands-On-Labs for you to explore the concepts as and when you learn.
Moreover, the class will be recorded and recording will be available in a week after the class.

The online class is conducted on Zoom by Ahmad Osama.

Description

Course Description

Azure SQL Database is a cloud database as a service offering from Microsoft and differs from the conventional on premise SQL Server.

In this 3 day online class, you’ll learn to create, manage, shard, secure, optimize and maintain Azure SQL Database.

The class is power packed with Hands-On-Labs for you to explore the concepts as and when you learn.
Moreover, the class will be recorded and recording will be available in a week after the class.

The online class is conducted on Zoom by Ahmad Osama. You’ll receive the meeting link 1 week prior to scheduled training date.

Duration

The course duration is 3 days.

Schedule

January 26-28, 2018

Modules

Day 1

Introduction to Azure SQL Database
Make yourself comfortable with the SQL Database. You’ll learn the Azure SQL Database Architecture, difference between Azure SQL Database and On Premise SQL Server. Provision an Azure SQL database, get familiar with configuration options and most importantly, Why Azure SQL Database?

Migrating to Azure SQL Database
You have decided to migrate to Azure SQL Database, here’s what you have to do, find and fix compatibility issues, determine an appropriate service tier, figure out a migration strategy and tool and migrate to cloud.

Securing Azure SQL Database
Security is one of the most important aspect and even more when you are on cloud. You’ll learn to add firewall rules, create and manage logins, configure data masking, row level security, auditing and always encrypted to secure your Azure SQL Database implementation.

Day 2

Scaling Azure SQL Database
You’ll learn to scale out Azure SQL Database using Elastic tools. Shard the data across multiple Azure SQL Database to optimize performance, query data across shards and merge and split shards as and when required.

Implement In-Memory OLTP in Azure SQL Database
If you are already working with SQL Server, you must be aware of how fast is the In-Memory OLTP. In this module, you’ll learn to implement In-Memory OLTP along with the caveats.

Monitoring and Tuning Azure SQL Database
Learn to monitor and tune Azure SQL Database Portal, DMVs & Extended Events, Index Advisor and Query Performance Insights.

Day 3

Azure SQL Database High Availability and Disaster Recovery
In this module, you’ll learn about the design patterns to design a highly available application using Azure SQL Database.

Automate and Manage SQL Database with PowerShell
Automation is an important aspect of any deployment. You’ll learn to automate SQL database deployment, administration and management using PowerShell.
Do check the free PowerShell Module – SQLAzureToolKit by Ahmad Osama on automating Azure SQL Database administration.

About the Instructor

Ahmad Osama is an Independent Consultant for Microsoft Data Platform Stack. He has provided consulting, training, content development & SQL support services to more than 120+ SQL Server customers globally.An expert in SQL Server & related technologies, he frequently speaks at user group events and conferences. Over the last 9 years, he has worked on countless SQL Server projects, consulted, trained & mentored more than 1000 IT professionals on SQL Server, delivered more than 50 workshops. Ahmad is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server for 2014-2016.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.