SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2/e (Paperback)
暫譯: SQL 食譜:所有 SQL 使用者的查詢解決方案與技術,第二版 (平裝)
Molinaro, Anthony, Graaf, Robert de
買這商品的人也買了...
-
$1,590$1,511 -
$2,050$1,948 -
$1,323Cryptography and Network Security: Principles and Practice, 7/e (IE-Paperback)
-
$2,043Practical Tableau: 100 Tips, Tutorials, and Strategies from a Tableau Zen Master
-
$1,420$1,349 -
$1,900$1,805 -
$580$458 -
$680$537 -
$1,378Social Media Data Mining and Analytics
-
$990Mastering Kali Linux for Advanced Penetration Testing: Secure your network with Kali Linux 2019.1 – the ultimate white hat hackers' toolkit, 3/e
-
$450$356 -
$1,650$1,568 -
$1,680Programming PHP: Creating Dynamic Web Pages 4/e
-
$1,995Learning SQL: Generate, Manipulate, and Retrieve Data, 3/e (Paperback)
-
$2,286$2,172 -
$2,520Javascript: The Definitive Guide: Master the World's Most-Used Programming Language, 7/e (Paperback)
-
$294$279 -
$2,800$2,660 -
$580$458 -
$894$849 -
$2,242SQL for Data Analysis: Advanced Techniques for Transforming Data Into Insights (Paperback)
-
$2,520Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter, 3/e (Paperback)
-
$880$695 -
$880$695 -
$1,080$853
商品描述
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 的基本知識,但您是否充分利用其表達能力?這本食譜的新版本採用高度實用的方法來處理結構化查詢語言(Structured Query Language, 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)觀察性健康數據分析小組的經理。他的主要研究領域包括非參數方法、時間序列分析以及大規模數據庫的特徵化和轉換。他是開放科學 OHDSI 社群的成員。安東尼擁有城市大學(CUNY Hunter College)的數學學士學位和應用數學與統計碩士學位。他與妻子喬治亞(Georgia)及兩個女兒基基(Kiki)和康妮(Connie)居住在紐約。
羅伯特·德·格拉夫(Robert de Graaf)以工程師身份畢業,並在完成學業後在製造業工作。在擔任工程師期間,羅伯特發現統計在解決現實世界問題中的力量,並在數據科學熱潮來臨之前完成了統計碩士學位。他自2013年以來一直在 RightShip 擔任高級數據科學家,並且是《管理您的數據科學項目》(Managing Your Data Science Projects)的作者。