Home > Store > Data > SQL

Introduction to SQL: Mastering the Relational Database Language, 4th Edition

Register your product to gain access to bonus material or receive a coupon.

Introduction to SQL: Mastering the Relational Database Language, 4th Edition

Book

  • Your Price: $43.99
  • List Price: $54.99
  • Usually ships in 24 hours.

About

Features

  • Fully updated to cover the most recent versions of all the major relational database vendors, including Oracle, Microsoft SQL Server, and MySQL
  • Accompanying CD contains MySQL for Windows and the WinSQL dba toolset. All sample code from the book is available on the book's web site.

Description

  • Copyright 2007
  • Dimensions: 7x9-1/4
  • Pages: 1056
  • Edition: 4th
  • Book
  • ISBN-10: 0-321-30596-5
  • ISBN-13: 978-0-321-30596-1

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

Downloads

Downloads

The CD is no longer included with the printed book, but you can download the two programs from the CD below:
MySQL for Windows
WinSQL Database Administration Utility

Sample Content

Online Sample Chapter

SELECT Statement: The GROUP BY Clause in SQL

Downloadable Sample Chapter

Download the sample chapter

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

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership