Advanced SQL. Implementing Modern Data Solutions and ML Applications - Rui Machado;Hélder Russa;Pedro Esmeriz

SQL 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.

Written 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.

Use SQL to design and deploy modern, end-to-end data architectures
Integrate SQL with data lakes, stream processing, and cloud platforms
Apply SQL in feature engineering and ML model deployment
Master pipe syntax and other advanced features for scalable, efficient queries
Leverage SQL to build GenAI-ready data applications and pipelines