DP-900: Microsoft Azure Data Fundamentals IN PUNE | ONLINE

Duration of Training : 16 hrs

Batch type : Weekdays/Weekends

Mode of Training : Classroom/Online/Corporate Training

DP-900: Microsoft Azure Data Fundamentals Training & Certification in Pune

Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry

Realtime Projects, Scenarios & Assignments

This syllabus ensures that learners gain hands-on experience and prepare
eEectively for the DP-900 certification exam.

COURSE CONTENT :

Module 1: Introduction to Data and Microsoft Azure (2 Hours)
• Understanding structured, semi-structured, and unstructured data
• DiEerences between transactional (OLTP) and analytical (OLAP) workloads
• Overview of Azure Data Services
• Role of Database Administrators, Data Engineers, and Data Analysts

Module 2: Relational Data in Azure (4 Hours, 20-25%)
• Introduction to Relational Databases
o SQL concepts: Tables, Normalization, Joins, Indexing
o Understanding ACID properties
• Azure Relational Database Services
o Azure SQL Database
o Azure SQL Managed Instance
o SQL Server on Azure VMs
o Azure Database for MySQL, PostgreSQL, and MariaDB
• Working with SQL on Azure
o Running queries on Azure SQL Database
o Performing CRUD operations with SQL

Module 3: Non-Relational Data in Azure (3 Hours, 15-20%)
• Introduction to NoSQL & Non-Relational Databases
o Key-value, document, column-family, and graph databases
o Comparing relational and non-relational databases
• Azure Non-Relational Storage Options
o Azure Blob Storage (for unstructured data)
o Azure Table Storage (key-value store)
o Azure Cosmos DB (multi-model NoSQL database)
• Hands-on: Working with Cosmos DB
o Understanding APIs: SQL, MongoDB, Cassandra, Table, and Gremlin
o CRUD operations with Cosmos DB

Module 4: Data Analytics and Processing in Azure (4 Hours, 25-30%)
• Azure Data Analytics Services Overview
o Azure Synapse Analytics (Data Warehouse)
o Azure Data Lake Storage (ADLS)
o Azure Data Factory (ADF) for ETL/ELT
o Azure Databricks (Big Data Processing)
• Real-time Data Analytics
o Azure Stream Analytics vs. Batch Processing
o Basics of Event Hubs and IoT Hub
• Hands-on: Using Azure Synapse Studio for Queries

Module 5: Data Visualization with Power BI (3 Hours, 25-30%)
• Introduction to Power BI
o Key components: Power BI Desktop, Service, and Mobile App
o Understanding data models in Power BI
• Data Visualization Best Practices
o Choosing the right chart types
o Creating interactive dashboards
• Hands-on: Building a Power BI Report

Module 6: Exam Preparation and Practice (2 Hours)
• Review of Key Concepts
• Exam Question Format & Sample Questions
• Mock Test & Discussion

DP-900: Microsoft Azure Data Fundamentals – Course in Pune with Training, Certification & Guaranteed Job Placement Assistance!

Online Batches Available for the Areas-

Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad