Practical SQL : A Beginner's Guide to Storytelling with Data, 2/e (Paperback)
暫譯: 實用 SQL：初學者的數據敘事指南，第二版（平裝本）

Debarros, Anthony

Practical SQL : A Beginner's Guide to Storytelling with Data, 2/e (Paperback)
  • 出版商: No Starch Press
  • 出版日期: 2022-01-25
  • 售價: $1,480
  • 貴賓價: 9.5 折 $1,406
  • 語言: 英文
  • 頁數: 392
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1718501064
  • ISBN-13: 9781718501065
  • 相關分類: SQL

    • 立即出貨 (庫存=1)

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

相關主題

商品描述

Second edition of the best-selling Practical SQL. An approachable guide to programming in SQL (Structured Query Language) that will teach even beginning programmers how to build powerful databases and analyze data to find meaningful information.

Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language) written by longtime professional journalist Anthony DeBarros. SQL is the primary tool that programmers, web developers, researchers, journalists, and others use to explore data in a database. DeBarros focuses on using SQL to find the story in data, with the aid of the popular open-source database PostgreSQL and the pgAdmin interface.

This thoroughly revised second edition includes a new chapter describing how to set up PostgreSQL and more extensive discussion of pgAdmin's best features. The author has also added a chapter on the JSON data format that shows readers how to store and query JSON data. DeBarros has also updated the data in the book throughout, added coverage of additional topics, and perfected the book's examples.

Readers love DeBarros's use of exercises and real-world examples that demonstrate how to:

- Create databases and related tables using your own data
- Correctly define data typesAggregate, sort, and filter data to find patterns
- Clean their data and transfer data as text files
- Create advanced queries and automate tasks

This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL.

商品描述(中文翻譯)

第二版暢銷書《實用 SQL》。這是一本易於理解的 SQL（結構化查詢語言）編程指南，甚至可以教會初學者如何建立強大的資料庫並分析數據以尋找有意義的信息。

《實用 SQL》是一本由資深專業記者安東尼·德巴羅斯（Anthony DeBarros）撰寫的易於理解且節奏快速的 SQL（結構化查詢語言）指南。SQL 是程序員、網頁開發者、研究人員、記者及其他人用來探索資料庫中數據的主要工具。德巴羅斯專注於使用 SQL 從數據中發掘故事，並輔以流行的開源資料庫 PostgreSQL 和 pgAdmin 介面。

這本徹底修訂的第二版包含了一個新章節，描述如何設置 PostgreSQL，並對 pgAdmin 的最佳功能進行了更廣泛的討論。作者還新增了一個關於 JSON 數據格式的章節，向讀者展示如何存儲和查詢 JSON 數據。德巴羅斯還在全書中更新了數據，增加了額外主題的涵蓋，並完善了書中的範例。

讀者喜愛德巴羅斯使用練習和真實案例來展示如何：

- 使用自己的數據創建資料庫和相關表格
- 正確定義數據類型，聚合、排序和過濾數據以尋找模式
- 清理數據並將數據轉換為文本文件
- 創建高級查詢並自動化任務

這本書使用 PostgreSQL，但 SQL 語法適用於許多資料庫應用程序，包括 Microsoft SQL Server 和 MySQL。

作者簡介

Anthony DeBarros is a longtime journalist who has combined his interests in data analysis, coding, software product development, and storytelling for much of his career. He is a data news editor for The Wall Street Journal, focusing on topics such as the economy, trade, the U.S. Census, and politics. He previously held positions with USA TODAY, the Poughkeepsie Journal, and the DocumentCloud project for Investigative Reporters and Editors. His work has received multiple honors, including a prestigious Silver Baton from the Alfred I. duPont-Columbia University Awards.

作者簡介(中文翻譯)

安東尼·德巴羅斯是一位資深的記者，他在職業生涯中結合了對數據分析、編程、軟體產品開發和故事講述的興趣。他是《華爾街日報》的數據新聞編輯，專注於經濟、貿易、美國人口普查和政治等主題。他曾在《今日美國》（USA TODAY）、《波基普西日報》（Poughkeepsie Journal）以及調查記者與編輯協會的DocumentCloud專案中擔任職位。他的作品獲得多項榮譽，包括阿爾弗雷德·I·杜邦-哥倫比亞大學獎的著名銀色指揮棒。

類似商品