Implement Data Analytics Solution with Azure Synapse Analytics

Implement Data Analytics Solution with Azure Synapse Analytics

Unify, Analyze, and Scale Your Data Solutions with Azure Synapse.

What does the Course Offer

6

12

16

12

19

Objectives

Practice Tests

Training Hours

Exercises

Knowledge Checks

This course teaches you how to build and manage data analytics solutions using Azure Synapse Analytics. You will learn to query data lakes with serverless SQL pools, analyze big data with Apache Spark, manage data with Delta Lake, and perform analytics on relational data warehouses using dedicated SQL pools. Additionally, you’ll gain hands-on experience in building data pipelines for automating ETL workflows. By the end of the course, you'll be prepared to design scalable, high-performance data solutions using Azure Synapse.

Course Overview

This course covers the essentials of Azure Synapse Analytics for processing and analyzing big data.

You will learn to query data lakes with serverless SQL pools, analyze large datasets using Apache Spark, manage data with Delta Lake, and perform analytics on relational data using dedicated SQL pools. Additionally, you’ll gain hands-on experience building data pipelines to automate ETL processes.

By the end of the course, you’ll be equipped to design and implement scalable, high-performance data solutions with Azure Synapse.

Learning Outcomes

Upon completing this course, participants will be able to:

1. Plan and Design Azure AI Solutions:

   • Develop AI solution architectures tailored to specific business needs.

   • Select appropriate Azure AI services for various use cases, ensuring optimal scalability and efficiency.

   • Effectively manage AI projects, including cost estimation, resource allocation, and governance.

2. Implement Content Moderation Solutions:

   • Utilize Azure Content Moderator to detect and filter inappropriate content across text, images, and videos.

   • Set up automated workflows for content moderation to ensure compliance and safety in applications.

3. Implement Computer Vision Solutions:

   • Build computer vision applications using Azure Cognitive Services for tasks like image classification, object detection, face recognition, and optical character recognition (OCR).

   • Integrate computer vision models into business applications to automate and enhance processes.

4. Implement Natural Language Processing (NLP) Solutions:

   • Apply Azure Cognitive Services for Language to analyze text data, including sentiment analysis, key phrase extraction, and language detection.

   • Build conversational AI applications and chatbots using Language Understanding (LUIS) and Azure Bot Services.

5. Implement Knowledge Mining and Document Intelligence Solutions:

   • Set up Azure Cognitive Search to build intelligent search capabilities and mine knowledge from large datasets.

   • Use Form Recognizer to automate data extraction from unstructured documents and forms.

6. Implement Generative AI Solutions:

   • Leverage Azure OpenAI and Azure Machine Learning to develop generative AI models for content creation, such as text generation, code generation, and image synthesis.

   • Build and deploy AI-powered applications that generate personalized content, automate creative processes, and engage customers.

By the end of this course, you will be proficient in designing, implementing, and managing AI solutions across a wide range of business and technical use cases using Microsoft Azure AI services.

Audience Profile

• Data professionals

• Data Analysts

• Data Engineers

• Solution Architects

• Data Scientists

• DBAs

Prerequisites

• Familiarity with Azure and the Azure portal.

• Experience programming with C# or Python.

Course Objectives

• Explore Azure Synapse Analytics

• Use Azure Synapse serverless SQL pool to query files in a data lake

• Analyze data with Apache Spark in Azure Synapse Analytics

• Use Delta Lake in Azure Synapse Analytics

• Analyze data in a relational data warehouse

• Build a data pipeline in Azure Synapse Analytics

Format

Blended (Online Training + Discussions)

Streaming Platform

Microsoft Teams Online

Course Schedule

On Demand

Trainer

Kappagantula Srikanth

Duration

16 Hours

Course Fee

$1000

Course Outline

Prerequisites (1 Hour)

• Install Visual Studio

• Install Azure PowerShell & CLI

• Create/Access Microsoft Learn Account

• Create/Access GitHub Account

• Create/Access Microsoft Azure Account

Explore Azure Synapse Analytics

• What is Azure Synapse Analytics

• How Azure Synapse Analytics works

• When to use Azure Synapse Analytics

• Exercise - Explore Azure Synapse Analytics

Use Azure Synapse serverless SQL pool to query files in a data lake

• Understand Azure Synapse serverless SQL pool capabilities and use cases

• Query files using a serverless SQL pool

• Create external database objects

• Exercise - Query files using a serverless SQL pool

Analyze data with Apache Spark in Azure Synapse Analytics

• Get to know Apache Spark

• Use Spark in Azure Synapse Analytics

• Analyze data with Spark

• Visualize data with Spark

• Exercise - Analyze data with Spark

Use 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

• Exercise - Use Delta Lake in Azure Synapse Analytics

Analyze data in a relational data warehouse

• Design a data warehouse schema

• Create data warehouse tables

• Load data warehouse tables

• Query a data warehouse

• Exercise - Explore a data warehouse

Build a data pipeline in Azure Synapse Analytics

• Understand pipelines in Azure Synapse Analytics

• Create a pipeline in Azure Synapse Studio

• Define data flows

• Run a pipeline

• Exercise - Build a data pipeline in Azure Synapse Analytics

Enquire about the Course

You can also reach out to us through the following options

Phone

+65-91709407

Email

info@empowerone.cloud

WhatsApp Channel