買這商品的人也買了...
-
$390$332 -
$580$493 -
$550$468 -
$350$315 -
$250$198 -
$720$569 -
$620$490 -
$690$538 -
$650$514 -
$680$578 -
$650$553 -
$650$514 -
$580$458 -
$550$468 -
$750$593 -
$620$527 -
$460$363 -
$750$593 -
$590$502 -
$580$458 -
$690$538 -
$520$468 -
$480$379 -
$500$425 -
$650$514
相關主題
商品描述
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語句
- 選擇個別列