Learn How To Become an Azure SQL Database Architect

A Pragmatic Introduction To Azure SQL Database
4.1 (41 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.
380 students enrolled
Instructed by Mike West IT & Software / Other
$19
$20
5% off
Take This Course
  • Lectures 30
  • Length 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course 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!!!

What are the 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.

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
01:18

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.

01:24

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.

06:00

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.

01:07

In this lecture we will define what cloud computing is.

02:05

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.

Article

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

Let's go over them.

Article

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

Quiz
5 questions
Section 2: The Portal Basics
06:34

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

We will cover the basics of navigating SQL Database.

03:56

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

05:02

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.

02:11

Let's restore a database we created earlier.

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

01:48

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.

03:37

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.

05:23

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.
03:09

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.

02:59

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.

01:53

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.

02:35

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.

02:40

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.

04:35

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

01:39

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.

Article

Let's cover the new vernacular from this section.

Article

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

Quiz
10 questions
Section 3: Migrating Databases to Azure: An End to End Example
08:35

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.

06:40

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

01:51

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

05:59

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

03:37

Import from BACPAC to SQL Database using SSMS

Article

Let's wrap up what we've covered.

Quiz
10 questions
Section 4: Conclusion
Article

Final thoughts and a thank you.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mike West, SQL Server 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.

Ready to start learning?
Take This Course