Get in Touch

Course Outline

Foundations of Data Platforms

  • Understanding databases, data platforms, and big data systems.
  • Distinguishing between structured, semi-structured, and unstructured data.
  • Identifying common business drivers for modern data solutions.
  • Understanding big data characteristics and essential terminology.

Database Fundamentals

  • Relational database concepts, including tables, rows, columns, and keys.
  • Utilizing SQL to retrieve and manage data.
  • Introduction to basic data modeling and simple schema design.
  • Understanding transactions, consistency, and reliability at a practical level.

Choosing Between Relational and NoSQL Systems

  • Comparing relational databases with NoSQL databases.
  • Overview of document, key-value, column, and graph models.
  • Evaluating the strengths, limitations, and trade-offs of each approach.
  • Aligning database choices with common business needs.

Data Warehousing and Big Data Processing

  • Understanding the purpose of data warehouses, data lakes, and lakehouse-style architectures.
  • Concepts of ETL and ELT for moving and preparing data.
  • Understanding batch and stream processing concepts.
  • High-level overview of distributed storage and processing.

Governance, Security, and Data Quality

  • Basic principles of governance, ownership, and stewardship.
  • Considerations for access control, privacy, and security.
  • 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 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 experience with technical, analytical, or business systems.

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 (2)

Upcoming Courses

Related Categories