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.
Overview
Syllabus
- Relational Data Services in Microsoft Azure
- In this module, you will explore Azure SQL Database, Azure Database for PostgreSQL, Azure Database for MySQL, and Azure Database for MariaDB. You will explore scenarios for using these database management systems and examine the options available when choosing a relational data platform for hosting a database in Microsoft Azure.
- Explore Provisioning, Deploying, and Querying Relational Data in Microsoft Azure
- In this module, you will learn how to provision and configure Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL.
Taught by
Microsoft