← Back to Skills Library

Azure Data Fundamentals

Information Technology > Cloud-based data access and sharing

Description

Microsoft Azure Data Fundamentals is a skill set that involves understanding and utilizing Microsoft's cloud-based data services. It starts with grasping core data concepts, such as relational and non-relational data types, and understanding basic data analytics. As proficiency increases, one learns to use tools like Azure Data Studio, implement data solutions on Azure, and manage data security. Advanced skills include managing and troubleshooting Azure data services, designing scalable data solutions, and using advanced analytics tools. At the expert level, one can administer large-scale Azure data solutions, handle complex data migration scenarios, and optimize the performance of Azure data services.

Stack

Microsoft Cloud

Expected Behaviors

✎
LEVEL 1

Fundamental Awareness

At the fundamental awareness level, individuals are expected to have a basic understanding of core data concepts. They should be familiar with different types of data, including relational and non-relational data, and understand the concept of data processing. However, they may not yet be able to apply this knowledge in practical situations.

🌱
LEVEL 2

Novice

Novices are expected to describe types of core data workloads and have an understanding of basic data analytics concepts. They should also have knowledge of Azure data services and their common uses. At this stage, they can start applying their knowledge in simple, well-defined contexts.

🌍
LEVEL 3

Intermediate

At the intermediate level, individuals should be proficient in using Azure Data Studio and be capable of implementing data solutions on Azure. They should understand data security components such as firewalls and network security groups. They can handle more complex tasks and solve problems with some degree of independence.

⭐
LEVEL 4

Advanced

Advanced users are expected to manage and troubleshoot Azure data services effectively. They should be proficient in designing and deploying scalable, highly available data solutions. They should also understand advanced data analytics concepts and tools. At this level, they can handle complex scenarios and provide guidance to less experienced colleagues.

🏆
LEVEL 5

Expert

Experts are expected to manage and administer large-scale Azure data solutions. They should be capable of designing and implementing complex data migration and transformation scenarios. They should have a deep understanding of performance tuning and optimization techniques for Azure data services. Experts are often seen as thought leaders and are capable of driving strategic decision-making.

Micro Skills

✎
LEVEL 1

Fundamental Awareness

Familiarity with the concept of databases
Understanding of data structures
Knowledge of basic data operations
Understanding of the difference between relational and non-relational data
Familiarity with examples of relational and non-relational data types
Basic knowledge of when to use relational vs non-relational data types
Understanding of how data is processed
Knowledge of basic data processing operations
Familiarity with the concept of data pipelines
🌱
LEVEL 2

Novice

Knowledge of batch processing
Understanding of data warehousing
Knowledge of real-time processing
Understanding of IoT data streams
Understanding of structured data
Understanding of unstructured data
Knowledge of data visualization tools
Understanding of data storytelling
Understanding of data mining techniques
Familiarity with data mining tools
Knowledge of descriptive analytics
Understanding of predictive analytics
Knowledge of prescriptive analytics
Knowledge of SQL Server on Azure
Understanding of Azure SQL Database features
Understanding of NoSQL databases on Azure
Knowledge of Azure Cosmos DB features
Understanding of big data storage on Azure
Familiarity with Azure Data Lake Storage features
Knowledge of analytics service on Azure
Understanding of Azure Synapse Analytics features
🌍
LEVEL 3

Intermediate

Understanding of Azure Data Studio interface
Ability to connect to databases and execute queries
Knowledge of how to use extensions
Understanding of how to create and configure storage accounts
Knowledge of how to import and export data in Azure
Ability to set up data replication and synchronization
Knowledge of how to configure firewalls for Azure services
Understanding of how to manage network security groups
Familiarity with Azure's data encryption methods
⭐
LEVEL 4

Advanced

Knowledge of Azure Monitor logs
Proficiency in using Azure Alerts
Understanding of Azure Service Health dashboard
Familiarity with Azure Resource Health
Proficiency in configuring Azure Load Balancer
Knowledge of Azure Traffic Manager routing methods
Understanding of Azure Availability Zones
Proficiency in using Azure Availability Sets
Knowledge of data warehousing concepts in Azure Synapse
Proficiency in using Azure Databricks
Understanding of Azure Machine Learning Studio
Proficiency in using Azure Cognitive Services
🏆
LEVEL 5

Expert

Understanding of Azure Storage Service
Proficiency in automating tasks using Azure CLI, PowerShell, and the Azure portal
Understanding of disaster recovery and high availability strategies
Knowledge of various data migration tools such as Azure Data Factory and DMS
Ability to perform ETL operations
Understanding of data transformation techniques
Ability to optimize queries for improved performance
Understanding of indexing and partitioning strategies
Knowledge of performance monitoring tools and techniques

Skill Overview

  • Expert2 years experience
  • Micro-skills60
  • Roles requiring skill1

Sign up to prepare yourself or your team for a role that requires Azure Data Fundamentals.

LoginSign Up