Course Syllabus
Azure Data Lake Storage
Introduction to Azure Data Lake Storage
Features of Azure Data Lake
Data Storage Mechanisms in Azure Data Lake
Understanding the Need for Data Lake
Introduction to Azure Data Lake Gen2
Data Lake Architectural Overview
Data Lakes ,Cosmo DB , and Blob Storage
Basics of Data Lakes
Introduction to Azure Cosmos DB
Why Use Azure Cosmos DB?
Overview of Azure Blob Storage
Importance of Azure Blob Storage
Partitioning Data In Azure
Horizontal, Vertical, and Functional Partitioning
Why is Data Partitioning Vital?
Consistency Levels in Azure Cosmos DB
Relational Data Stores In Azure
Understanding Relational Data Stores
Overview of Azure SQL Database: Deployment Models and Service Tiers
Importance of SQL Database Elastic Pool and Azure SQL
Security Features in Azure SQL
Azure SQL Database High-Availability: Premium and Standard Models
Introduction to Azure Databases: MySQL, PostgreSQL, and MariaDB
Configuring and Connecting to Databases through Azure Portal and MySQL Workbench
Advanced Azure Data Concepts
Introduction to Polybase and its Importance
Overview of Azure Synapse Analytics and its Components
Exploring SQL Pools and Big Data Elements in Azure Synapse
What is Azure Batch? Exploring Tightly Coupled and Intrinsically Parallel Workloads
Working with Azure Batch and its Additional Features
Azure Data Factory
Comparison: SSIS vs Azure Data Factory
Introduction to Data Sets, Linked Services, Pipelines, and Parameters vs Variables
Data Copying, Monitoring, and Deployment in Azure Data Factory
Exploring Various Integration Runtimes and Creating Pipelines
Working with Data: Copying, Appending Variables, Executing Pipelines, and Metadata
Advanced Data Operations: Stored Procedures, Lookup, Filters, Conditional Operations, and more
Deployment: ARM Templates, Code Repositories in GitHub, and Environment-Specific Deployment
Monitoring, Debugging, and Error Handling in Azure Data Factory
Azure Stream Analytics and Data Bricks
Working with Azure Stream Analytics: Advantages, Capabilities, and Windowing Functions
Introduction to Azure Data Bricks and its Association with Apache Spark
Exploring the Azure Spark-based Analytics Platform
Monitoring and Ensuring Security in Azure
Introduction to Azure Monitor: Logs, Metrics, and Their Differences
Data Insights Gathered by Azure Monitor
Core Monitoring Solutions in Azure
Alert Management in Azure: Attributes, Flow, Creation, and States
Azure Security Auditing and Logging Overview
Azure SQL Database Auditing: Database vs Server-Level Policies
