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 databases, data platforms, and big data systems.
- Structured, semi-structured, and unstructured data.
- Common business drivers for modern data solutions.
- Big data characteristics 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 at a practical level.
Selecting Between Relational and NoSQL Systems
- Relational databases versus NoSQL databases.
- Document, key-value, column, and graph models at a high level.
- Strengths, limitations, and tradeoffs of each approach.
- Aligning database choices with common business needs.
Data Warehousing and Big Data Processing
- Purpose of data warehouses, data lakes, and lakehouse-style architectures.
- ETL and ELT concepts for moving and preparing data.
- Batch and stream processing concepts.
- High-level view 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 different scenarios.
- Common implementation challenges and strategies to reduce risk.
- Summary, recommendations, and next steps for further learning.
Requirements
- A general understanding of data, reports, and common 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