Use query tools such as Azure Data Studio or SQL Server Management Studio (SSMS) to connect to Azure SQL databases
Create storage accounts to store unstructured and semi-structured data. use Azure Data Studio to upload data to Azure
Manage identities, keys, and secrets across different data platform technologies using Azure Key Vault
Use the Azure CLI to generate Shared Access Signature (SAS). How access storage resources using SAS
Build ETL pipeline using Azure Data Factory. Create advanced transformation logic using Data Flows
Trigger a Data Pipeline based on storage events or specific
Transform data using Azure Synapse Analytics. Create external tables to read or write data to files in Azure Storage
Use T-SQL to query Relational Databases and data in Azure Storage
Description
Do you want to jump-start your career as an Azure Data Eeer
Welcome to the Definitive Guide to Data Eeering on Microsoft Azure.
In this course, you will learn how to use the extensive family of Azure Data Services to build a modern data and analytics platform.
I’ll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as an Azure Data Eeer.
By the you complete this course, you will be able to:
Architect a Data Solution on Azure
Integrate relational data and unstructured data
Build data processing pipelines using Azure Data Factory
Integrate and transform data from various data systems
Securely access data stores with Azure Key Vault and Azure role-based access control (Azure RBAC)
Perform exploratory data analysis with Azure Synapse Analytics
Manage your costs
The lectures in this course are hands-on and with lots of explanations.
I also use animations to break down complex topics.
There are SQL scripts and Jupyter notebooks that you can use to follow along easily.
You will be working closely with the documentation of Microsoft Azure as it is essential to know how to find the most up-to-date information about any service.
You will learn how to combine a range of Azure services to ingest, store and process data of all types and sizes from any data source.
Throughout this course, we will learn how to use and combine multiple Azure Services and tools, including:
Azure SQL Databases
