EAS-029 Azure Data Services | | Architecture and Design
EAS-029 Azure Data Services
Location
Online
Language
English
Code
EAS-029
250.00 *
Training for 7-8 or more people? Customize trainings for your specific needs
Description
This training provides an in-depth understanding of Relational and non-Relational Azure Data Services. Participants will learn the fundamentals of these services and gain knowledge on effectively copying data between them using Azure Data Factory.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
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
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. We will notify you when we schedule the next course on this topic