Azure Synapse Analytics Video Training

This impeccable Azure Synapse Training course is carefully designed for aspiring ETL Developers and Architects. This AzureSynapse Training includes basic to advanced ETL Concepts, Data Warehouse (DWH) and Data Mashups / Data Flow concepts using SQL Server, Azure SaaS Components. This Azure Synapse Training course also includes Azure SQL Database Migrations, Azure Storage, Azure Data Warehouse (ADW), Incremental Loads, Power Query, Azure Data Lake required for Big Data Analytics and Warehouse design with ONE Real-time Project.

Complete practical and realtime Azure BI Training course with 24x7 LIVE server, Resume Guidance, ONE Real-time Project with Interview & Placement Assistance.

Azure Synapse Analytics Training Plans

  PLAN A PLAN B PLAN C
Course includes Azure Synapse
Analytics
Azure Synapse Analytics
Azure Data Factory
Azure Data Engineer
Synapse, ADF,
ADB, Cosmos
Total Duration 2 Weeks 4 Weeks 8 Weeks
Azure Synapse Configuration
Azure Synapse Architecture
Azure Analytics Workspace
Basic ETL Concepts with SSMS
Bulk Loads with Synapse
Data Warehouse Units (DWUs)
Azure Synapse Management
Azure Monitoring, ADB
Azure Synapse with Power BI
Azure Data Factory
ADF Resources, Auhtor, Monitor
Copy Data Tool, ETL Operations
Azure SQL Database For ETL
Azure Synapse, Incremental Loads
Data Flow, Data Wrangling
ETL, Tranformations, Lookups
ADF Triggers, Monitoring
Data Bricks Architecture
Run Spark Jobs, ADB Workspace
Virtual Network, File System
Structured Streaming, Delta Lake
Azure Cosmos DB Concepts
Cosmos Tables, UI Interface
End to End Implementation
Total Course Fee * INR 9000
USD 122
INR 16000
USD 217
INR 32000
USD 433

Trainer: Mr. Sai Phanindra T

If above schedule does not work, opt for Azure Synapse Training Videos


Azure Synapse TRAINING HIGHLIGHTS :

✔ Basic to Adv. ETL ✔ Basic to Adv. DAX
✔ Data Modelling ✔ OLAP DB Design
✔ Power Query ✔ Basic to Adv. MDX
✔ Kimball BI Design ✔ Inmon BI Design
✔ Star, Snowflake ✔ Data Warehousing
✔ OLTP, File Data ✔ JSON, XML Data
✔ Resume Guidance ✔ MCSA MSBI Exam

All Session Are Completely Practical & Real Time

Azure Synapse Training Course Contents:

Module I: Azure Synapse Analytics

Module 2: Azure Synapse Analytics

Ch 1 : Azure Synapse Intro

  • Need for Azure Synapse
  • Data engineers, Data scientists
  • IT professionals, Business analysts
  • Database administrators
  • Data security and privacy
  • Subscription and Azure Resources
  • Azure Synapse Configuration
  • Azure SQL Server Creation
  • Azure Server Firewalls
  • Synapse Firewalls, Remote Access
  • Azure Synapse Pool (DWH)
  • Azure Synapse Analytics Engine
  • DWU Units and Scaling Options
  • Start and Pause Options

Ch 6 : Bulk Loads with Synapse

  • Bulk Loads with COPY Data
  • High-throughput Data Ingestion
  • FIELDTERMINATOR in CopyData
  • ROWTERMINATOR in CopyData
  • LABEL Options, Data Loads
  • Load Monitoring in Synapse
  • Azure Synapse - SQL Tables
  • CopyData with Multiple Tables
  • Authentication Methods
  • Storage account key with LF
  • Shared Access Signatures (SAS)
  • CRLF as the row terminator
  • Managed Identity Authentication
  • Azure Active Directory Authentication

Ch 2 : Azure Synapse Architecture

  • Scaling Options, Compute Engine
  • cDWU & DWU : Real-time Usage, Pricing
  • Massively Parallel Processing (MPP)
  • Sharding Benefits with MPP in DWH
  • Control Node and Compute Node
  • Data Distribution Components in ADW
  • DMS : Data Movement Service, CMVs
  • Synapse Tables : Types
  • Integration Tables, Schemas
  • Table Persistance, Regular Tables
  • Temporary Tables, External Tables
  • Distributed Tables, Table Partitions
  • Hash Functions, Distributed Tables
  • Round-robin Distributed Tables

