Search courses 👉
Professional Course

Azure Data Services

Length
20 hours
Price
550 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
Length
20 hours
Price
550 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
This provider usually responds within 48 hours 👍

Course description

This training program aims to provide participants with comprehensive knowledge and practical skills related to Relational and non-Relational Azure Data Services.

The training will cover essential concepts, architectures, and usage scenarios of Azure Data Services, including Relational storages such as Azure Database for PostgreSQL and Managed SQL Database, as well as non-relational storages like Azure Blob Storage, Azure ADLS Gen 1/2, Event Hub, Cosmos DB, Redis Cache, Table Storage, and File Storage. Additionally, participants will learn how to effectively copy data between these services using Azure Data Factory, enabling them to efficiently manage and integrate data across different storage solutions.

Upcoming start dates

1 start date available

Start Anytime!

  • Self-paced Online
  • Online
  • English

Who should attend?

Prerequisites

Development experience in SQL minimum 3 months.

Training content

  • Module 1: Intro and certification motivation. Theory 60% Practice 40%, 2 hours.

- Azure Data Services Certification

- Azure Data Services Overview

- Azure Data Services Architecture

- Azure Data Services Pricing

- Azure Data Services Monitoring

- Azure Data Services Integration

  • Module 2: Relational storages. Azure Database for PostgreSQL. Theory 60% Practice 40%, 2 hours.

- Starting with Azure Database for PostgreSQL

- Accessing Azure Database for PostgreSQL

- DDL (Data Definition Language) and DML (Data Manipulation Language) with SQL

- Read path

- Write path

- Partitioning

- Replication

- Use cases

  • Module 3: Azure Relational storages. Managed SQL Database and SQL Managed Instance Theory 60% Practice 40%, 2 hours.

- Starting with Azure SQL Database

- Accessing Azure SQL Database

- DDL (Data Definition Language) and DML (Data Manipulation Language) with SQL

- Read path

- Write path

- Partitioning

- Replication

- Use cases

  • Module 4: Non-Relational. Azure Blob Storage. Theory 60% Practice 40%, 2 hours.

- Starting with Azure Blob Storage

- Accessing Azure Blob Storage

- Upload/Download files

- Read path

- Write path

- Replication

- Use cases

  • Module 5: Non-Relational. Azure ADLS Gen 1/2. Theory 60% Practice 40%, 2 hours.

- Why we need Azure ADLS Gen 1/2

- Starting with Azure ADLS Gen 1/2

- Accessing Azure ADLS Gen 1/2

- Upload/Download files

- Read path

- Write path

- Partitioning

- Replication

  • Module 6: Ingestion with Data Factory. RDBMS => ADSL. Theory 60% Practice 40%, 2 hours.

- Starting with Azure Data Factory

- Accessing Azure Data Factory

- Creating a pipeline

- Creating a dataset

- Creating a linked service

- Creating a trigger

  • Module 7: Non-Relational. Event Hub. Theory 60% Practice 40%, 2 hours.

- Starting with Azure Event Hub

- Accessing Azure Event Hub

- Creating a topic

- Writing to a topic

- Reading from a topic

- Replication

- Use cases

  • Module 8: Ingestion with Data Factory. Event Hub => ADSL Gen 2. Theory 60% Practice 40%, 2 hours.

- Starting with Azure Data Factory

- Accessing Azure Data Factory

- Creating a pipeline

  • Module 9: Non-Relational. Cosmos DB. Cassandra API. Theory 60% Practice 40%, 2 hours.

- Starting with Azure Cosmos DB

- Accessing Azure Cosmos DB

- Creating a database

- Creating a table

- Writing to a table

- Reading from a table

- Replication

- Use cases

  • Module 10: Non-Relational. Other storages: Redis Cache, Table Storage, File Storage. Theory 60% Practice 40%, 2 hours.

- Starting and accessing with Azure Redis Cache

- Creating, Writing and Reading a cache

- Replication

- Use cases

- Starting and accessing with Azure Table Storage

- Creating, Writing and Reading a table

- Replication

- Use cases

- Starting and accessing with Azure File Storage

- Creating, Writing and Reading a file

- Replication

- Use cases

Certification / Credits

Objectives

  • Understand Azure Data Services Certification processes and gain knowledge of Azure Data Services overview, architecture, pricing, monitoring, and integration capabilities.
  • Develop proficiency in relational storages, specifically Azure Database for PostgreSQL and Azure SQL Database, covering topics such as accessing, SQL language, read/write paths, partitioning, replication, and use cases.
  • Gain expertise in non-relational storages like Azure Blob Storage, Azure ADLS Gen 1/2, Azure Event Hub, Azure Cosmos DB with Cassandra API, and other storages such as Azure Redis Cache, Azure Table Storage, and Azure File Storage. Learn how to start, access, and perform operations like file upload/download, reading/writing, plus understanding replication and use cases for each storage solution.
  • Learn how to effectively copy data between Relational and Non-Relational Data Services services using Azure Data Factory, enabling them to efficiently manage and integrate data across different storage solutions.

Quick stats about Luxoft Training Center?

More than 200 training courses

Conducted over 1,500 training sessions

Customized training solutions for business

Contact this provider

Contact course provider

Fill out your details to find out more about Azure Data Services.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Luxoft Training Center
Warsaw Spire, plac Europejski 1
00-844 Warsaw

Luxoft Training Center

Luxoft Training Center — an essential part of the global technology leader, Luxoft, a DXC Technology Company. We play a pivotal role in propelling B2B businesses forward by delivering customized training solutions. Emphasizing the significance of learning and employee development,...

Read more and show all training delivered by this supplier

Ads