Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Foundations of Data Platforms
- Understanding what databases, data platforms, and big data systems are.
- Structured, semi-structured, and unstructured data types.
- Common business drivers for modern data solutions.
- Characteristics of big data and essential terminology.
Database Fundamentals
- Relational database concepts, including tables, rows, columns, and keys.
- How SQL is utilized to retrieve and manage data.
- Basic data modeling and simple schema design.
- Transactions, consistency, and reliability from a practical perspective.
Selecting Between Relational and NoSQL Systems
- Comparison of relational databases versus NoSQL databases.
- Overview of document, key-value, column, and graph models.
- Strengths, limitations, and tradeoffs of each approach.
- Aligning database choices with common business needs.
Data Warehousing and Big Data Processing
- The purpose of data warehouses, data lakes, and lakehouse-style architectures.
- ETL and ELT concepts for data movement and preparation.
- Concepts of batch and stream processing.
- A high-level overview of distributed storage and processing.
Governance, Security, and Data Quality
- Basic governance principles, ownership, and stewardship.
- Access control, privacy, and security considerations.
- Common data quality issues and practical improvement methods.
- Compliance and responsible data use in business environments.
Practical Applications and Course Wrap-Up
- Typical use cases in reporting, analytics, and operational systems.
- Reviewing example architectures for various scenarios.
- Common implementation challenges and strategies to mitigate risk.
- Summary, recommendations, and next steps for further learning.
Requirements
- A general understanding of data, reports, and standard business information flows.
- Experience using spreadsheets, reports, or business applications that handle data.
- Basic technical, analytical, or business systems experience.
Audience
- Business analysts and reporting professionals.
- IT staff, developers, and system support personnel.
- Managers and decision-makers involved in data-related projects.
14 Hours
Testimonials (2)
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
Hands on exercises. Class should have been 5 days, but the 3 days helped to clear up a lot of questions that I had from working with NiFi already
