Practical SQL : A Beginner's Guide to Storytelling with Data, 2/e (Paperback)

Debarros, Anthony

  • 出版商: 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
  • 立即出貨 (庫存 < 3)

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

商品描述

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 是程序員、網絡開發人員、研究人員、記者和其他人在數據庫中探索數據時使用的主要工具。DeBarros 專注於使用 SQL 在數據中找到故事,並借助流行的開源數據庫 PostgreSQL 和 pgAdmin 接口。

這本全面修訂的第二版包括一個新章節,介紹如何設置 PostgreSQL,並更廣泛地討論了 pgAdmin 的最佳功能。作者還添加了一個關於 JSON 數據格式的章節,向讀者展示如何存儲和查詢 JSON 數據。DeBarros 還在整本書中更新了數據,增加了其他主題的內容,並完善了書中的示例。

讀者喜歡 DeBarros 使用練習和實際示例來演示以下內容:
- 使用自己的數據創建數據庫和相關表格
- 正確定義數據類型
- 聚合、排序和過濾數據以找到模式
- 清理數據並將數據轉換為文本文件
- 創建高級查詢並自動化任務

本書使用 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.

作者簡介(中文翻譯)

Anthony DeBarros是一位長期從事新聞工作的記者,他在整個職業生涯中結合了對數據分析、編碼、軟體產品開發和故事講述的興趣。他是《華爾街日報》的數據新聞編輯,專注於經濟、貿易、美國人口普查和政治等主題。他曾在《今日美國》、《波基普西日報》和《調查記者和編輯的文件雲計劃》等機構擔任職位。他的工作多次獲得榮譽,包括來自阿爾弗雷德·杜邦-哥倫比亞大學獎的傑出銀獎。