Data Fundamental

Course Overview: This course provides a comprehensive introduction to Azure Data Fundamentals. It is designed for individuals seeking to understand core data concepts, data storage, and data processing in the cloud. The course is divided into modules, each focusing on different aspects of data management and analysis.

Modules:

1. Core Data Concepts
   • Definition and types of data
   • Data storage: relational and non-relational
   • Data classification: structured, semi-structured, and unstructured
   • Data in cloud computing: analytical and transactional systems
   • Roles and responsibilities of data professionals
   • Common database tools
2. Relational Data
   • Characteristics of relational databases
   • Atomicity, consistency, isolation, and durability (ACID properties)
   • Examples of relational databases: SQL Server, PostgreSQL, Oracle DB
3. Non-Relational Data
   • Characteristics and flexibility of non-relational databases
   • Examples of non-relational databases: JSON, NoSQL
4. Data Processing Solutions
   • Analytical systems: data analysis, decision support, complex queries
   • Transactional systems: real-time processing, high volume data, accuracy
5. Data Roles and Responsibilities
   • Database administrators: tasks and tools
   • Data engineers: tasks and tools
   • Data analysts: tasks and tools