SQL for Data Analysis: Advanced Techniques for Transforming Data Into Insights (Paperback)
            
暫譯: SQL 數據分析:將數據轉化為洞察的進階技術 (平裝本)
        
        Tanimura, Cathy
買這商品的人也買了...
- 
                
                   無瑕的程式碼-敏捷完整篇-物件導向原則、設計模式與 C# 實踐 (Agile principles, patterns, and practices in C#) 無瑕的程式碼-敏捷完整篇-物件導向原則、設計模式與 C# 實踐 (Agile principles, patterns, and practices in C#)$790$616
- 
                
                   大數據時代一定要會的 SQL 商業資料分析術 大數據時代一定要會的 SQL 商業資料分析術$680$578
- 
                
                   Working Effectively with Legacy Code : 管理、修改、重構遺留程式碼的藝術 (中文版) Working Effectively with Legacy Code : 管理、修改、重構遺留程式碼的藝術 (中文版)$720$562
- 
                
                   Data Science from Scratch|用 Python 學資料科學, 2/e (中文版)(Data Science from Scratch: First Principles with Python, 2/e) Data Science from Scratch|用 Python 學資料科學, 2/e (中文版)(Data Science from Scratch: First Principles with Python, 2/e)$680$537
- 
                
                   $477Rust 權威指南 (The Rust Programming Language (Covers Rust 2018)) $477Rust 權威指南 (The Rust Programming Language (Covers Rust 2018))
- 
                
                   再強一點:用 Go語言完成六個大型專案 再強一點:用 Go語言完成六個大型專案$780$616
- 
                
                   SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2/e (Paperback) SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2/e (Paperback)$2,360$2,242
- 
                
                   JavaScript 無所不在 (JavaScript Everywhere: Building Cross-Platform Applications with Graphql, React, React Native, and Electron) JavaScript 無所不在 (JavaScript Everywhere: Building Cross-Platform Applications with Graphql, React, React Native, and Electron)$580$458
- 
                
                   $1,400Network Programming with Go: Learn to Code Secure and Reliable Network Services from Scratch $1,400Network Programming with Go: Learn to Code Secure and Reliable Network Services from Scratch
- 
                
                   $1,472Graphql in Action (Paperback) $1,472Graphql in Action (Paperback)
- 
                
                   Introducing .Net for Apache Spark: Distributed Processing for Massive Datasets Introducing .Net for Apache Spark: Distributed Processing for Massive Datasets$1,995$1,890
- 
                
                   SQL Pocket Guide: A Guide to SQL Usage 4th 版本 SQL Pocket Guide: A Guide to SQL Usage 4th 版本$1,235$1,170
- 
                
                   Python 資料分析必備套件!Pandas 資料清理、重塑、過濾、視覺化 (Pandas 1.x Cookbook, 2/e) Python 資料分析必備套件!Pandas 資料清理、重塑、過濾、視覺化 (Pandas 1.x Cookbook, 2/e)$780$616
- 
                
                   黑帽 Python|給駭客與滲透測試者的 Python 開發指南, 2/e (Black Hat Python : Python Programming for Hackers and Pentesters, 2/e) 黑帽 Python|給駭客與滲透測試者的 Python 開發指南, 2/e (Black Hat Python : Python Programming for Hackers and Pentesters, 2/e)$450$356
- 
                
                   Spring REST API 開發與測試指南|使用 Swagger、HATEOAS、JUnit、Mockito、PowerMock、Spring Test Spring REST API 開發與測試指南|使用 Swagger、HATEOAS、JUnit、Mockito、PowerMock、Spring Test$580$493
- 
                
                   $2,385Fundamentals of Data Engineering: Plan and Build Robust Data Systems (Paperback) $2,385Fundamentals of Data Engineering: Plan and Build Robust Data Systems (Paperback)
- 
                
                   Linux 網路內功修煉 - 徹底了解底層原理及高性能架構 Linux 網路內功修煉 - 徹底了解底層原理及高性能架構$780$663
- 
                
                   演算法生存指南(書況差限門市銷售) 演算法生存指南(書況差限門市銷售)$800$632
