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
Data Platform Foundations
- Definitions of databases, data platforms, and big data systems.
- Structured, semi-structured, and unstructured data types.
- Key business drivers for modern data solutions.
- Essential characteristics and terminology of big data.
Database Fundamentals
- Core relational database concepts, including tables, rows, columns, and keys.
- The use of SQL for data retrieval and management.
- Basics of data modeling and simple schema design.
- Practical aspects of transactions, consistency, and reliability.
Selecting Between Relational and NoSQL Systems
- Comparison of relational databases and NoSQL databases.
- Overview of document, key-value, column, and graph models.
- Strengths, limitations, and tradeoffs of each approach.
- Aligning database choices with common business requirements.
Data Warehousing and Big Data Processing
- The roles of data warehouses, data lakes, and lakehouse architectures.
- ETL and ELT concepts for data movement and preparation.
- Concepts of batch and stream processing.
- A high-level perspective on distributed storage and processing.
Governance, Security, and Data Quality
- Fundamental governance principles, ownership, and stewardship.
- Considerations for access control, privacy, and security.
- Common data quality issues and practical methods for improvement.
- Compliance and responsible data usage in business contexts.
Practical Applications and Course Wrap-Up
- Typical use cases in reporting, analytics, and operational systems.
- Review of example architectures for various scenarios.
- Common implementation challenges and strategies for risk reduction.
- Summary, recommendations, and next steps for further learning.
Requirements
- A fundamental understanding of data, reports, and standard business information flows.
- Experience working with spreadsheets, reports, or business applications that utilize data.
- Basic experience in technical, analytical, or business systems.
Target Audience
- Business analysts and reporting specialists.
- IT personnel, developers, and system support staff.
- Managers and decision-makers involved in data-centric 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
