Get in Touch

Course Outline

Basics of Data Platforms

  • Defining databases, data platforms, and big data systems
  • Understanding structured, semi-structured, and unstructured data
  • Key business drivers necessitating modern data solutions
  • Characteristics of big data and essential terminology

Core Database Principles

  • Relational database elements such as tables, rows, columns, and keys
  • Utilizing SQL for data retrieval and management
  • Foundations of data modeling and simple schema design
  • Practical perspectives on transactions, consistency, and reliability

Selecting Between Relational and NoSQL Systems

  • Relational databases vs. NoSQL databases
  • High-level overview of document, key-value, column, and graph models
  • Advantages, limitations, and trade-offs of each approach
  • Aligning database selections with specific business requirements

Data Warehousing and Big Data Processing

  • Roles of data warehouses, data lakes, and lakehouse architectures
  • ETL and ELT concepts for data movement and preparation
  • Concepts of batch and stream processing
  • Overview of distributed storage and processing mechanisms

Governance, Security, and Data Integrity

  • Essential governance principles, ownership structures, and stewardship
  • Considerations for access control, privacy, and security
  • Common data quality challenges and strategies for improvement
  • Compliance standards and responsible data usage in corporate settings

Practical Applications and Course Conclusion

  • Typical use cases in reporting, analytics, and operational systems
  • Analyzing example architectures for diverse scenarios
  • Common implementation hurdles and strategies for risk mitigation
  • Summary, actionable recommendations, and pathways for continued learning

Requirements

  • A foundational understanding of data, reporting mechanisms, and standard business information workflows
  • Practical experience utilizing spreadsheets, reports, or business applications that handle data
  • Basic familiarity with technical, analytical, or business system operations

Target Audience

  • Business analysts and reporting specialists
  • IT personnel, developers, and system support teams
  • Managers and decision-makers engaged in data-centric projects
 14 Hours

Testimonials (2)

Upcoming Courses

Related Categories