Microsoft Azure Data Engineer DP-203 Online Certification Training Course
What Is Data Engineering?
Dp- 203 certification is for those who really want to make up in the IT and AI market. Working with Microsoft Azure this course gathers all the fundamentals of cloud computing with practical work. It teaches genuine analytical solutions through learning data engineering while using Azure data platform technologies. Starting off with storage technologies and computing analytical solutions it moves to ingestion techniques and ends on securing the data. Our courses are practically based thus providing a real-time experience of the professional platforms.
Course Outline
MODULE 1: EXPLORE COMPUTE AND STORAGE OPTIONS FOR DATA ENGINEERING WORKLOADS
- INTRODUCTION TO AZURE SYNAPSE ANALYTICS
- DESCRIBE AZURE DATABRICKS
- INTRODUCTION TO AZURE DATA LAKE STORAGE
- DESCRIBE DELTA LAKE ARCHITECTURE
- WORK WITH DATA STREAMS BY USING AZURE STREAM ANALYTICS
- ACTIVITY GUIDE: COURSE LAB SETUP
- ACTIVITY GUIDE: DELTA LAKE ARCHITECTURE
- ACTIVITY GUIDE: WORKING WITH APACHE SPARK IN AZURE SYNAPSE ANALYTICS
MODULE 2: RUN INTERACTIVE QUERIES USING AZURE SYNAPSE ANALYTICS SERVERLESS SQL POOLS
- EXPLORE AZURE SYNAPSE SERVERLESS SQL POOLS CAPABILITIES
- QUERY DATA IN THE LAKE USING AZURE SYNAPSE SERVERLESS SQL POOLS
- CREATE METADATA OBJECTS IN AZURE SYNAPSE SERVERLESS SQL POOLS
- SECURE DATA AND MANAGE USERS IN AZURE SYNAPSE SERVERLESS SQL POOLS
- ACTIVITY GUIDE: QUERYING A DATA LAKE STORE USING SERVERLESS SQL POOLS IN AZURE SYNAPSE ANALYTICS
- ACTIVITY GUIDE : SECURING ACCESS TO DATA THROUGH USING A SERVERLESS SQL POOL IN AZURE SYNAPSE ANALYTICS
MODULE 3: DATA EXPLORATION AND TRANSFORMATION IN AZURE DATABRICKS
- DESCRIBE AZURE DATABRICKS
- READ AND WRITE DATA IN AZURE DATABRICKS
- WORK WITH DATAFRAMES IN AZURE DATABRICKS
- WORK WITH DATAFRAMES ADVANCED METHODS IN AZURE DATABRICKS
- ACTIVITY GUIDE: WORK WITH DATAFRAMES
- ACTIVITY GUIDE: WORK WITH DATAFRAMES ADVANCED METHODS
MODULE 4: EXPLORE, TRANSFORM, AND LOAD DATA INTO THE DATA WAREHOUSE USING APACHE SPARK
- UNDERSTAND BIG DATA ENGINEERING WITH APACHE SPARK IN AZURE SYNAPSE ANALYTICS
- INGEST DATA WITH APACHE SPARK NOTEBOOKS IN AZURE SYNAPSE ANALYTICS
- TRANSFORM DATA WITH DATAFRAMES IN APACHE SPARK POOLS IN AZURE SYNAPSE ANALYTICS
- INTEGRATE SQL AND APACHE SPARK POOLS IN AZURE SYNAPSE ANALYTICS
- ACTIVITY GUIDE: PERFORM DATA EXPLORATION IN SYNAPSE STUDIO
- ACTIVITY GUIDE: INGEST DATA WITH SPARK NOTEBOOKS IN AZURE SYNAPSE ANALYTICS
- ACTIVITY GUIDE: TRANSFORM DATA WITH DATAFRAMES IN SPARK POOLS IN AZURE SYNAPSE ANALYTICS
- ACTIVITY GUIDE: INTEGRATE SQL AND SPARK POOLS IN AZURE SYNAPSE ANALYTICS
MODULE 5: INGEST AND LOAD DATA INTO THE DATA WAREHOUSE
- USE DATA LOADING BEST PRACTICES IN AZURE SYNAPSE ANALYTICS
- PETABYTE-SCALE INGESTION WITH AZURE DATA FACTORY
- ACTIVITY GUIDE: IMPORT DATA WITH POLYBASE AND COPY USING T-SQL
- ACTIVITY GUIDE: PETABYTE-SCALE INGESTION WITH AZURE SYNAPSE PIPELINES
MODULE 6: TRANSFORM DATA WITH AZURE DATA FACTORY OR AZURE SYNAPSE PIPELINES
- DATA INTEGRATION WITH AZURE DATA FACTORY OR AZURE SYNAPSE PIPELINES
- CODE-FREE TRANSFORMATION AT SCALE WITH AZURE DATA FACTORY OR AZURE SYNAPSE PIPELINES
- ACTIVITY GUIDE: CODE-FREE TRANSFORMATION AT SCALE WITH AZURE SYNAPSE PIPELINES
- ACTIVITY GUIDE: ORCHESTRATE DATA MOVEMENT AND TRANSFORMATION IN AZURE SYNAPSE PIPELINES
MODULE 7: ORCHESTRATE DATA MOVEMENT AND TRANSFORMATION IN AZURE SYNAPSE PIPELINES
- ORCHESTRATE DATA MOVEMENT AND TRANSFORMATION IN AZURE DATA FACTORY
- ACTIVITY GUIDE: LINKED SERVICE AND DATASETS
- ACTIVITY GUIDE : CREATE MAPPING DATA FLOW AND PIPELINE
- ACTIVITY GUIDE : CREATE SYNAPSE SPARK NOTEBOOK TO FIND TOP PRODUCTS
MODULE 8: END-TO-END SECURITY WITH AZURE SYNAPSE ANALYTICS
- SECURE A DATA WAREHOUSE IN AZURE SYNAPSE ANALYTICS
- CONFIGURE AND MANAGE SECRETS IN AZURE KEY VAULT
- IMPLEMENT COMPLIANCE CONTROLS FOR SENSITIVE DATA
- ACTIVITY GUIDE: SECURING AZURE SYNAPSE ANALYTICS SUPPORTING INFRASTRUCTURE
- ACTIVITY GUIDE: SECURING THE AZURE SYNAPSE ANALYTICS WORKSPACE AND MANAGED SERVICES
- ACTIVITY GUIDE: SECURING AZURE SYNAPSE ANALYTICS WORKSPACE DATA
MODULE 9: SUPPORT HYBRID TRANSACTIONAL ANALYTICAL PROCESSING (HTAP) WITH AZURE SYNAPSE LINK
- DESIGN HYBRID TRANSACTIONAL AND ANALYTICAL PROCESSING USING AZURE SYNAPSE ANALYTICS
- CONFIGURE AZURE SYNAPSE LINK WITH AZURE COSMOS DB
- QUERY AZURE COSMOS DB WITH APACHE SPARK POOLS
- QUERY AZURE COSMOS DB WITH SERVERLESS SQL POOLS
- ACTIVITY GUIDE : CONFIGURE AZURE SYNAPSE LINK WITH AZURE COSMOS DB
- ACTIVITY GUIDE : QUERY AZURE COSMOS DB WITH APACHE SPARK FOR SYNAPSE ANALYTICS
- ACTIVITY GUIDE : QUERY AZURE COSMOS DB WITH SERVERLESS SQL POOL FOR AZURE SYNAPSE ANALYTICS
MODULE 10: REAL-TIME STREAM PROCESSING WITH STREAM ANALYTICS
- ENABLE RELIABLE MESSAGING FOR BIG DATA APPLICATIONS USING AZURE EVENT HUBS
- WORK WITH DATA STREAMS BY USING AZURE STREAM ANALYTICS
- INGEST DATA STREAMS WITH AZURE STREAM ANALYTICS
- ACTIVITY GUIDE: CONFIGURE SERVICES
- ACTIVITY GUIDE: GENERATE AND AGGREGATE DATA
MODULE 11: CREATE A STREAM PROCESSING SOLUTION WITH EVENT HUBS AND AZURE DATABRICKS
- PROCESS STREAMING DATA WITH AZURE DATABRICKS STRUCTURED STREAMING
- ACTIVITY GUIDE: CREATE A STREAM PROCESSING SOLUTION WITH EVENT HUBS AND AZURE DATABRICKS
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training
