SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2/e (Paperback)

Molinaro, Anthony, Graaf, Robert de

  • 出版商: O'Reilly
  • 出版日期: 2020-12-08
  • 定價: $2,300
  • 售價: 9.5$2,185
  • 語言: 英文
  • 頁數: 572
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1492077445
  • ISBN-13: 9781492077442
  • 相關分類: SQL
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

You may know SQL basics, but are you taking advantage of its expressive power? The new edition of this cookbook applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated book provides a framework to help you construct solutions and executable examples in several flavors of SQL--including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.

SQL programmers, analysts, data scientists, database administrators (DBAs)--and even relatively casual SQL users--will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.

The second edition includes:

  • Fully revised recipes that recognize the greater adoption of window functions in various SQL implementations
  • Additional recipes to take advantage of the widespread adoption of common table expressions for more readable, easier to implement solutions
  • Brand-new recipes to make SQL more useful for people, such as data scientists, who aren't database experts
  • Up-to-date SQL recipes throughout the book that cover the basics

商品描述(中文翻譯)

你可能已經熟悉 SQL 基礎知識,但你是否充分利用了它的表達能力?這本新版的食譜書以高度實用的方式應用結構化查詢語言(SQL),讓你可以創建和操作大量的數據存儲。基於實際案例,這本更新的書提供了一個框架,幫助你在多種 SQL 版本(包括 Oracle、DB2、SQL Server、MySQL 和 PostgreSQL)中構建解決方案和可執行的示例。

SQL 程序員、分析師、數據科學家、數據庫管理員(DBA)甚至相對輕鬆使用 SQL 的用戶都會發現《SQL Cookbook》是一個有價值的問題解決指南,可解決日常問題。沒有其他資源以這種獨特的格式提供食譜,幫助你解決日常困擾的 SQL 問題。

第二版包括:

- 完全修訂的食譜,認識到各種 SQL 實現中窗口函數的廣泛應用
- 額外的食譜,以利用常見表達式的廣泛應用,實現更易讀、更易實現的解決方案
- 全新的食譜,使 SQL 對於非數據庫專家(如數據科學家)更有用
- 全書涵蓋基礎知識的最新 SQL 食譜

作者簡介

Anthony Molinaro is a data scientist at Johnson & Johnson. In his current role he is a manager in the Observational Health Data Analytics group within Janssen R&D. His primary areas of research are nonparametric methods, time series analysis, and large scale database characterization and transformation. He is a member of the open science OHDSI community. Anthony holds a BA in Mathematics and an MA in Applied Mathematics & Statistics from CUNY Hunter College. He resides in NY with his wife, Georgia, and his two daughters, Kiki and Connie.

Robert de Graaf graduated as an Engineer, and worked in the Manufacturing industry after completing studies. While working as an Engineer, Robert discovered the power of statistics for solving real world problems, and completed a Master's in Statistics in time to benefit from the Data Science boom. He has worked for RightShip as their Senior Data Scientist since 2013, and is the author of Managing Your Data Science Projects.

作者簡介(中文翻譯)

Anthony Molinaro是Johnson & Johnson的數據科學家。在他目前的職位上,他是Janssen R&D的Observational Health Data Analytics團隊的經理。他的主要研究領域包括非參數方法、時間序列分析以及大規模數據庫的特徵和轉換。他是開放科學OHDSI社區的成員。Anthony擁有CUNY Hunter College的數學學士學位和應用數學與統計學碩士學位。他與妻子Georgia和兩個女兒Kiki和Connie居住在紐約。

Robert de Graaf畢業於工程師,完成學業後在製造業工作。在擔任工程師期間,Robert發現統計學在解決現實世界問題方面的力量,並及時完成了統計學碩士學位以受益於數據科學的蓬勃發展。自2013年以來,他一直在RightShip擔任高級數據科學家,並是《Managing Your Data Science Projects》的作者。