Design and development of databases and data warehouses, including the creation of data mart structures, SQL coding, and performance tuning.

• Introduction to Cloud Computing
• Azure Core Services
• Azure Networking
• Azure Storage
• Understanding Cloud Concepts
• Azure Core Services
• Understand Security, Privacy, Compliance and Trust
• Understanding Azure Pricing

• Document data stores
• Columnar data stores
• Key/value data stores
• Graph data stores
• Time series data stores
• Object data stores
• External index
• Why NoSQL or Non-Relational DB?
• When to Choose NoSQL or Non-Relational DB?
• Best Uses
• Scenarios
• Azure Data Lake Storage
• Definition
• Azure Data Lake-Key Components
• Azure Data Lake Storage Gen2

• Data Lake Key Concepts
• Azure Cosmos DB
• Why Azure Cosmos DB?
• Azure Blob Storage
• Why Azure Blob Storage?
• Data Partitioning
• Horizontal partitioning
• Vertical partitioning
• Functional partitioning
• Why Partitioning Data
• Consistency Levels in AzureCosmos DB
• Semantics of the five-consistency level

• Introduction to Relational Data Stores
• Azure SQL Database
• Deployment Models
• Service Tiers
• Hands-on: Create a Single Database Using Azure Portal
• Hands-on: Create a managed instance
• Hands-on: Create an elastic pool
• Why SQL Database Elastic Pool?
• Hands-on: Create a SQL virtual machine
• Hands-on: Configure active geo-replication for Azure SQL Database in the Azure portal and initiate failover.

• Flow Process of Data Factory
• Why Azure Data Factory
• Integration Runtime in Azure Data Factory

• Azure data factory Pipelines

  • Copy data in cloud
  • Copy on-premises data to cloud
  • Copy data in bulk
  • Copy data incrementally
  • Load ADLS Gen2
  • Load SQL DW
  • Load SAP BW
• Azure Data Factory Dataflows
• Create data flow
• Execute data flow activity inside pipeline

• What is Azure Databricks?
• Azure Spark-based Analytics Platform
• Apache Spark in Azure Databricks
• Hands-on: Run a Spark Job on Azure Databricks using the Azure portal
• Hands-on: ETL Operation by using Azure Databricks
• Hands-on: Stream data into Azure Databricks using Event Hubs

• Working of Stream Analytics
• Hands-on: Analyse phone call data with stream analytics and visualize results in Power BI dashboard
• Stream Analytics Windowing Functions
  • Tumbling window
  • Hopping Window
  • Sliding Window
  • Session Window

• What is Azure Monitor?
• Metrics
• Logs
• Metrics Vs Logs
• What data does Azure Monitor collect
• What can you Monitor?
• Insights and Core Solutions
• Alerts in Azure
• Flow of Alerts
• Key Attributes of an Alert Rule
• What can you set alert on?
• Azure Security Logging & Auditing
• Azure SQL Database Auditing
• Server-level vs. Database-level Auditing Policy
• Hands-on: Azure SQL Database Auditing

• Creation of Report
• Publishing to CLOUD
• DAX Introduction
• Basic Calculation using DAX
• Measures on Category AXIS
• DATA Transformations
• Designing a DASHBOARD
• Advanced VISUALIZATIONS
• Advanced Features of POWER BI CLOUD SERVICE
• Advanced Features of POWER BI DESKTOP CLIENT
• POWER BI PROJECT 1
• POWER BI PROJECT 2
• DATA Types
• Logical Functions
• Error Handling
• Context
• Context Interactions
• Context over Relations
• SCHEMA Relations
• Table Functions
• Time Intelligence Functions
• Rankings
• GATEWAY and Schedule Refresh
• SANDDANCE and PERCENTILE
• Row Level Security
• POWERBI QUIZ