SQL Pocket Guide: A Guide to SQL Usage 4th 版本

Zhao, Alice

  • 出版商: O'Reilly
  • 出版日期: 2021-10-05
  • 定價: $1,260
  • 售價: 9.5$1,197
  • 語言: 英文
  • 頁數: 336
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1492090409
  • ISBN-13: 9781492090403
  • 相關分類: SQL
  • 立即出貨 (庫存=1)

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

商品描述

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,演講主題涵蓋自然語言處理到數據可視化等領域。