{"title":"Rui Machado","description":null,"products":[{"product_id":"analytics-engineering-with-sql-and-dbt-book-rui-machado-9781098142384","title":"Analytics Engineering with SQL and Dbt","description":"With the shift from data warehouses to data lakes, data now lands in repositories before it's been transformed, enabling engineers to model raw data into clean, well-defined datasets. DBT (data build tool) helps you take data further. This practical book shows data analysts, data engineers, BI developers, and data scientists how to create a true self-service transformation platform through the use of dynamic SQL.  Authors Rui Machado from Monstarlab and Helder Russa from Jumia show you how to quickly deliver new data products by focusing more on value delivery and less on architectural and engineering aspects. If you know your business well and have the technical skills to model raw data into clean, well-defined datasets, you'll learn how to design and deliver data models without any technical influence.  With this book, you'll learn:  What DBT is and how a DBT project is structured How DBT fits into the data engineering and analytics worlds How to collaborate on building data models The main tools and architectures for building useful, functional data models How to fit DBT into data warehousing and laking architecture How to build tests for data transformations","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":49752929632529,"sku":"NGR9781098142384","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50897768513809,"sku":"CIN1098142381G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51019539939601,"sku":"NIN9781098142384","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51282856444177,"sku":"GOR014216135","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":51329963458833,"sku":"CIN1098142381VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1098142381.jpg?v=1751080614"},{"product_id":"advanced-sql-book-rui-machado-9798341627482","title":"Advanced SQL","description":"\u003cp\u003eSQL is no longer just a querying language for relational databases--it's a foundational tool for building scalable, modern data solutions across real-time analytics, machine learning workflows, and even generative AI applications. Advanced SQL shows data professionals how to move beyond conventional SELECT statements and tap into the full power of SQL as a programming interface for today's most advanced data platforms.\u003c\/p\u003e \u003cp\u003eWritten by seasoned data experts Rui Pedro Machado, Hélder Russa, and Pedro Esmeriz, this practical guide explores the role of SQL in streaming architectures (like Apache Kafka and Flink), data lake ecosystems, cloud data warehouses, and ML pipelines. Geared toward data engineers, analysts, scientists, and analytics engineers, the book combines hands-on guidance with architectural best practices to help you extend your SQL skills into emerging workloads and real-world production systems.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eUse SQL to design and deploy modern, end-to-end data architectures\u003c\/li\u003e \u003cli\u003eIntegrate SQL with data lakes, stream processing, and cloud platforms\u003c\/li\u003e \u003cli\u003eApply SQL in feature engineering and ML model deployment\u003c\/li\u003e \u003cli\u003eMaster pipe syntax and other advanced features for scalable, efficient queries\u003c\/li\u003e \u003cli\u003eLeverage SQL to build GenAI-ready data applications and pipelines\u003c\/li\u003e \u003c\/ul\u003e","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":53613267517713,"sku":"NGR9798341627482","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9798341627482.jpg?v=1780317105"}],"url":"https:\/\/www.worldofbooks.com\/en-gb\/collections\/author-books-by-rui-machado.oembed","provider":"World of Books ","version":"1.0","type":"link"}