Introduction to SQL: Mastering the Relational Database Language, 4/e (Paperack)

Rick F. van der Lans

  • 出版商: Addison Wesley
  • 出版日期: 2006-09-01
  • 售價: $2,240
  • 貴賓價: 9.5$2,128
  • 語言: 英文
  • 頁數: 1064
  • 裝訂: Paperback
  • ISBN: 0321305965
  • ISBN-13: 9780321305961
  • 相關分類: SQL資料庫
  • 已絕版

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

商品描述

Description 

The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases

For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL.

 

Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master.

  •   Writing queries and updating data: all you need to know about SELECT
  •   Working with joins, functions, and subqueries
  •   Creating database objects: tables, indexes, views, and more
  •   Specifying keys and other integrity constraints
  •   Using indexes to improve efficiency
  •   Enforcing security via passwords and privileges
  •   Building stored procedures and triggers
  •   Developing with embedded SQL and ODBC
  •   Working with transactions, including rollbacks, savepoints, isolation levels, and more
  •   Optimizing performance by reformulating SQL statements
  •   Using object-relational features: subtables, references, sets, and user-defined data types
  •   Reference section: SQL statement definitions and SQL function lists

 

Table of Contents

About the Author   xix

Preface   xxi

Part 1   Introduction    1

1  Introduction to SQL    3

2  The Tennis Club Sample Database    31

3  Installing the Software    41

4  SQL in a Nutshell    67

Part 2   Querying and Updating Data    95

5  SELECT Statement: Common Elements    97

6  SELECT Statements, Table Expressions, and Subqueries    155

7  SELECT Statement: The FROM Clause    185

8  SELECT Statement: The WHERE Clause    241

9  SELECT Statement: SELECT Clause and Aggregation Functions    339

10  SELECT Statement: The GROUP BY Clause    377

11  SELECT Statement: The HAVING Clause    421

12  SELECT Statement: The ORDER BY Clause    429

13  Combining Table Expressions    443

14  Updating Tables    469

Part 3   Creating Database Objects    485

15  Creating Tables    487

16  Specifying Integrity Constraints   515

17  Character Sets and Collating Sequences    535

18  Changing and Dropping Tables    553

19  Designing Tables    565

20  Using Indexes    579

21  Views    611

22  Creating Databases   635

23  Users and Data Security    641

24  Creating Sequences    665

25  Creating Schemas   681

Part 4   Programming with SQL    685

26  Introduction to Embedded SQL    687

27  Transactions and Multi-User Usage    725

28  Introduction to ODBC    745

29  Optimization of Statements   783

Part 5         Procedural Database Objects   803

30  Stored Procedures   805

31  Stored Functions    847

32  Triggers    853

Part 6   Object Relational Concepts    871

33  User-Defined Data Types, Functions, and Operators    873

34  Inheritance, References, and Collections    889

35  The Future of SQL    909

Appendix A   Syntax of SQL    911

Appendix B   Scalar Functions    953

Appendix C   Bilbiography    999

Index    1003