Learn How To Become an Azure SQL Database Architect
4.1 (81 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
648 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn How To Become an Azure SQL Database Architect to your Wishlist.

Add to Wishlist

Learn How To Become an Azure SQL Database Architect

A Pragmatic Introduction To Azure SQL Database
Bestselling
4.1 (81 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
648 students enrolled
Created by Mike West
Last updated 1/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
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
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
30 Lectures
01:31:25
+
Introduction
7 Lectures 12:58

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:35

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

Summary
00:29

Quiz
5 questions
+
The Portal Basics
16 Lectures 50:22

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:05

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:34

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:52

Quiz
10 questions
+
Conclusion
1 Lecture 00:30

Final thoughts and a thank you.

Final Thoughts and Thank You
00:30
About the Instructor
Mike West
4.2 Average rating
2,587 Reviews
42,749 Students
40 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.

Certifications

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Personal

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.