Course designed for everyone to learn Azure Synapse Analytics , Synapse SQL Pool, Spark Pool. Enriched with Labs
What you will learn
This course will provide deep knowledge of Azure Synapse Analytics platform from basics. This includes learnings to write SQL scripting in Azure SQL Data Warehouse.
This course enables to learn basic building blocks of Azure Synapse and provides basic practical labs.
Students will learn the Massively Parallel Processing (MPP) architecture how it works and performs.
This course is very helpful to data enthusiasts , ETL developers, Data Analysts, Data Engineers and other roles linked to data and analytics
Students will get a introductory knowledge of Cloud Computing , it’s types and steps to start using free version of Azure and configure the subscription.
This course is structured in accordance with DP-200 & DP-201 Azure Certification syllabus, hence will enable the learners to crack the exam.
Description
Azure Synapse Analytics is a crucial next generation cloud platform loaded with elastic Data Warehouse capability to churn petabytes of data in Cloud. This course is deeply designed to induce basic overview of what this next generation platform is and get familiar with its architecture & basic entities. The course is designed with simple sessions to explain all topics covering Synapse SQL, Spark Pool and Synapse Studio and management.
We have included basic coding sessions and labs to get each enrolled student learn to write codes and query data from different sources. This course has cookbooks and lab resources to practice each scenario at your local end.
This course is best for everyone even freshers with basic knowledge of data and SQL can enroll. This course has a 10 plus different sessions and lectures based on industry use cases and Realtime scenarios.
This module contains specific sections totally designed to learn Synapse SQL pool, how to create a SQL pool and manage it from Azure portal. Enriched with lab which gives hand on experience to write SQL queries, designs databases manage table distributions and build external tables to load data.
Spark Pool module explains basic concept of Spark and how to create and manage Spark Pool , learn about configuring compute nodes and steps to scale it in Azure. Lab sessions to write simple codes on querying data from files from different sources , create data frames and write spark SQL scripts.
Content