The Complete Azure SQL Database Bootcamp:Beginner To Expert
4.3 (15 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,714 students enrolled

The Complete Azure SQL Database Bootcamp:Beginner To Expert

How to use Azure SQL Database and SQL Server within an Azure Virtual Machine (VM). Live practical demos on all subjects.
4.3 (15 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,714 students enrolled
Created by Gary Cowan
Last updated 7/2020
English
English [Auto]
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 3 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • 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
  • You will learn how to use Azure SQL database
  • Learning Azure SQL database, you will be able to connect to SQL Server to pull back data.
  • Learn the benefits of Azure SQL database
  • Administrating and restoring and Azure SQL databases
Course content
Expand all 27 lectures 01:52:41
+ Introduction
4 lectures 06:38

This is the introduction on what you will learn with Azure SQL Databases

Preview 02:31

This is what you will need to do the Azure SQL Databases course

What will you will need?
00:12
Leave a review and win FREE access to courses
00:44

This is a guide on your training path within SQL Server

Preview 03:11
+ Setup SQL Server - On Premise
4 lectures 15:31
Read Me - Before you begin this section
00:19

This lecture will show you how to install SQL Server

Installing SQL Server Database Engine
09:02

You will learn how to install SQL Server Management Studio

Install Management Studio
05:01

This lecture shows you how to create test data from the Azure SQL Database course

Setup and creating test data
01:09
+ Setting up billing alerts on Azure
1 lecture 04:41

This lecture shows you how to set up billing alerts on Azure

Setting up billing alerts
04:41
+ Creating a Azure SQL Database
1 lecture 08:43

You will learn how to create an Azure SQL Database on the Azure Portal

Creating a Azure SQL Database using the Azure Portal
08:43
For this assignment, create an Azure SQL Database using the SQL Server Developer Edition
Assignment : Creating a SQL Database
1 question
+ Delete Resource Groups, save money!!!!
1 lecture 01:18

This will show how to save money on Azure.

Delete Resource Groups, save money!!!!
01:18
+ Creating a Virtual Machine (VM) SQL Server Database on Azure
1 lecture 08:18

You will learn how to create a SQL Server instance on Azure within a virtual machine.

Creating a Virtual Machine (VM) SQL Server Database on Azure
08:18
+ Common DBA Tasks to do on Azure
2 lectures 11:05

You will be shown Geo-Replication within Azure SQL Database

Preview 08:26

Will show you how to tune an Azure SQL Database.

Performance monitoring a Azure SQL Database
02:39
+ Restore a native SQL Server Azure Database
1 lecture 01:57

This lecture will show you how to restore an Azure SQL Database

Restoring a Azure SQL Database
01:57
+ Migrating SQL Server - On Premise to Azure SQL Database
5 lectures 27:55

How to check if your SQL Server is ready to be migrated to Azure

Checking your database before migration to Azure
05:17

This lecture will show you how to migrate a SQL Server over to Azure using SQL Server Management Studio

Migrating a SQL Server database to Azure SQL Database using SSMS
08:19

You will learn how to migrate a database to Azure using the Data Migration Assistant software.

Migrating a local Database to Azure SQL Database using Data Migration Assistant
06:08
Migrating to a SQL Server Virtual Machine - Part 1
00:28

This lecture will show you how to migrate a SQL Server database to an Azure SQL Server on a virtual machine

Migrating to a SQL Server Virtual Machine - Part 2
07:43
+ Extra Topics
5 lectures 24:52

This video shows you how to create a SQL table within an Azure SQL Database using SQL Server Management Studio (SSMS)

Creating Azure SQL tables using SQL Server Management Studio (SSMS)
03:36

This will show how to use tags within Azure

Tags - what are they and how do you use them?
03:14

You will learn how to use Elastic Pool in an Azure SQL Database

Elastic Pool
03:32

Dynamic Data Masking within an Azure SQL Database is taught in this lesson.

Dynamic Data Masking
06:00

How to stretch a local database and table to Azure SQL Database

Stretching a local database and table to Azure SQL Database
08:30
Requirements
  • You Will Need An Azure Account.
  • Some experience of SQL Server
  • A Basic Understanding Of Azure.
  • Windows 10 (or better) Operating System
Description

If you are looking to find out vital information with Azure SQL Database then this is the course for you.

You will learn

  • How to create and delete Azure SQL Database instances

  • How to create SQL Server within an Azure Virtual Machine (VM).

  • How to administrate an Azure SQL Database instance

  • How to restore an Azure SQL Database

  • How to migrate databases from on-premise to an Azure SQL Database

  • How to migrate databases from on-premise to SQL Server within an Azure Virtual Machine (VM).

  • How to administrate an Azure SQL Database

After this course, you will be able to administrate Azure SQL Databases and use SQL Server within an Azure Virtual Machine (VM).

Who this course is for:
  • Students who want to learn Azure SQL Databases.