Learn How To Become an Azure SQL Database Architect
4.3 (232 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,406 students enrolled

Learn How To Become an Azure SQL Database Architect

A Pragmatic Introduction To Azure SQL Database
4.3 (232 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,406 students enrolled
Created by Mike West
Last updated 1/2016
English
English [Auto]
Current price: $12.99 Original price: $19.99 Discount: 35% off
13 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 min on-demand audio
  • 6 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • This Course was Designed for SQL Server DBAs moving their Databases to Azure.
  • You will be Architecting SQL Server Instances using Windows Azure.
  • You'll be learning Azure SQL Database nomenclature and gaining real world insight into how Azure works.
Requirements
  • You'll need a FREE tier account on Windows Azure but don't create one now. We cover this in great detail before we start the course.
  • Fast access to the internet will be very important. The cloud is a metaphor for internet based computing.
Description

Some Course Reviews from Similar Courses:

"I've also looked at the database with multiple system monitoring products. But really where do I go from here? and when I find the problem what do I really need to do? Mike really shows you the nitty gritty."

"This was just the course I have been waiting for. Mike's demos and scripts have helped me become a confident tuner. The best thing about this course was that I was able to improve our server performance straightaway."

"I already have a great deal of DBA related experienced in the real world. What this course did for me was help me establish a model, and strategy for database tuning and performance monitoring."

Thank you reviewers for your kind feedback.

IMPORTANT: In Microsoft nomenclature there are two portals: Classic Portal and Azure Portal. The Classic one is being phased out. This Course is entirely based on Azure Portal, which is the newest version.

Additionally, this course is NOT for any of the current Microsoft Certifications.

In this course we are going to cover Azure SQL Database. Azure SQL Database is Microsoft’s cloud database service.

Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. Data is hosted, managed and provisioned in Microsoft data centers.

This course takes a hands on, real world approach to working with Azure SQL Databases. While there is some theory most the course will be focused on working with the latest version of Windows Azure.

This course will give YOU the foundation to become more comfortable working inside Windows Azure.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Windows Azure’s various cloud offerings.

As a matter of fact, 30% of Fortune 500 companies use Azure at some level.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Azure SQL Database. Windows Azure patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Enroll Now. Let’s Get Started!!!

Who this course is for:
  • You will need to have a solid understanding of SQL Server fundamentals
  • This is not a course for beginners.
  • This course was created for SQL Server DBAs preparing to move SQL Server Databases to Azure SQL Database.
Course content
Expand all 30 lectures 01:31:24
+ Introduction
7 lectures 13:01

In this lecture let's introduce the course.

This course is very specific.

We are going to cover Microsoft's cloud platform SQL Server database called Azure SQL Database.

Preview 01:18

Is this course right for you?

I want to make sure you know exactly what's in this course.

Let's learn what we are going to cover in this brief lecture.

Preview 01:24

Before we can migrate our on premise databases to the cloud we will need to create an on premise environment.

You may already have a recent version of SQL Server installed. (SQL Server 2012 on up will do)

If you have an instance already feel free to move to the next lecture.

Preview 06:00

In this lecture we will define what cloud computing is.

Preview 01:07

Before we get our hands dirty we are going to need a Microsoft account.

Let's learn how to create one in this lecture.

You'll need to have an account before you can move forward.

Preview 02:05

There aren't that many new terms in this lesson.

Let's go over them.

Terminology
00:34

In this lecture let's wrap up what we've learned.

Summary
00:33
Quiz
5 questions
+ The Portal Basics
16 lectures 50:19

Let's take a high level look at the layout of the portal.

We will cover the basics of navigating SQL Database.

Portal Layout
06:34

Let's create a database in this lecture using the portal.

Create Database and Server
03:56

Most DBAs will be using SSMS to manage their cloud instances.

Let's walk through the 2 key steps you'll need to take before you can connect to your azure database.

Connect to Our Azure Database Via SSMS
05:02

Let's restore a database we created earlier.

The steps are quite different compared to our on premise database.

Restore A SQL Database on the Portal
02:11

Microsoft has come up with a novel way to measure database usage.

They call it a DTU. Let's examine what that is in this lecture.

What's A DTU?
01:48

There are two approaches to DR and HA using Azure SQL Database.

They are Geo-Restore and Geo-Replication.

Let's talk about them in this lecture.

What is Geo-Replication?
03:37

In this lecture we will do three things.

  1. Set up Geo-Replication between the West and East Region.
  2. Fail the West Region over to the East Region.
  3. Remove it.
Setting Up Standard Geo-Replication
05:23

Threat Detection is a great approach Microsoft is using to primarily stop SQL Injections.

Let's discuss it and set it up in this lecture.

Azure SQL Database Threat Detection
03:09

TDE for Azure SQL Databases.

It's been there for awhile with on-premise databases now they have it in the cloud.

Let's cover that in this lecture.

Transparent Data Encryption with Azure SQL Database
02:59

In this lecture let's learn what Elastic Database Pools are.

The will really help us control groups of databases with varying degrees of usage.

Elastic Database Pools Defined
01:53

In this lecture lets set up an elastic database pool.


This is a very simple setup and I'm sure it will be widely used for real world applications.

Setting Up An Elastic Database Pool
02:35

In this lecture let's define and then set up data masking.

This is a great technique for hiding credit card numbers and social security numbers.

Setting Up Dynamic Data Masking
02:40

Let's set up a simple CPU alert and create some monitoring dashboards.

Setting Up a CPU Alert Inside Our Dashboard
04:35

Just like with our on-premise database we will want to restrict access for specific users.


Let's learn how to do that in this brief video.

Creating Logins and Users
01:39

Let's cover the new vernacular from this section.

Terminology
01:03

Let's wrap up what we've covered in this section.

Summary
01:15
Quiz
10 questions
+ Migrating Databases to Azure: An End to End Example
6 lectures 27:33

In this lecture we will create a new environment for our databases.

We will spin up a bare bones instance so we can begin migrating our databases to Azure.

The Building Blocks: Creating the Resource Group, Server and Database
08:35

Let's walk through the most simple way we can move our schema and data to Azure.

Exporting Database Using SSMS
06:40

In this lecture let's create a copy of a database using SSMS on our cloud instance.

Create Copy of Existing Azure SQL Database
01:51

Let's move data from our on premise environment to Azure SQL Database using SSIS.

Load Our Azure Database With SSIS
05:59

Import from BACPAC to SQL Database using SSMS

Import Schema and Data from a BACPAC file
03:37

Let's wrap up what we've covered.

Summary
00:51
Quiz
10 questions
+ Conclusion
1 lecture 00:30

Final thoughts and a thank you.

Final Thoughts and Thank You
00:30