Overview

Full Product Details

Author:   Rick Van Der Lans
Publisher:   Pearson Education (US)
Imprint:   Addison Wesley
Edition:   3rd edition
Dimensions:   Width: 17.40cm , Height: 4.20cm , Length: 22.80cm
Weight:   1.240kg
ISBN:  

9780201596182

ISBN 10:   0201596180
Pages:   720
Publication Date:   18 November 1999
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780321305961
Format:   Mixed media product
Publisher's Status:   Out of Print
Availability:   Awaiting stock  

Table of Contents

1. Introduction to SQL1 2. The Tennis Club Sample Database 3. Working with SOLID 4. SQL in a Nutshell 5. SELECT Statement: Common Elements 6. Clauses of the SELECT Statement 7. The SELECT Statement: the FROM Clause 8. SELECT Statement: the WHERE Clause 9. SELECT Statement: the SELECT Clause and Functions 10. SELECT Statement: GROUP BY and HAVING 11. SELECT Statement: the ORDER BY Clause 12. Combining SELECT Statements 13. The Subquery 14. The FROM Clause Extended 15. Updating Tables 16. Creating Tables 17. Specifying Constraints 18. Designing Tables 19. Using Indexes 20. Views 21. Users and Data Security 22. Catalog Tables 23. Introduction to Embedded SQL 24. Transactions and Multi-User Usage 25. Introduction to ODBC 26. Optimization of Statements 27. Stored Procedures 28. Triggers 29. User-defined Data Types, Functions and Operators 30. Inheritance, References and Collections 31. The Future of SQL

Reviews

Author Information

Rick van der Lans is an independent database consultant with many years' experience developing applications with SQL. He lectures frequently in the USA and Europe and is the author of several books on SQL, also published by Addison-Wesley, including The SQL Guide for Oracle and An SQL Guide for dBase IV.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions