Training: Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012)

Ref. DP-3012
Duration:
1
 day
Exam:
Optional
Level:
Intermediate

Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012)

Complete Training on Azure Synapse Analytics: “Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012)“. Whether you are a beginner or an experienced professional in the field of data analysis, this training will guide you through the various applications and features of Azure Synapse to transform data into actionable insights.

Learn how to query files in a data lake with the serverless SQL pool, analyze data with Apache Spark, and optimize data workflows with Delta Lake in our detailed modules. You will also learn how to design data warehouse schemas and build efficient data pipelines in Azure Synapse Analytics. Join the course ‘Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012)’ to master these essential skills and propel your career in the field of Big Data and data analytics.

Participant profiles

  • Administrators
  • Data specialists

Objectives

  • Provide a complete understanding of Azure Synapse Analytics
  • Teach the use of serverless and dedicated SQL pools
  • Train on data analysis with Apache Spark
  • Integrate Delta Lake for advanced data management
  • Design and implement a relational data warehouse
  • Build and execute data pipelines

Prerequisites

  • Familiarity with notebooks using various languages and a Spark engine
  • Experience with SQL and Python
  • Skills in Azure tools, including Data Factory

Course content

Module 1 – Introduction to Azure Synapse Analytics
  • What is Azure Synapse Analytics
  • How Azure Synapse Analytics works
  • When to use Azure Synapse Analytics
Module 2 – Using Azure Synapse’s serverless SQL pool to query files in a data lake
  • Understand the capabilities and use cases of the serverless SQL pool in Azure Synapse
  • Query files using a serverless SQL pool
  • Create external database objects
Module 3 – Analyzing data with Apache Spark in Azure Synapse Analytics
  • Get acquainted with Apache Spark
  • Use Spark in Azure Synapse Analytics
  • Analyze data with Spark
  • Visualize data with Spark
Module 4 – Using Delta Lake in Azure Synapse Analytics
  • Understand Delta Lake
  • Create Delta Lake tables
  • Create catalog tables
  • Use Delta Lake with streaming data
  • Use Delta Lake in a SQL pool
Module 5 – Analyzing data in a relational data warehouse
  • Design a data warehouse schema
  • Create data warehouse tables
  • Load data warehouse tables
  • Query a data warehouse
Module 6 – Building a data pipeline in Azure Synapse Analytics
  • Understand pipelines in Azure Synapse Analytics
  • Create a pipeline in Azure Synapse Studio
  • Define data flows
  • Execute a pipeline

Documentation

  • Digital course material included

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

Introduction to Azure Synapse Analytics with our course Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012)

Azure Synapse Analytics is presented as an integrated solution for data management and big data analytics, designed to accelerate data-driven decision-making. This service offers a unified platform to explore, prepare, manage, and serve data for business intelligence applications and machine learning. Advanced data processing features, like dedicated and serverless SQL pools and Spark integration with Synapse Pipelines, make Azure Synapse Analytics ideal for businesses looking to optimize their data operations.

Querying Data with Serverless SQL

A major innovation in Azure Synapse Analytics is its ability to query data stored in a data lake via a serverless SQL pool. This feature allows users to run SQL queries on large volumes of unstructured data without requiring infrastructure management, thus offering flexibility and efficiency for data analysis.

Advanced Analysis with Apache Spark

Azure Synapse Analytics integrates Apache Spark, enabling advanced data analysis and interactive visualization. This integration allows users to process large volumes of data with Spark, thereby facilitating complex analysis and data visualization for deeper insights.

Delta Lake and Real-Time Data Management

Adopting Delta Lake within Azure Synapse Analytics enhances data management with features like Delta Lake tables, essential for real-time data processing and data consistency in complex analytics environments.

Designing Data Warehouse Solutions

The ability to design data warehouse schemas and load data warehouse tables is crucial for effective analysis. Azure Synapse Analytics provides tools for designing data warehouse solutions, thus enabling efficient querying and data-driven decision-making.

Data Pipeline and Automation

Building data pipelines in Azure Synapse Analytics through Synapse Studio enables organizations to automate data processing and flow. These pipelines support the orchestration of data analysis tasks, making processes more efficient and reducing implementation times.

Azure Synapse Analytics, with its advanced data analysis tools such as serverless SQL pools, Apache Spark, and Delta Lake, as well as data pipeline building capabilities, offers a comprehensive solution for the analytical challenges of modern businesses. Its compatibility with other Azure tools and various programming languages makes it accessible to a wide range of users, from data scientists to business analysts.

Prix de l'inscription
CHF 850.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge

ven31Mai09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3012

ven31Mai09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3012

ven05juil09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3012

ven05juil09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-3012

ven09Aoû09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3012

ven09Aoû09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3012

ven13Sep09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3012

ven13Sep09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-3012

ven18Oct09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3012

ven18Oct09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3012

ven22Nov09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3012

ven22Nov09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-3012

ven27Déc09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3012

ven27Déc09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3012

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X