1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Introduction to Azure Storage Solutions

Azure SQL Database Demo

Start course
Overview
DifficultyIntermediate
Duration1h 13m
Students2529
Ratings
4.8/5

Description

This course provides an introductory tour of Azure Storage Solutions such as its SQL offerings (SQL DB and third party offerings of MySQL), managed NoSQL databases (DocumentDB and MongoDB), managed Redis Cache service, Azure Backup (backup-as-a-service), Site Recovery (for handling disaster recovery) and StorSimple (a hybrid cloud storage solution).

Target Audience / Experience

  • This course is for developers or IT professionals looking for an introduction to Azure’s Storage Solutions.
  • Some familiarity with the Azure platform is helpful, but not required.

Learning Objectives

  • Understand what SQL DB is and how to get started using it
  • Learn the options offered by Azure for managed MySQL
  • Understand what DocumentDB and MongoDB are and how to get started using them
  • Learn what Redis Cache is and some cases of when you would use it
  • Get an understanding of what Azure Search provides
  • Learn how Azure Backup can solve common backup needs
  • Understand what role Site Recovery can play in disaster recovery
  • Learn how StorSimple can extend your on-premise storage capacity


Outline

  • Course Introduction
    • Overview
  • Azure SQL Database
    • What is Azure SQL Database?
    • Understanding the service tiers
    • Create a SQL Database
    • What is a Data Throughput Unit (DTU)?
    • Scaling Azure SQL
  • MySQL
    • Options for Using MySQL in Azure
  • Azure CosmosDB DocumentDB API
    • What is DocumentDB?
  • Azure CosmosDB MongoDB API
    • Options for Using MongoDB in Azure
    • How does DocumentDB compare to MongoDB?
  • Azure Redis Cache
    • What is Azure Redis Cache?
    • Common scenarios for using Redis Cache
    • Understanding the service tiers
    • How does Redis work?
    • Create and manage a Redis Cache
    • Scaling Azure Redis Cache
  • Azure Search
    • What is Azure Search?
    • Indexes and Search Features
    • How do you use the Search Service?
    • Create a Search Service and Index
  • Azure Backup
    • What is Azure Backup?
    • Backup Scenarios
    • Import/Export Service
    • What is the Import/Export Service?
    • Why would you use Import/Export?
  • Site Recovery
    • What is Site Recovery?
    • Workload recovery scenarios
  • StorSimple
    • What is StorSimple?
    • How does StorSimple work?
  • Course Summary
    • Conclusion and Wrap-Up

Transcript

So, in this demo I'm going to give you an idea of how SQL database is managed so let's start with creating a database click on the new the button. Then I'll type in SQL database and hit enter.
In the search results that come back it should be the first item in the list here. So, SQL database. And, then I'll click to create button. So, that opens the blade that allows us to enter the information we need to create a database. So let me put in a name for database. Okay, now I’ll leave the subscription same. Create a new research group.
And, I want to select a sample database so we have some data to look here in a second.
Ok, so, we need configure the server so let's enter a name for server. And, let me enter a login and password. Hopefully I can type the same password again. And you hit select.
And the server’s setup. We won’t do elastic pools right now let's change the pricing tier though. So, let's drag the handle down to the to the lowest level.
That should be good, $15 a month. So let me hit apply. And, then pin it to dashboard and click create. This will take a while so I'll let it create and then I'll stop the video.
Welcome back the database is now created and the overview panel is now open for us, showing us general information about the database has been created.
So, you can see the resource group the status, location, subscription information, server name, connection string, pricing tier, geo replication which isn’t configured.
Before we explore anymore let's query the database and see if there's a really anything there.
This is where I could open SQL server management studio or visual studio to connect to the database which is the most commonly you do it.
To do with an application you could go to the connection string link and, click on it to get the text of the connection string you could use. But for demo purposes I don’t want to do that right now so I’ll close out of here.
Ok, instead let's go to tools. Click query editor. The first thing we need to do is log in.
So, let me enter my password. Ok, alright it looks like a logged in.
Now I’ll paste in a query I have to get the records from the customer table and click on the run button to execute the query.
Ok, cool looks like data is there. Now let’s close the query editor and go back to the tools blade.
All right now let's explore. In the toolbar there's a copy button which will take you to where you can create another database from a copy of this database. You get to pick a server and a pricing tier and all the same stuff.
Next is the restore button which won't work for yet since we don't have any backups. So I’ll close this.
Export is where you would go to create a backpack of the database. It will stick it in a storage account for you.
Set server firewall takes us to the firewall settings blade. In order to connect to the SQL database I need to add my ip address to the list which I can do by clicking the add client ip button.
Then I need to click save to make the change and click OK.
Now I can connect to the database my local machine if I need to.
Delete would allow us to delete the database. Now let's see what else is in the menu.
Activity log is where you would go to see anything that has been done on the database level - this is the administrative level stuff not the TSQL activity.
Quick start shows you a list of useful links that are good for when you're starting out with SQL database. Pricing tiers is where you'd go to scale up or down. Just change the settings and click apply.
Geo-replication is where you would go to configure your database if you wanted to replicate to another data center.
Auditing and threat detection can we turn on and off.
Dynamic masking is where you can add masks to columns and tables. By default it tries to recommend some columns you may want to mask.
Transparent data encryption, this is where you would turn the encryption rest setting on and off.
Properties shows you about the same stuff that's in the overview.
Alerts allow you to configure alerts for certain conditions you can either have it send an email or call a webhook - which opens up some nice options to programmatically react to an alert.
Database size, shows you the current size of the database.
Performance overview is what I call performance dashboard earlier you can look at recommendations.
Right now it's new database so there’s not going to be any recommendations. You’d also get to see the performance of queries in the last 24 hours some other additional information.
Ok, that's a quick lap around SQL database.

For those of you who are looking to find more detail on SQL Database, here are some links for you.
Otherwise, if you are ready to move to the next product, let's take a look at the other relational database called MySQL.

About the Author

Students2559
Courses1


Jason Haley is an independent consultant who focuses on Azure and Angular. He has over 20+ years’ experience architecting, designing, developing and delivering software solutions using mostly Microsoft technologies. Jason recently achieved his MCSE: Cloud Platform and Infrastructure certification in May 2017 (by passing all of the 70-532, 70-533 and 70-534 exams). He is also a Microsoft Azure MVP and leads the North Boston Azure User Group. He frequently speaks at community events on topics relating to Azure.