Get in Touch

Course Outline

Foundations of Data Platforms

  • What databases, data platforms, and big data systems are
  • 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 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

Testimonials (3)

Related Categories