買這商品的人也買了...
-
JavaScript 大全, 6/e (JavaScript: The Definitive Guide: Activate Your Web Pages, 6/e)$1,200$948 -
$653算法導論, 3/e (Introduction to Algorithms, 3/e) -
Excel VBA 經典程式碼：一行抵萬行「偷懶程式碼」應用大全 (上)$620$484 -
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)$580$458 -
編譯器設計, 2/e (Engineering a Compiler, 2/e)$719$683 -
SQL for Data Analysis: Advanced Techniques for Transforming Data Into Insights (Paperback)$2,261$2,142 -
使用 Python 取代 Excel VBA 的 10堂課$520$390 -
簡報美學｜簡報x設計x呈現$520$390 -
【圖解】從入門到精通 Excel ╳ Python 資料處理術：搭配工作實務場景，輕鬆學會除錯、擷取、排序、彙整指定數據，製作QR碼也沒問題$500$395 -
SQL 學習手冊｜資料建立、維護與檢索, 3/e (Learning SQL: Generate, Manipulate, and Retrieve Data, 3/e)$620$490 -
動手就能上手 - 看 Excel VBA 學 Python 資料處理自動化$880$695 -
PHP 錦囊妙計 (PHP Cookbook: Modern Code Solutions for Professional Developers)$880$695 -
機器學習 : 最強入門邁向 AI 高手 王者歸來$1,080$853 -
Think Python｜學習程式設計的思考概念, 3/e (Think Python: How to Think Like a Computer Scientist, 3/e)$720$569
相關主題
商品描述
If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.
The updated edition describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.
- Quickly look up how to perform specific tasks using SQL
- Apply the book's syntax examples to your own queries
- Update SQL queries to work in five different database management systems
- NEW: Connect Python and R to a relational database
- NEW: Look up frequently asked SQL questions in the How Do I? chapter
商品描述(中文翻譯)
如果您在日常工作中作為數據分析師、數據科學家或數據工程師使用 SQL，這本受歡迎的口袋指南是理想的在職參考資料。您將找到許多範例，解決語言的複雜性，以及在 Microsoft SQL Server、MySQL、Oracle Database、PostgreSQL 和 SQLite 中使用的 SQL 主要方面。
更新版描述了這些資料庫管理系統如何實現 SQL 語法，以便查詢和對資料庫進行更改。您將找到有關數據類型和轉換、正則表達式語法、窗口函數、樞紐分析和反樞紐分析等的詳細資訊。
- 快速查找如何使用 SQL 執行特定任務
- 將書中的語法範例應用於您自己的查詢
- 更新 SQL 查詢以在五種不同的資料庫管理系統中運行
- 新增：將 Python 和 R 連接到關聯資料庫
- 新增：在《我該如何做？》章節中查找常見的 SQL 問題
作者簡介
Alice Zhao is a data scientist who is passionate about teaching and making complex things easy to understand. She has taught numerous courses in SQL, Python and R as a senior data scientist at Metis and as a co-founder of Best Fit Analytics. She writes about analytics and pop culture on her blog, A Dash of Data. Her work has been featured in Huffington Post, Thrillist and Working Mother. Alice has also spoken at a variety of data science conferences, including Strata in New York City and ODSC in San Francisco, on topics ranging from natural language processing to data visualization.
作者簡介(中文翻譯)
Alice Zhao 是一位數據科學家，熱衷於教學並使複雜的事物變得易於理解。作為 Metis 的高級數據科學家及 Best Fit Analytics 的共同創辦人，她教授了多門 SQL、Python 和 R 課程。她在自己的部落格 A Dash of Data 上撰寫有關分析和流行文化的文章。她的作品曾在 Huffington Post、Thrillist 和 Working Mother 等媒體上刊登。Alice 也曾在多個數據科學會議上發表演講，包括在紐約市的 Strata 和在舊金山的 ODSC，主題涵蓋自然語言處理到數據可視化等範疇。
