Get in Touch

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 used to retrieve and manage data.
  • Basic data modeling and simple schema design.
  • Transactions, consistency, and reliability at a practical level.

Choosing 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.
  • Matching database choices to 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 ways to reduce risk.
  • Summary, recommendations, and next steps for further learning.

Requirements

  • A general understanding of data, reports, and typical 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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories