Introduction to Azure SQL Database (PaaS and IaaS)
4.3 (61 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.
253 students enrolled

Introduction to Azure SQL Database (PaaS and IaaS)

Get started with Azure SQL Database and SQL Server on Azure Virtual Machines fast and easy! Many live demos included!
4.3 (61 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.
253 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $55.99 Original price: $79.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 article
  • 7 downloadable resources
  • 1 Practice Test
  • 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
  • What is Azure Portal and how to use it
  • How to create and configure your first database on Azure SQL Database
  • How to configure and manage firewall rules
  • How to access your Azure SQL Database from on-premises client tools such as SSMS and Azure Data Studio
  • How to manage your Azure SQL Database Server
  • How to create and configure an Azure SQL Server Virtual Machine
  • How to access your Azure SQL Server Virtual Machine using RDP, SSMS and Azure Data Studio
Course content
Expand all 22 lectures 02:01:48
+ Introduction
1 lecture 02:29

This is the introduction to the course. We will talk about how this course is structured and what will you learn after completing this course.

Preview 02:29
+ Introducing the Azure Portal
1 lecture 04:26

In this lecture, we will take a look at the Azure Portal and learn to navigate across the different resources.

Preview 04:26

Short section quiz.

Meet Azure Portal
2 questions
+ Creating your First Azure SQL Database
2 lectures 13:27

In this lecture, we will talk about and show how we can initiate the process of creating a new SQL Database on Azure, along with creating a new SQL Server instance.

Create the SQL Database and Server
09:49

In this lecture, we will see how we can set the proper firewall settings in order to be able to access our SQL Database on Azure.

Preview 03:38

Short section quiz.

Creating your First Azure SQL Database
2 questions
+ Accessing Azure SQL Database
3 lectures 16:49

In this lecture, we will see how we can access our Azure SQL Database from within Azure Portal.

Accessing SQL Database from within Azure Portal
04:26

In this lecture, we will see how we can access our Azure SQL Database from SQL Server Management Studio (SSMS).

Accessing SQL Database from SQL Server Management Studio
07:19

In this lecture, we will see how we can access our Azure SQL Database from Azure Data Studio.

Accessing SQL Database from Azure Data Studio
05:04

Short section quiz.

Accessing Azure SQL Database
2 questions
+ Managing your Azure SQL Database Server
6 lectures 30:18

This is an overview of the major Azure SQL Server management components. Then, for each component, dedicated lectures follow.

Preview 01:40

In this lecture, we will talk about the Azure SQL Database Server dashboard and activity logs.

Preview 06:26

In this lecture, we will talk about the available settings for Azure SQL Database Server such as: failover groups, properties, backups, etc.

Azure SQL Server Settings
09:52

In this lecture, we will talk about the security-related settings and features for Azure SQL Database Server.

Azure SQL Server Security
08:35

In this lecture, we will talk about the intelligent performance features for Azure SQL Database Server.

Azure SQL Server Performance
03:07

In this lecture, we will talk about the support and troubleshooting options for Azure SQL Server instances.

Azure SQL Server Support & Troubleshooting
00:38

Short section quiz.

Managing your Azure SQL Database Server
2 questions
+ Creating an Azure SQL Server Virtual Machine
1 lecture 14:20

In this lecture we will create a test Azure SQL Database Server on a virtual machine (VM).

Let’s Create an Azure SQL Server Virtual Machine
14:20

Short section quiz.

Creating an Azure SQL Server Virtual Machine
2 questions
+ Accessing your SQL Server Instance on Azure Virtual Machine
4 lectures 19:07

In this lecture, we will set the proper firewall rules for accessing our SQL Server virtual machine.

Set the Firewall Rules
06:56

In this lecture, we will access our SQL Server virtual machine on Azure via RDP.

Accessing the Virtual Machine via RDP
03:39

In this lecture, we will access SQL Server on our Azure virtual machine using SQL Server Management Studio (SSMS).

Accessing the Virtual Machine SQL Instance via SQL Server Management Studio
05:43

In this lecture, we will access SQL Server on our virtual machine on Azure using Azure Data Studio.

Accessing the Virtual Machine SQL Instance via Azure Data Studio
02:49

Short section quiz.

Accessing your SQL Server Instance on Azure Virtual Machine
2 questions
+ Special Topics (New)
2 lectures 16:05

This special topic, is a short tip on how you can have SQL Server Agent functionality in Azure SQL Database.

Tips on SQL Server Agent Functionality in Azure SQL Database
00:30

In this special topic, we will talk about Stretch Database in SQL Server and via a comprehensive live demonstration, we will see how it is possible via the Stretch Database technology, to store a database table on Azure SQL Database, while being able to access it from your on-premises SQL Server database.

How to Enable Stretch Database in SQL Server
15:35
+ Wrap-Up
1 lecture 01:21

This lecture, is a recap on what we've learned in this course.

What we’ve Learned in this Course
01:21

Test what you've learned in my online course "Introduction to Azure SQL Database"!


Good luck!


-Artemakis

Practice Test of Introduction to Azure SQL Database
15 questions
+ Learning More
1 lecture 03:26

Bonus lecture.

Bonus Lecture
03:26
Requirements
  • Basic knowledge of SQL Server and Databases
  • Willingness and excitement to learn something new!
Description

Cloud Computing is the future and Azure SQL Database is a major part of it. That's why possessing this skill, is essential in the modern computing Era that we live in.

This course does exactly that: it helps you get started with Azure SQL Database (PaaS) and Azure SQL Server VMs (IaaS) in no time!

With my course, among other, you will learn how to create and manage Azure SQL Databases and VMs, and access them from your on-premises tools, such as SQL Server Management Studio and Azure Data Studio.


WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

  • "It was very straight forward and easy to understand."

  • "The updated course is great! The live demos explain things in simple words,in a step by step manner, making it easier for me to learn Azure SQL."

  • "I really enjoyed the course. The instructor clearly explains all the concepts and the live demonstrations are very useful."

  • "A quick and very good start with Azure SQL Server and Database."

  • "This is a good course i found. Whoever wants to professionally learn and apply on job all the skills here, can easily do that after this course. SQL to Azure migration is ongoing market skill and major requirement. This course shows all steps how to make it possible"


WHAT IS THIS COURSE ALL ABOUT?

Cloud Computing is the future and databases are the backbone of just about everything in Computing, because data is everywhere. Imagine knowing how to fully manage data in a powerful Cloud Computing platform such as Microsoft Azure. Such knowledge is a must, not only for your personal development as an IT Engineer, Database Administrator or Developer, but also for staying up to date with the latest trends and technologies when it comes to database systems.

This course has been carefully designed, in order to help you getting started with Azure SQL Database fast and easy. Via a well-structured curriculum, it starts with the very basics of Azure SQL Database, and then it moves to a more intermediate-level of knowledge on how you can manage your Azure SQL Database Servers both as a platform (PaaS) and Virtual Machines (IaaS).

So join me into a 2-hour journey and learn all about Azure SQL Database!


AFTER THE COURSE:

  • You will be able to navigate in Azure Portal and create, manage and use resources and services.

  • You will be able to create and configure your first Azure SQL Database Server and database (platform as a service – PaaS).

  • You will be able to configure and manage firewall settings.

  • You will be able to access your Azure SQL Database using your on-premises tools such as SQL Server Management Studio (SSMS) and Azure Data Studio.

  • You will be able to manage your Azure SQL Database Server.

  • You will be able to create and configure Azure SQL Server Virtual Machines (infrastructure as a service - IaaS)

  • You will be able to connect to your Azure SQL Server virtual machine via:

    • RDP (Windows access)

    • SQL Server Management Studio (SQL access)

    • Azure Data Studio (SQL access)


PREREQUISITES:

  • Basic knowledge of SQL Server and Databases

  • Willingness and Excitement to learn something new!


THIS COURSE CONTAINS/OFFERS:

  • 2 hours of high-quality video lectures and guides

  • Step by step live demonstrations and guides that can help you get started with Azure SQL Database

  • Downloadable resources with useful information and links

  • Useful quizzes for testing your knowledge on each section

  • A major practice test in the end of the course

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion


Also: This course is being updated with new educational material on a regular basis.

Who this course is for:
  • IT Professionals
  • Database Administrators
  • Database Developers
  • SQL Server Engineers