Sams Teach Yourself SQL in One Hour a Day, 5/e (Paperback)

Ryan Stephens, Ron Plew, Arie D. Jones

  • 出版商: SAMS
  • 出版日期: 2009-06-01
  • 定價: $1,700
  • 售價: 8.0$1,360
  • 語言: 英文
  • 頁數: 840
  • 裝訂: Paperback
  • ISBN: 0672330253
  • ISBN-13: 9780672330254
  • 相關分類: SQL
  • 立即出貨(限量) (庫存=1)

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

商品描述

The Fifth Edition of Sams Teach Yourself SQL in 21 Days

More than 48,000 sold!

 

In just one hour a day, you’ll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts:

 

  • Quickly apply essential SQL techniques in useful, real-world queries
  • Design trustworthy, high-performance databases
  • Manipulate your data with views and transactions
  • Leverage powerful features including stored procedures, triggers, and cursors
  • Work with new objects introduced with the latest SQL standards
  • Get practical, expert tips on implementing SQL in your business environment

 

Learn on your own time, at your own pace

  • No previous SQL or database experience required
  • Learn techniques that work with any current version of SQL
  • Discover how to write faster, more efficient queries
  • Secure your data using best practices from experienced database administrators
  • Build more powerful databases with features exclusive to Oracle SQL*Plus, Oracle PL/SQL, and Microsoft Transact-SQL
  • Write queries for the free, open source MySQL database
  • Embed your SQL code in other applications

 

Ryan Stephens and Ron Plew are President and VP of Perpetual Technologies, Inc. (PTI) in Indianapolis, IN, providing managed services and consulting for top database implementations running Oracle, SQL Server, and other leading technologies. They taught for 5+ years as adjunct professors at Indiana University-Purdue University. Their books include Sams Teach Yourself SQL in 24 Hours, First through Fourth Editions, Sams Teach Yourself SQL in 21 Days, Second through Fourth Editions, and Database Design.

 

Table of Contents

 

Introduction  1

 

PART I: Introducing SQL

 

LESSON 1: Getting Started with SQL     5

     A Brief History of SQL     5

     A Brief History of Databases     6

     Today’s Database Landscape     11

     A Cross-Product Language     12

         Early Implementations     12

         SQL and Client/Server Application Development     13

    An Overview of SQL     13

    Popular SQL Implementations     14

         MySQL     14

         Oracle     14

         Microsoft SQL Server and Sybase     15

         IBM DB2     16

    Open Database Connectivity     16

    Embedding SQL in Application Programming     17

 

LESSON 2: Introducing the Query     21

    Exploring SQL’s Background     21

    Learning Basic Query Syntax     22

    The Building Blocks of Data Retrieval: SELECT and FROM     23

    Applying Query Concepts     25

    Writing Your First Query     26

         Terminating a SQL Statement     28

         Selecting Individual Columns     28

         Changing the Order of the Columns     29

         Selecting Different Tables     31

    Selecting Distinct Values     31

         Exercises  37

 

LESSON 3: Expressions, Conditions, and Operators     39

    Working with Query Expressions     40

    Placing Conditions on Queries     40

    Learning How to Use Operators     42

        Arithmetic Operators     42

        Comparison Operators     55

        Character Operators     63

        Logical Operators     70

        Set Operators     75

        Miscellaneous Operators: IN and BETWEEN     78

 

LESSON 4: Clauses in SQL Queries     85

    Specifying Criteria with the WHERE Clause     87

    Order from Chaos: The ORDER BY Clause     89

    The GROUP BY Clause     98

    The HAVING Clause     105

    Combining Clauses     112

        Example 4.1     112

        Example 4.2     113

        Example 4.3     113

        Example 4.4     115

 

LESSON 5: Joining Tables     121

    Joining Multiple Tables in a Single SELECT Statement     121

        Cross Joining Tables     123

        Finding the Correct Column     128

    Joining Tables Based on Equality     129

    Joining Tables Based on Nonequality     137

    OUTER JOINs Versus INNER JOINs     139

    Joining a Table to Itself: The Self Join     143

 

LESSON 6: Embedding Subqueries into Queries     151

    Building a Subquery     153

    Using Aggregate Functions with Subqueries     160

    Nesting Subqueries     162

    Referencing Outside with Correlated Subqueries     166

    Using EXISTS, ANY, and ALL     169

 

LESSON 7: Molding Data with Built-in Functions     179

    Using Aggregate Functions to Summarize Data     180

         COUNT     180

         SUM     181

         AVG     182

         MAX     184

         MIN     185

 &nb...

商品描述(中文翻譯)

《Sams Teach Yourself SQL in 21 Days》第五版

已售出超過48,000本!

每天只需一小時,您就能掌握所需的技能,開始創建有效的SQL查詢、報表和數據庫應用程序。這本完整的教程將讓您迅速掌握基礎知識,然後深入研究更高級的功能和概念:

- 快速應用實用的SQL技巧於現實世界的查詢中
- 設計可靠、高性能的數據庫
- 通過視圖和事務操作數據
- 利用存儲過程、觸發器和游標等強大功能
- 使用最新SQL標準引入的新對象
- 在您的業務環境中實施SQL的實用專家技巧

您可以根據自己的時間和進度進行學習:

- 無需任何SQL或數據庫經驗
- 學習適用於任何當前版本的SQL的技巧
- 發現如何撰寫更快、更高效的查詢
- 使用經驗豐富的數據庫管理員的最佳實踐來保護您的數據
- 利用Oracle SQL*Plus、Oracle PL/SQL和Microsoft Transact-SQL等獨有功能構建更強大的數據庫
- 為免費的開源MySQL數據庫編寫查詢
- 將您的SQL代碼嵌入其他應用程序

Ryan Stephens和Ron Plew是印第安納波利斯的Perpetual Technologies, Inc.(PTI)的總裁和副總裁,該公司提供Oracle、SQL Server和其他領先技術的頂級數據庫實施的管理服務和咨詢。他們在印第安納大學普渡大學擔任兼職教授超過5年。他們的著作包括《Sams Teach Yourself SQL in 24 Hours》第一至第四版,《Sams Teach Yourself SQL in 21 Days》第二至第四版和《Database Design》。

目錄:

- 引言
- 第一部分:介紹SQL
- 第一課:開始使用SQL
- SQL的簡要歷史
- 數據庫的簡要歷史
- 當今的數據庫環境
- 跨產品的語言
- 早期實現
- SQL和客戶/服務器應用程序開發
- SQL概述
- 流行的SQL實現
- MySQL
- Oracle
- Microsoft SQL Server和Sybase
- IBM DB2
- 開放數據庫連接
- 在應用程序編程中嵌入SQL

- 第二課:介紹查詢
- 探索SQL的背景
- 學習基本查詢語法
- 數據檢索的基本組成部分:SELECT和FROM
- 應用查詢概念
- 撰寫您的第一個查詢
- 終止SQL語句
- 選擇個別列