Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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)
A journey through the Spark world: a very intense course. DSL, spark sql, partitioning vs bucketing for me.
Georgiana Elisabeta
Course - Apache Spark Fundamentals
Hands on exercises. Class should have been 5 days, but the 3 days helped to clear up a lot of questions that I had from working with NiFi already