Free book
Data Fundamentals and Practical Systems
Reading access
Free book
This book teaches practical data work from beginner to production thinking. It covers data concepts, SQL, modeling, pipelines, analytics, quality, governance, and how to build trustworthy data systems with clear examples.
Level: beginnerLanguage: EN EnglishRating: 0Reviews: 0
Book
Book contents
01Chapter 1: Introduction to Data Work and Data Thinking02Chapter 2: Structured, Semi-Structured, and Unstructured Data03Chapter 3: Tables, Rows, Keys, and Relationships04Chapter 4: SQL Basics for Reading and Writing Data05Chapter 5: Joins, Aggregations, and Query Patterns06Chapter 6: Data Modeling, Normalization, and Denormalization07Chapter 7: ETL, ELT, and Batch Data Pipelines08Chapter 8: Data Cleaning, Validation, and Quality Checks09Chapter 9: Warehouses, Lakes, and Lakehouse Thinking10Chapter 10: Metrics, Dashboards, and Analytics Workflows11Chapter 11: Partitioning, Indexing, and Performance Basics12Chapter 12: Governance, Lineage, Privacy, and Access Control13Chapter 13: Designing a Small Data Platform14Chapter 14: Building a Pipeline with SQL and Python15Chapter 15: Capstone: Create an Analytics Dataset16Chapter 16: Capstone: Test, Document, and Operate It17Appendix A: Commands and Workflow Cheat Sheet18Appendix B: Reference Architectures and Patterns19Appendix C: Common Mistakes and Fixes20Appendix D: Best Practices Summary
Reviews
No approved reviews are visible yet.
Featured Books
Discussion
0 commentsNo approved comments are visible yet. New community replies may wait for moderation.