Ch 7 : Data Warehouse Units (DWUs)

  • Azure Datawarehouse Units
  • Synapse Resource Pools
  • Azure ServiceLevel Objective
  • T-SQL Scripts for SLO Options
  • PerformanceTiers - Gen1, Gen2
  • Data Warehouse Units (DWU)
  • Capacity Limits, Permissions
  • DWU settings and Reports
  • Important DMVs, DMFs
  • Scaling Workflow in Azure Synapse
  • Performance Tuning Options
  • Orded Clustered ColumnStore Index
  • Non-Ordered Columnstore Index
  • Query Performance, CCI, CTAS

Ch 3 : Azure Analytics Workspace

  • Azure Synapse and Spark Technologies
  • Azure Synapse SQL Concpets
  • Azure Synapse Piplelines, Usage
  • Creating Workspace in Azure Synapse
  • Azure Datalake Storage Gen 2
  • Edit, Delete Options: Command Bars
  • Azure Synapse Studio : IDE
  • Storage Accounts Browsing Options
  • Query Files and Storage Blob
  • SQL Scripts and Spark Notebooks
  • Creating Spark Pools in Synapse
  • SQL On-demand in Azure Synapse
  • Logical Data Warehouse Concepts
  • Client Tools, PARQUET File Format

Ch 8 : Azure Synapse Management

  • Backups and Restores in Synapse
  • User-defined restore points
  • Creating and Using Restore Points
  • Resting Existing Restore Point
  • Restoring Deleted Resource Pool
  • Restore from Ge-Backup SQL Pool
  • Secure Database in Azure Synapse
  • Connection security with Synapse
  • Authentication Modes and Options
  • Authorization Techniques in Synapse
  • Database Encryption : Data Security
  • Transperant Data Encryption (TDE)
  • Certificates and AES-256 Algorithm
  • Important Security Scripts in T-SQL

Ch 4 : Basic ETL Concepts with SSMS

  • SSMS Client Tool, Access Options
  • Azure Datawarehouse Access
  • Performance Levels in Synapse
  • Client IP Address, Fully Qualified Names
  • Creating Logins and Users for ETL
  • COPY Statement and Data Loads
  • Azure Data Lake Storage
  • ETL Operations with Azure Storage
  • Azure Storage Architecture, ADLS
  • Azure Storage Gen 1 and Gen 2
  • Understanding COPY Statement
  • Optimize ColumnStore Compression
  • Optimize Statistics.ColumnStore Indexes
  • Fact Tables and Dimension Tables

Ch 9 : Azure Monitoring

  • Manageability and monitoring with Synapse SQL pool
  • Monitor your Azure Synapse Analytics SQL pool workload using DMVs
  • VIEW DATABASE STATE
  • Monitor connections, Memory
  • Monitor Query Execution
  • Monitor Active Queries, CTAS
  • Find top 10 queries longest running queries
  • Polybase Loads, Catalog Loads
  • Suspended States, TempDB
  • sys.dm_pdw_exec_requests
  • Investigate the Query Plan
  • Data Movement operations
  • SQL on the distributed databases
  • Monitor Waiting Queries

Ch 5 : Azure Synapse with Data Factory

  • Azure Data Factory with Synapse
  • Creating Factory Resource, Options
  • ADF Versions and Editor Options
  • Author and Monitor Options in ADF
  • Creating Pipelines, Copy Data Tool
  • Loading Data into Azure Synapse
  • Loading Data From Azure Synapse
  • Real-time Considerations
  • Incremental Loads with Files
  • Table Mapping and Polybase
  • Staging Options with ADF
  • Debugging, Validations
  • Publishing Options with Pipelines
  • Triggering Options, Task Cadence

Ch 10 : Azure Synapse with ADB

  • Creating Azure Synapse Database
  • Loading Data from Azure Synapse
  • Azure Synapse connector
  • Spark Driver for Azure Synapse
  • Spark Executors for Azure Synapse
  • Azure Synapse to Azure storage
  • Global Hadoop configuration in ADB
  • Real-time Recommendations
  • Azure Synapse with Power BI
  • Report Generation with Synapse
  • Real-time Recommendations
  • Dataset Creation, Data Flows
  • Power Query and ETL
  • Visualizations, Data Modelling
  • Real-time Recommendations
Register Today  Other Popular Courses: Azure Synapse Training, Azure Cosmos DB Training, Azure Data Factory Training, Azure Data Engineer Training, Azure Admin Training, AZ-104 Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T [ 15+ Yrs of Technical Expertise, Microsoft Certified Trainer ]

Other Trainings