Working with Microsoft Azure SQL: Getting Started with Azure SQL

Azure    |    Beginner
  • 14 videos | 1h 50m 7s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)
Azure SQL is a family of offerings on Azure that use SQL Server as the database engine. Azure SQL Database is one of those offerings and is a fully managed database service with a serverless option. Through this course, learn how to get started with Azure SQL and set up an Azure SQL Database instance. Explore relational and NoSQL databases, what Azure SQL is, and the primary benefits of Azure SQL. Next, learn about Azure SQL Databases, how to configure a database to manage performance and costs, and its purchasing models and service tiers. Finally, discover how to create, configure, connect to, and query database instances. Upon completion, you'll be able to outline Azure SQL and Azure SQL Database.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Differentiate the characteristics of sql and nosql systems
    Identify some of the key benefits for adopting azure sql and azure sql databases
    List the different product offerings within the azure sql service and their use cases
    Outline the different options available for paying for the resources consumed by azure sql database
    Identify some of the important features of azure sql databases
    Create a new azure sql database instance on the azure cloud
  • View and configure resources consumed by a database and configure access to a database
    Connect to and run a simple query against azure sql database
    Execute various transact-sql (t-sql) commands to create a schema and table in a database and run queries against it
    Download and install the azure data studio desktop client and configure it to connect to azure sql database
    Set up a notebook to run queries against azure sql database
    Perform an update and query operation and save it
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 20s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 9m 17s
    After completing this video, you will be able to differentiate the characteristics of SQL and NoSQL systems. FREE ACCESS
  • Locked
    3.  The Benefits of Azure SQL
    5m 36s
    Upon completion of this video, you will be able to identify some of the key benefits for adopting Azure SQL and Azure SQL Databases. FREE ACCESS
  • Locked
    4.  Azure SQL Products
    10m 25s
    In this video, we will list the different product offerings within the Azure SQL service and their use cases. FREE ACCESS
  • Locked
    5.  Purchasing Options of Azure SQL Database
    8m 9s
    After completing this video, you will be able to outline the different options available for paying for the resources consumed by Azure SQL Database. FREE ACCESS
  • Locked
    6.  Azure SQL Database Features
    10m 36s
    Upon completion of this video, you will be able to identify some of the important features of Azure SQL Databases. FREE ACCESS
  • Locked
    7.  Configuring Azure SQL Database
    12m 1s
    In this video, find out how to create a new Azure SQL Database instance on the Azure cloud. FREE ACCESS
  • Locked
    8.  Setting Up Access to a Database
    10m 19s
    Discover how to view and configure resources consumed by a database and configure access to a database. FREE ACCESS
  • Locked
    9.  Connecting to Azure SQL Database
    4m 48s
    In this video, you will learn how to connect to and run a simple query against Azure SQL Database. FREE ACCESS
  • Locked
    10.  Querying a Database
    10m 8s
    During this video, discover how to execute various Transact-SQL (T-SQL) commands to create a schema and table in a database and run queries against it. FREE ACCESS
  • Locked
    11.  Connecting to a Database with Azure Data Studio
    7m 48s
    In this video, learn how to download and install the Azure Data Studio desktop client and configure it to connect to Azure SQL Database. FREE ACCESS
  • Locked
    12.  Running Queries from a Notebook
    10m 39s
    Learn how to set up a notebook to run queries against Azure SQL Database. FREE ACCESS
  • Locked
    13.  Saving a Notebook
    4m 25s
    Find out how to perform an update and query operation and save it. FREE ACCESS
  • Locked
    14.  Course Summary
    3m 35s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Azure Data Fundamentals: Azure Analytics Workloads
Rating 4.8 of 32 users Rating 4.8 of 32 users (32)
Course Working with Microsoft Azure SQL: Advanced Topics in Azure SQL Databases
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
Course Microsoft Azure Fundamentals: Management Tools
Rating 4.6 of 645 users Rating 4.6 of 645 users (645)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Azure Data Fundamentals: Azure Data Ingestion & Processing
Rating 4.8 of 42 users Rating 4.8 of 42 users (42)
Course Working with Microsoft Azure SQL: Advanced Topics in Azure SQL Databases
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
Course Azure Fundamentals: The Ecosystem
Rating 4.5 of 432 users Rating 4.5 of 432 users (432)