SQL Primer: An Accelerated Introduction to SQL Basics

Rahul Batra

SQL Primer: An Accelerated Introduction to SQL Basics
  • 出版商: Apress
  • 出版日期: 2018-06-16
  • 定價: $1,485
  • 售價: 9.0 折 $1,337
  • 語言: 英文
  • 頁數: 212
  • 裝訂: Paperback
  • ISBN: 1484235754
  • ISBN-13: 9781484235751
  • 相關分類: SQL

    • 立即出貨 (庫存 < 3)

商品描述

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. 

 
Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results.
 
With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.
 
What You'll Learn
  • Create and populate your own database tables
  • Read SQL queries and understand what they are doing
  • Execute queries that get correct results
  • Bring together related rows from multiple tables
  • Group and sort data in support of reporting applications
  • Get a grip on nulls, normalization, and other key concepts
  • Employ subqueries, unions, and other advanced features
Who This Book Is For
 
Anyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.
 
 

商品描述(中文翻譯)

建立對SQL的核心能力，以便能夠識別查詢的部分並撰寫簡單的SQL語句。SQL知識對於從事程式設計、資料科學和資料管理的任何人都是必不可少的。本書涵蓋了SQL的特性，這些特性在大多數數據庫供應商中都是標準化且常見的。您將獲得一個基礎知識，使您能夠更深入地了解可能遇到的任何數據庫產品的具體細節。

本書中的示例是在PostgreSQL和SQLite中進行的，但大部分示例都是平台無關的，並且適用於支持SQL的任何數據庫平台。在本書的早期，您將學習關於表設計的知識，了解鍵作為行識別符的重要性，以及基本的查詢操作。然後，您將進入更高級的主題，例如分組和總結，創建計算字段，根據業務需求從多個表中聯接數據等。在整本書中，您將接觸到一種基於集合的語言方法，並且將提供對於重要但微妙的主題（例如空值對查詢結果的影響）的良好基礎。

隨著數據科學的蓬勃發展，SQL已經重新成為全球技術人員和決策者必備的頂尖技能。《SQL Primer》將引導您從SQL的基礎知識到您需要具備扎實的工作知識的主流功能，這是一門重要的、以數據為導向的語言。

您將學到什麼：
- 創建並填充自己的數據庫表
- 閱讀SQL查詢並理解其功能
- 執行能夠獲得正確結果的查詢
- 從多個表中聯接相關行
- 以支持報表應用程序的方式對數據進行分組和排序
- 理解空值、規範化和其他關鍵概念
- 使用子查詢、聯合和其他高級功能

適合閱讀對象：
- 對SQL新手，尋求逐步指導以理解和撰寫SQL查詢。本書針對那些在工作中經常遇到SQL語句的人，並提供了一個在所有SQL數據庫系統中都有用的堅實基礎。程式設計師、數據庫管理員、數據科學家和業務分析師都可以從本書提供的SQL基礎知識中受益。

類似商品