Azure Data Services
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.
is issued on the Luxoft Training form
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.
Target Audience
Backend / DB Developers, Architects, QAs, Analysts, ETL / Data / DWH Engineers.
Prerequisites
Development experience in SQL minimum 3 months.
Roadmap
- 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