1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Design and Implement a Storage Strategy for Azure 70-532 Certification

What Is Azure SQL Database

Contents

keyboard_tab
Implement Azure Storage Blobs and Azure Files
Implement Storage Tables
10
Tables8m 50s
Implement Azure Storage Queues
Manage Access
Monitor Storage
Implement SQL Databases
14
Conclusion
play-arrow
Start course
Overview
DifficultyIntermediate
Duration1h 18m
Students145

Description

Course Description

This course teaches you how to work with Azure Storage and its associated services.

Course Objectives

By the end of this course, you'll have gained a firm understanding of the key components that comprise the Azure Storage platform. Ideally, you will achieve the following learning objectives:

  • How to comprehend the various components of Azure storage services.
  • How to implement and configure Azure storage services. 
  • How to manage access and monitor your implementation. 

Intended Audience

This course is intended for individuals who wish to pursue the Azure 70-532 certification.

Prerequisites

You should have work experience with Azure and general cloud computing knowledge.

This Course Includes

  • 1 hour and 17 minutes of high-definition video.
  • Expert-led instruction and exploration of important concepts surrounding Azure storage services.

What You Will Learn

  • An introduction to Azure storage services.
  • How to implement Azure storage blobs and Azure files.
  • How to implement storage tables.
  • How to implement storage queues.
  • How to manage access and monitor storage.
  • How to implement SQL databases.  

Transcript

Hello and welcome back. In this session we are going to discuss Azure SQL Database. This section will introduce the Azure SQL Database offering. We'll cover performance options through the choice of service tiers and scaling features delivered through elastic pools.

The SQL database offering provides a relational database platform as a service. This can be considered in the category of platform as a service or database as a service. The alternative would be to use the Azure infrastructure as a service offering of obtaining Azure virtual machines and configuring these yourself to host SQL server.

The level of throughput required measured in database transaction units or DTUs is available through three broad service tiers, basic, standard and premium. But within this there are options on the DTUs supporting, generating different levels of charges. You can choose to take this offering as a single database, alternatively if you have multiple databases you can manage these within an elastic pool, which gives you a functionality that it will scale as needed based on the database load, with charges varying depending on the actual load.

The Elastic Pool option also is provided in the same three broad levels, the charging is more flexible and allows you to obtain a cost effective service even where the database usage is highly variable. The charges are based on Elastic Database Transaction units also known as eDTUs, which correspond to DTUs except that the Elastic Database will not use any eDTUs until there is actual usage of the database.

In this demo we'll illustrate how to set up a database using the Azure Portal. So let's head there now and get started. I'm here in the Azure Portal and I've brought up the SQL panel by clicking on "SQL Databases" on the left menu and now we can click "Add" to add a new database and this will then allow you to specify settings for our new server. So let's give this the name of "movies9" and then we'll use the existing test resource group that we created. It will be a blank database. Click "create new server" and we give our server a nice name, we say "movies9db" and we give it a admin login so we can say "caadmin" and we can give it a password, and lets just say "Central US" for this one and then click "Select". And now we've got the movies9db selected here, it should now permit us to continue. And it's now going ahead to crate our database and now our database has been set up and created.

We can now configure a firewall rule to allow us to have access to the database. First select the database and now we've got this panel showing, we can click the server name, clicking the server name will bring up another panel and on this panel we can then select "Show Firewall Settings" to access the dialogue to allow access to the server. So let's click on "Show Firewall Settings". In this dialogue you can then use the "Add Client IP" option to allow access from your personal IP address or you can alternatively manually specify a range of IP addresses that should have access. Clicking the "Save" option then updates the firewall settings.

So now you know how to configure the setup of a new SQL database but stay tuned because in the next video we'll start talking about Blobs.

About the Author

Isaac has been using Microsoft Azure for several years now, working across the various aspects of the service for a variety of customers and systems. He’s a Microsoft MVP and a Microsoft Azure Insider, as well as a proponent of functional programming, in particular F#. As a software developer by trade, he’s a big fan of platform services that allow developers to focus on delivering business value.