買這商品的人也買了...
-
JavaScript 大全, 6/e (JavaScript: The Definitive Guide: Activate Your Web Pages, 6/e)$1,200$948 -
$653算法導論, 3/e (Introduction to Algorithms, 3/e) -
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 -
$2,077SQL for Data Analysis: Advanced Techniques for Transforming Data Into Insights (Paperback) -
使用 Python 取代 Excel VBA 的 10堂課$520$411 -
簡報美學｜簡報x設計x呈現$520$411 -
【圖解】從入門到精通 Excel ╳ Python 資料處理術：搭配工作實務場景，輕鬆學會除錯、擷取、排序、彙整指定數據，製作QR碼也沒問題$500$395 -
動手就能上手 - 看 Excel VBA 學 Python 資料處理自動化$880$695 -
PHP 錦囊妙計 (PHP Cookbook: Modern Code Solutions for Professional Developers)$880$695 -
機器學習 : 最強入門邁向 AI 高手 王者歸來$1,080$853
相關主題
商品描述
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
作者簡介
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.
