Create a SQL database

Lab Details

  1. This lab walks we will walk through the steps to deploy SQL server and create SQL database containing sample data.

  2. Duration: 60 minutes

Introduction

What is Azure SQL Database?

  • Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

  • Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability.

  • PaaS capabilities that are built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.

  • With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure.

  • SQL Database can be the right choice for a variety of modern cloud applications because it enables you to process both relational data and non-relational structures, such as graphs, JSON, spatial, and XML.

Task Details

  1. Launching Lab Environment

  2. Create a Azure SQL Database

  3. Create a server-level IP firewall rule

  4. Connect to the database

  5. Create tables in the database