Sql data engineering etl von mondal masud (2 Ergebnisse)
Sprache: Englisch
Verlag: Independently Published Apr 2026, 2026
Serie: Data Engineering with Python Series, Buch 1 von 2. Buch 1 von 2 - Data Engineering with Python Series
- Softcover
Anbieter: AHA-BUCH GmbH, Einbeck, DeutschlandAHA-BUCH GmbH
Verkäufer/-in kontaktierenVerkäufer/-in mit 5 SternenZustand: Neu
EUR 26,05
EUR 60,94 VersandVersand von Deutschland nach USAAnzahl: 2 verfügbar
Taschenbuch. Zustand: Neu. Neuware - Stop Learning. Start Building. Become Job-Ready in Data Engineering.Data engineering is one of the fastest-growing careers in tech - but most resources teach theory, not real-world skills. This book is different.Instead of long explanations, you will build 12 complete, real-world data enginee…ring projects using Python and SQL. Every project simulates a genuine business scenario, follows a professional structure, and gives you something tangible to show employers.What You Will BuildWorking through this book, you will create end-to-end data pipelines including CSV and file-based ingestion systems, API data pipelines with error handling, data cleaning and validation workflows, JSON to SQL transformation pipelines, a star schema data warehouse, reporting data marts for analytics, e-commerce and log processing pipelines, incremental loading systems, fault-tolerant and reliable pipelines, performance-optimized data workflows, and automated testing for data quality.Learn by Doing - Not Just ReadingEvery project follows the same professional structure: business problem, pipeline architecture, step-by-step implementation, working code, expected output, resume-ready bullet points, and interview questions. You won't just understand the concepts - you will know how to apply them.Become Job-ReadyThis book is designed to help you build a strong GitHub portfolio, write powerful resume project points, answer real data engineering interview questions with confidence, and develop the end-to-end thinking that employers are looking for. By the last page, you will have practical, demonstrable experience that sets you apart from other candidates.Who This Book Is ForThis book is written for beginners starting a career in data engineering, developers and software engineers transitioning into data roles, QA and automation engineers looking to upskill, and anyone who learns best through hands-on, project-based work. Basic knowledge of Python and SQL is all you need to get started.Why This Book Is DifferentNo unnecessary theory. No long academic explanations. No abstract concepts disconnected from practice. Only real projects, practical learning, and job-focused skills built through doing.Your Learning PathStart with simple file-based pipelines. Progress through API ingestion, data warehousing, and analytics systems. Finish with production-ready patterns including incremental loading, fault tolerance, performance optimization, and automated testing.By the End of This Book, You Will Have: Built 12 real-world data engineering projects. Developed end-to-end pipeline thinking. Created a job-ready portfolio. And gained the confidence to apply for data engineering roles - not someday, but now.
Sprache: Englisch
Verlag: Independently Published Mai 2026, 2026
Serie: Data Engineering, Buch 8 von 2. Buch 8 von 2 - Data Engineering
- Softcover
Anbieter: AHA-BUCH GmbH, Einbeck, DeutschlandAHA-BUCH GmbH
Verkäufer/-in kontaktierenVerkäufer/-in mit 5 SternenZustand: Neu
EUR 33,10
EUR 62,52 VersandVersand von Deutschland nach USAAnzahl: 2 verfügbar
Taschenbuch. Zustand: Neu. Neuware - SQL for Data Engineering - ETL, Warehousing, Cloud Platforms & AI WorkflowsMost SQL books teach you to write queries. This one teaches you to build systems.If you know basic SQL but struggle to apply it in production environments, or you are preparing for data engineering interviews and want…experience beyond simple SELECT statements, this book was written for you.SQL for Data Engineering bridges the gap between tutorial SQL and the skills that data engineering roles actually demand - ETL pipelines, warehouse design, query optimization, and the architectural thinking that separates engineers who build reliable data systems from those who only query them.What you will learn: - Advanced querying - joins, CTEs, subqueries, window functions, and analytical SQL patterns- Data transformation - cleaning, standardisation, safe casting, and deduplication techniques- ETL architecture - incremental loading, staging patterns, Slowly Changing Dimensions, and idempotent pipeline design- Warehouse design - star schemas, dimensional modelling, partitioning, indexing, and materialised views- Performance optimisation - EXPLAIN ANALYZE, execution plans, query tuning, and production-grade optimisation- Semi-structured data - JSON and JSONB processing, schema drift handling, and event pipeline patterns- Cloud platforms - Snowflake, BigQuery, Redshift, and Databricks with practical SQL for each- AI workflows - prompt engineering for SQL tasks, AI-assisted debugging, and the risks of generated codeFour industry projects you will build: - E-Commerce Analytics Warehouse- SaaS Subscription Metrics Platform- Banking Transaction Fraud Monitoring System- Food Delivery ETL and Operations PipelineEach project covers a realistic business problem, complete ETL pipeline, warehouse schema, KPI queries, and interview preparation - designed to go directly into your portfolio.You also get: - Integrated interview Q&A in every chapter drawn from real hiring panels- Resume bullet points after every chapter and project- A complete career roadmap for aspiring data engineers- Appendices covering SQL functions, data types, troubleshooting, glossary, and a tool landscape guide.
