DP-900 Microsoft Azure Data Fundamentals, Part 2 of 4: Explore Relational Data
with expert Maruti Makwana
Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 1/4/2022 | |
| Level | Beginner | |
| Runtime | 1h 16m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | N/A | |
| Exams | Included |
Course description
DP-900 Microsoft Azure Data Fundamentals exam is for candidates beginning to work with data in the cloud. This course covers the second section of the exam Describe how to work with relational data on Azure accounting for approximately (25-30%) of the exam.
Prerequisites
Candidates for this exam should have at least six months of experience with the Azure Cloud in any role, including technical, managerial, sales, purchasing, or financial. You should have a basic understanding of IT services and their association with the cloud platform.
Meet the expert
Maruti is a Microsoft Certified Corporate Trainer with over 19,000 hours of experience corporate training for companies such as: Deloitte, Morgan Stanley, LTI Infotech, Unisys, Shell, Accenture and many more. He focuses on practical implementation and hands-on practice as the best way to understand technical training.
Course outline
Module 2
Non-Relational Data (09:29)
- Introduction (00:08)
- Non-Relational Data (01:06)
- Types (03:20)
- Unstructured Data (00:48)
- NoSQL (02:01)
- Graph Database (01:57)
- Summary (00:08)
Data Analytics (07:34)
- Introduction (00:08)
- Data Journey (02:31)
- Data Visualization (01:58)
- Data Analytics (02:48)
- Summary (00:08)
Relational Data Services in Azure (16:01)
- Introduction (00:08)
- Explore Relational Data (01:22)
- Azure Data Services (01:38)
- IaaS vs. Paas (04:15)
- SQL Server on Azure Virtual Machines (02:56)
- Managed Instance (02:17)
- Azure Database Types (03:15)
- Summary (00:08)
Provisioning Relational Data on Azure (23:11)
- Introduction (00:08)
- Relational Data Services (03:15)
- Connectivity from within Azure (01:50)
- Connectivity Outside Azure (01:23)
- Authentication and Access Control (01:29)
- Role Based Access Control (03:49)
- Demo: Provision Relational DB Service (11:07)
- Summary (00:08)
Query Relational Data in Azure (20:28)
- Introduction (00:08)
- SQL (00:56)
- Statement Types (01:45)
- DML Statements (00:49)
- Select Statement (01:32)
- Example of Select (02:04)
- DDL Statements (00:17)
- Create Statement (00:54)
- Query Tools (02:28)
- Demo: Query Azure SQL Database (09:24)
- Summary (00:08)