- 
                
                   PHP 錦囊妙計 (PHP Cookbook: Modern Code Solutions for Professional Developers) PHP 錦囊妙計 (PHP Cookbook: Modern Code Solutions for Professional Developers)$880$695
- 
                
                   機器學習 : 最強入門邁向 AI 高手 王者歸來 機器學習 : 最強入門邁向 AI 高手 王者歸來$1,080$853
- 
                
                   讓 AI 好好說話!從頭打造 LLM (大型語言模型) 實戰秘笈 讓 AI 好好說話!從頭打造 LLM (大型語言模型) 實戰秘笈$680$537
- 
                
                   日式 RPG 編年史:從 DQ 到 FF,角色扮演遊戲敘事手法完全剖析 日式 RPG 編年史:從 DQ 到 FF,角色扮演遊戲敘事手法完全剖析$380$300
- 
                
                   軟體工程師的英語使用守則:English for Developers 軟體工程師的英語使用守則:English for Developers$420$357
- 
                
                   內行人才知道的系統設計面試指南 第二輯 (System Design Interview – An Insider's Guide: Volume 2) 內行人才知道的系統設計面試指南 第二輯 (System Design Interview – An Insider's Guide: Volume 2)$820$648
- 
                
                   Think Python|學習程式設計的思考概念, 3/e (Think Python: How to Think Like a Computer Scientist, 3/e) Think Python|學習程式設計的思考概念, 3/e (Think Python: How to Think Like a Computer Scientist, 3/e)$720$569
商品描述
With the explosion of computing power, thanks to analytic databases and cloud data warehouses, SQL has become an even more robust and flexible tool for the savvy analyst or data scientist. This practical book reveals hidden ways to get the most out of your SQL workflow.
You'll learn how to use both common and exotic SQL functions such as joins, window functions, subqueries, and regular expressions in new, innovative ways-as well as how to combine SQL techniques to accomplish your goals faster, with more understandable code. If you work with SQL databases, this is a must-have reference.
SQL for Data Analysis covers useful applications such as:
- Cohort analysis
- Text analysis
- Anomaly detection
- Time series analysis
- Experiment analysis
- Creating complex datasets for further exploration in statistical and visualization tools
- And more
商品描述(中文翻譯)
隨著計算能力的爆炸性增長,得益於分析型資料庫和雲端資料倉儲,SQL 已成為精明的分析師或資料科學家更強大且靈活的工具。本書揭示了如何充分利用您的 SQL 工作流程的隱藏方法。
您將學習如何以全新且創新的方式使用常見和不常見的 SQL 函數,例如聯接(joins)、視窗函數(window functions)、子查詢(subqueries)和正則表達式(regular expressions),以及如何結合 SQL 技術更快地達成目標,並撰寫更易於理解的程式碼。如果您使用 SQL 資料庫,這是一本必備的參考書。
《SQL for Data Analysis》涵蓋了以下有用的應用:
- 群體分析(Cohort analysis)
- 文本分析(Text analysis)
- 異常檢測(Anomaly detection)
- 時間序列分析(Time series analysis)
- 實驗分析(Experiment analysis)
- 創建複雜的數據集以便在統計和可視化工具中進一步探索
- 以及更多
作者簡介
Cathy Tanimura has a passion for connecting people and organizations to the data they need to make an impact. She has been analyzing data for over 20 years across a wide range of industries, from finance to B2B software to consumer services. She has experience analyzing data with SQL across most of the major proprietary and open source databases. She has built and managed data teams and data infrastructure at a number of leading tech companies. Cathy is also a frequent speaker at top conferences, on topics including building data cultures, data-driven product development, and inclusive data analysis.
作者簡介(中文翻譯)
Cathy Tanimura 對於將人們和組織與他們所需的數據連接起來充滿熱情,以便產生影響。她在金融、B2B 軟體到消費者服務等多個行業擁有超過 20 年的數據分析經驗。她在大多數主要的專有和開源數據庫中使用 SQL 進行數據分析。她曾在多家領先的科技公司建立和管理數據團隊及數據基礎設施。Cathy 也是多個頂尖會議的常客演講者,演講主題包括建立數據文化、數據驅動的產品開發以及包容性數據分析。
 
 
     
     
     
     
     
     
     
    
 
    
 
    