Introduction to Azure SQL Database

Learn Azure SQL Database,
Azure SQL Server on Virtual Machines
and more!

Hi, I'm Artemakis and I'd love to teach you Azure SQL Database in this course!

What is Azure SQL Database?

Microsoft Azure SQL Database is a fully managed cloud database service, provided as part of Microsoft Azure.

That means, that via the Microsoft Azure Portal, among other, you can easily create database servers, and thus host your databases. Moreover, you can still continue to use the same SQL tools you used for on-premises SQL Server instances (i.e. SQL Server Management Studio), with the only difference that you will be connecting on the SQL Server instance/database on the cloud.

Why Learn Azure SQL Database?

Cloud Computing is the future and Azure SQL Database is 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 can you do with Azure SQL Database?

With Azure SQL Database you can create scalable databases, hosted on Microsoft Azure Cloud Infrastructure. 

You can either use SQL Server via its Platform as a Service (PaaS) offering, or via its Infrastructure as a Service (IaaS) offering, that is Azure SQL Server VMs. 

Using SQL Server on Azure, gives you a large number of advantages. For example, you can dynamically assign the resources you need for your SQL Server instances and databases, you can easily set up and use high availability with data centers all over the world, you can easily secure your databases and the list goes on.

What's Included

  • Learn Azure Portal
  • Create Azure SQL Database Server
  • Configure Azure SQL Database Server
  • Manage Azure SQL Database Server
  • Set and Manage Firewall Rules
  • Access Azure SQL Database Using On-Premises Tools
  • Create Azure SQL Server Virtual Machine
  • Configure Virtual Machine
  • Configure SQL Server on Virtual Machine
  • Set and Manage Firewall Rules
  • Access Azure VM via RDP from On-Premises
  • Access Azure SQL Database on VM Using On-Premises Tools
  • Lifetime Access
  • Enroll with Discount
  • Certificate of Completion
  • Regular Course Updates

Learn to work with Azure SQL Database and Azure Virtual Machines by the end of this course.

Prerequisites

  • Basic knowledge of SQL Server and Databases.
  • Willingness and Excitement to learn something new!

30-Day Money-Back Guarantee

Try it risk-free

I’m confident you’ll get everything you need from this course and be 100% satisfied. But in the unlikely event you decide it’s not for you just ask for a refund any time during the first 30 days and you’ll get your money back with no questions asked.

introduction-azure-sql

Your Instructor

Hi there, my name is Artemakis Artemiou. I love talking about SQL Server, .NET, Programming, Data Access, Azure Cloud Computing, and related topics, and make it easy for all to understand, by using a simple and understandable language as well as simple, step by step guides.

This has been the motto for my entire career, over the past 15 years: “Keep things simple“.

I’m a Senior SQL Server & Software Architect with over than 15 years of experience on SQL Server administration, development, performance tuning and architecture, as well as on .NET development (C#).  Moreover, I’m a former Microsoft Data Platform MVP (2009-2018), professional author, certified SQL Server Engineer, and founder of SQLNetHub.com and TechHowTos.com

MVP Reconnect - Databases and Programming with Artemakis

Course Curriculum

  • Welcome to the Course
    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.
  • Meet Azure Portal
    In this lecture we will take a look at the Azure Portal and learn to navigate across the different resources.
  • Create the SQL Database and Server
    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

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

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

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

  • Accessing SQL Database from Azure Data Studio
    In this lecture, we will see how we can access our Azure SQL Database from Azure Data Studio.
  • Azure SQL Server Management Components
    In this lecture, we will talk about the Azure SQL Database Server dashboard and activity logs.

  • Azure SQL Server Dashboard, Activity Logs and Access Control
    In this lecture, we will talk about the Azure SQL Database Server dashboard and activity logs.

  • Azure SQL Server Settings
    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 Security
    In this lecture, we will talk about the security-related settings and features for Azure SQL Database Server.

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

  • Azure SQL Server Support & Troubleshooting
    In this lecture, we will talk about the support and troubleshooting options for Azure SQL Server instances.
  • Let’s Create an Azure SQL Server Virtual Machine
    In this lecture, we will create a test Azure SQL Database Server on a virtual machine.
  • Set the Firewall Rules for Virtual Machine
    In this lecture, we will set the proper firewall rules for accessing our SQL Server VM.
  • Accessing the Virtual Machine via RDP
    In this lecture, we will access our SQL Server virtual machine on Azure via RDP.

  • Accessing the Virtual Machine SQL Instance via SQL Server Management Studio
    In this lecture, we will access SQL Server on our VM on Azure using SQL Server Management Studio (SSMS).

  • Accessing the Virtual Machine SQL Instance via Azure Data Studio
    In this lecture, we will access SQL Server on our VM on Azure using Azure Data Studio.
  • What we’ve Learned in this Course
    This lecture, is a recap on what we’ve learned in this course.

 

  • Bonus Lecture
    Bonus lecture, with next steps on learning more about Azure SQL Database and SQL Server.

Frequently Asked Questions

  • When does the course start and finish?
    • This is a completely self-paced online course – you decide when you start and when you finish.

  • How long do I have access to the course?
    • By the time you enroll in the course, you have unlimited access to this course for as long as you like – across any and all devices you own.

  • What if I’m not satisfied with the course?
    • If you are unhappy with the course, you can request a refund in the first 30 days.

  • Do I get a certificate in the end of the course?
    • Yes. Right after you complete the course and pass the quizzes and practice test, Udemy will issue a certificate for successful completion of the course.

Enroll Now with Discount!

Enroll now to the course and save 90%!

This is a special time-limited offer!

The course is offered on the Udemy platform.

Discount Coupon Code: AR19LEARN

Check my Other Courses

Feel free to check my other courses on the “Courses” section on my website.