Advanced SQL: Implementing Modern Data Solutions and ML Applications
暫譯: 進階 SQL：實現現代數據解決方案與機器學習應用
Machado, Rui, Russa, Helder, Esmeriz, Pedro
商品描述
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
商品描述(中文翻譯)
SQL 不再僅僅是關聯資料庫的查詢語言——它已成為構建可擴展的現代數據解決方案的基礎工具，涵蓋即時分析、機器學習工作流程，甚至生成式 AI 應用程式。《進階 SQL》向數據專業人士展示如何超越傳統的 SELECT 語句，充分發揮 SQL 作為當今最先進數據平台的程式介面的全部潛力。
本書由資深數據專家 Rui Pedro Machado、Hélder Russa 和 Pedro Esmeriz 撰寫，這本實用指南探討了 SQL 在串流架構（如 Apache Kafka 和 Flink）、數據湖生態系統、雲端數據倉庫和機器學習管道中的角色。針對數據工程師、分析師、科學家和分析工程師，本書結合實務指導與架構最佳實踐，幫助您將 SQL 技能擴展到新興工作負載和實際生產系統中。
- 使用 SQL 設計和部署現代的端到端數據架構
- 將 SQL 與數據湖、串流處理和雲端平台整合
- 在特徵工程和機器學習模型部署中應用 SQL
- 精通管道語法及其他可擴展、高效查詢的進階功能
- 利用 SQL 構建適合生成式 AI 的數據應用程式和管道
