Azure SQL Database for the SQL Server DBA

Azure SQL Database is Microsoft's Database as a Service offering. This course will help you take advantage of your existing SQL Server skills and learn about managing, high availability, and performance of this cloud first solution.

Course info

Rating

(55)

Level

Intermediate

Updated

December 20, 2016

Duration

2h 47m

Description

Azure SQL Database is Microsoft's Database as a Service in the cloud. This course, Azure SQL Database for the SQL Server DBA, will show you some of the similarities to SQL Server but also why experienced DBAs will still need to learn some of the key differences. You will get to see the differences in management, high availability, performance, and monitoring of this cloud-first solution. You will also learn about the different service model and tiers that are specific to Azure SQL Database and how to migrate successfully to the platform. When you're finished with the course, you will understand how to leverage your existing SQL Server skills and apply them to a successful Azure SQL Database project.

About the author

Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions.
When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.

More from the author

Transcript

Hi everyone, my name is Warner Chaves and welcome to my course Azure SQL Database for the SQL Server DBA. I am a Principal Consultant at Pythian and a Microsoft Data Platform MVP.

Azure SQL Database is Microsoft's cloud-first database. Closely aligned with SQL Server but different in management, availability and performance characteristics. It's a perfect fit for SQL Server DBas to expand their cloud skills!

This course is tailored for the SQL Server DBA that wants to get up and running with this cloud service as quickly as possible. Some of the major topics that we will cover include: provisioning of server and databases, understand the service models and tiers, measuring performance, working with the database transaction units and monitoring the service. The course will provide examples both in the portal interface and with Azure Powershell so you can learn both approaches!

By the end this course, you’ll be able to confidently apply your SQL Server experience to building or migrating a database solution to the cloud into Azure SQL Database.

Before beginning the course you only need to be familiar with basic SQL Server administration.

I hope you’ll join me on this journey to learn Azure SQL Database with the Azure SQL Database for the SQL Server DBA course, at Pluralsight.