Monthly Subscription Starting at AED 99 + VAT

Microsoft Azure SQL
  • Level Foundation
  • المدة 7 ساعات hours
  • الطبع بواسطة Microsoft
  • Offered by

عن

In this course, you will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure. You will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. You will learn about SQL, how it's used to query and maintain data in a database, and the different dialects that are available. This is the second course in a program of five courses to help prepare you to take the Exam DP-900: Microsoft Azure Data Fundamentals. so that you can demonstrate that you have a foundational knowledge of the core database concepts in a cloud environment. This course is ideal for IT professionals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure with a view to taking up roles as Data Engineers and Database Administrators. It is also suitable for working database professionals looking for additional skills or credentials to showcase expertise in a cloud environment and IT professionals looking to specialize in the specific area of Azure data. To be successful in this course, you need to have basic computer literacy and proficiency in the English language. Successful Azure Data Fundamentals students start with some basic awareness of computing and Internet concepts, and an interest in extracting insights from data. It is an advantage to have experience using a web browser, familiarity with basic data-related concepts, such as working with tables of data in a spreadsheet, and visualizing data using charts.

الوحدات

Welcome to the course

    • 1 Videos
    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Relational Data in Microsoft Azure

1 Videos

  • Welcome to the course

2 Readings

  • Course syllabus
  • How to be successful in this course

Explore Relational Data Services in Microsoft Azure

    • 6 Videos
    • 1 Readings
    • 2 Quiz
Show info about module content

6 Videos

  • Lesson introduction
  • Relational data services in Microsoft Azure
  • SQL Server on Microsoft Azure virtual machines
  • Azure SQL Database
  • Azure SQL Database Managed Instance
  • PostgreSQL, MariaDB, and MySQL

1 Readings

  • Additional readings

2 Quiz

  • Knowledge check
  • Test prep

Provisioning and Deploying Relational Database Services in Microsoft Azure

    • 5 Videos
    • 2 Readings
    • 1 Quiz
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Exercise quiz

5 Videos

  • Lesson introduction
  • Provisioning relational data services
  • Provisioning PostgreSQL and MySQL
  • Configuring Relational Data services
  • Configuring Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL

2 Readings

  • Exercise - Provision Azure relational database services
  • Additional readings

1 Quiz

  • Knowledge check

Query relational data in Microsoft Azure

    • 4 Videos
    • 5 Readings
    • 2 Quiz
    • 1 Assignment
Show info about module content

1 Assignment

  • Exercise quiz

4 Videos

  • Lesson introduction
  • Introduction to SQL
  • Query relational data
  • Weekly summary

5 Readings

  • Query relational data in Azure SQL Database​
  • Query relational data in Azure Database for PostgreSQL
  • Query relational data in Azure Database for MySQL​
  • Exercise: Use SQL to query Azure SQL Database​
  • Additional readings

2 Quiz

  • Knowledge check
  • Test prep

Course Wrap-Up

    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Course review

1 Readings

  • What to expect

Auto Summary

Explore the essentials of cloud-based database concepts with the "Microsoft Azure SQL" course, perfect for IT professionals aiming to build foundational knowledge in cloud data services within Microsoft Azure. Taught by Coursera, this course covers relational data offerings, database provisioning, and querying through cloud solutions, preparing you for the Exam DP-900: Microsoft Azure Data Fundamentals. With a duration of 420 minutes, the course is ideal for aspiring Data Engineers, Database Administrators, and IT specialists seeking to enhance their cloud expertise. Basic computer literacy and a keen interest in data are recommended prerequisites. Available with a Starter subscription.

Microsoft
Instructor

Microsoft