{"title":"Rui Machado","description":"","products":[{"product_id":"analytics-engineering-with-sql-and-dbt-building-meaningful-data-models-at-scale-paperback","title":"Analytics Engineering with SQL and Dbt: Building Meaningful Data Models at Scale - Paperback","description":"\u003cp\u003e\u003c\/p\u003e\u003cp\u003eWith 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. \u003c\/p\u003e\u003cp\u003e Authors Rui Machado from Monstarlab and Hélder 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. \u003c\/p\u003e\u003cp\u003e With this book, you'll learn: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eWhat dbt is and how a dbt project is structured \u003c\/li\u003e\n\u003cli\u003eHow dbt fits into the data engineering and analytics worlds \u003c\/li\u003e\n\u003cli\u003eHow to collaborate on building data models \u003c\/li\u003e\n\u003cli\u003eThe main tools and architectures for building useful, functional data models \u003c\/li\u003e\n\u003cli\u003eHow to fit dbt into data warehousing and laking architecture \u003c\/li\u003e\n\u003cli\u003eHow to build tests for data transformations \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":51319161618655,"sku":"9781098142384","price":65.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0813\/8958\/4607\/files\/o637d0voXq9781098142384.webp?v=1788366322"},{"product_id":"advanced-sql-implementing-modern-data-solutions-and-ml-applications-paperback","title":"Advanced SQL: Implementing Modern Data Solutions and ML Applications - Paperback","description":"\u003cp\u003e\u003c\/p\u003e\u003cp\u003eSQL has evolved from a querying language for relational databases to a foundational tool for building scalable, modern data solutions across real-time analytics, machine learning workflows, and even generative AI applications. \u003cem\u003eAdvanced SQL\u003c\/em\u003e moves beyond SELECT statements and taps 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 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. Data and analytics engineers, analysts, and scientists will get hands-on guidance on expanding their SQL skills into emerging workflows and real-world production systems.\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e\u003cul\u003e \u003cli\u003eUse SQL to design and deploy modern, end-to-end data architectures \u003c\/li\u003e\n\u003cli\u003eIntegrate SQL with data lakes, stream processing, and cloud platforms \u003c\/li\u003e\n\u003cli\u003eApply SQL in feature engineering and ML model deployment \u003c\/li\u003e\n\u003cli\u003eMaster pipe syntax and other advanced query features \u003c\/li\u003e\n\u003cli\u003eLeverage SQL to build GenAI-ready data applications and pipelines \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":51319167746271,"sku":"9798341627482","price":86.38,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0813\/8958\/4607\/files\/60m68L0eLp9798341627482.webp?v=1788366334"}],"url":"https:\/\/blackandbarhe.com\/collections\/rui-machado.oembed","provider":"Black \u0026 Barhe Bookstore","version":"1.0","type":"link"}