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 types.
- Common business drivers for modern data solutions.
- Key characteristics and essential terminology of big data.
Database Fundamentals
- Core concepts of relational databases, including tables, rows, columns, and keys.
- Utilization of SQL for data retrieval and management.
- Basic data modeling and simple schema design.
- Transactions, consistency, and reliability from a practical perspective.
Choosing Between Relational and NoSQL Systems
- Differences between relational and NoSQL databases.
- High-level overview of document, key-value, column, and graph models.
- Strengths, limitations, and trade-offs of each approach.
- Aligning database choices with common business requirements.
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.
- Batch and stream processing concepts.
- 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 interact with 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
