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.
  • Practical aspects of transactions, consistency, and reliability.

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 tradeoffs of each approach.
  • Aligning database choices with common business needs.

Data Warehousing and Big Data Processing

  • Purposes of data warehouses, data lakes, and lakehouse-style architectures.
  • ETL and ELT concepts for moving and preparing data.
  • Concepts of batch and stream processing.
  • High-level perspective on distributed storage and processing.

Governance, Security, and Data Quality

  • Foundational governance principles, 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 different scenarios.
  • Addressing common implementation challenges and risk reduction strategies.
  • 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 work 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

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories