Book description
This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including · formulating SQL queries, · understanding how queries are processed by the DBMS,· maximizing performance,· using SQL to enter, modify, or delete data,· creating and maintaining database structural elements, and· embedding SQL in applications.Features· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.· Web enhanced with extra features available online at www.mkp.com.* Second edition of classic SQL handbook* Updated to cover changes in the SQL language standard (SQL:1999)* Includes CD with MySQL software
Table of contents
- Cover Image
- Table of Contents
- Front matter
- Copyright
- Preface to the Third Edition
- 1. The Relational Data Model
- 2. Relational Algebra
- 3. Introduction to SQL
- 4. Simple SQL Retrieval
- 5. Retrieving Data from More Than One Table
- 6. Advanced Retrieval Operations
- 7. Working with Groups of Rows
- 8. Data Modification
- 9. Schemas and Tables
- 10. Views, Temporary Tables, CTEs, and Indexes
- 11. Keeping the Design Up to Date
- 12. Users and Access Rights
- 13. Users, Sessions, and Transaction Control
- 14. Writing and Executing SQL Routines and Modules—Triggers and Stored Procedures
- 15. Embedded SQL
- 16. Dynamic SQL
- 17. XML Support
- 18. The Object-Relational Data Model
- 19. Object-Relational Support
- Appendix A. Common Acronyms and Abbreviations
- Appendix B. SQLSTATE Return Codes
- Appendix C. SQL Syntax Summary
- Glossary
- Index
Product information
- Title: SQL Clearly Explained, 2nd Edition
- Author(s):
- Release date: May 2003
- Publisher(s): Morgan Kaufmann
- ISBN: 9780080517582
You might also like
book
SQL Hacks
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push …
book
Oracle SQL Revealed: Executing Business Logic in the Database Engine
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be …
book
Oracle SQL Recipes: A Problem-Solution Approach
Have you ever been faced with a new type of query to write, or been asked …
book
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the …
