SQL: The Complete Reference - Softcover

James R. Groff; Paul N. Weinberg

Softcover

ISBN 10: 0070528500 ISBN 13: 9780070528505

Publisher: McGraw-Hill

Synopsis

Featuring broad coverage of every aspect of this leading database language, this book provides an overview of SQL then shows how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, it helps gain the knowledge and essential skills needed to effectively work with SQL. About The Author: Not Available Table of Contents Part I: An Overview of SQL 1: Introduction 2: A Quick Tour of SQL 3: SQL in Perspective 4: Relational Databases Part II: Retrieving Data 5: SQL Basics 6: Simple Queries 7: Multitable Queries (Joins) 8: Summary Queries 9: Subqueries and Query Expressions Part III: Updating Data 10: Database Updates 11: Data Integrity 12: Transaction Processing Part IV: Database Structure 13: Creating a Database 14: Views 15: SQL Security 16: The System Catalog Part V: Programming with SQL 17: Embedded SQL 18: Dynamic SQL * 19: SQL APIs Part VI: SQL Today and Tomorrow 20: Database Processing and Stored Procedures 21: SQL and Data Warehousing 22: SQL and Application Servers 23: SQL Networking and Distributed Databases 24: SQL and Objects 25: SQL and XML 26: The Future of SQL Part VII: Appendixes A: The Sample Database B: Database Vendor Profiles C: SQL Syntax Reference D: SQL Call-

Edition details

• Publisher: McGraw-Hill
• ISBN 10: 0070528500
• ISBN 13: 9780070528505
• Binding: Paperback
• Language: English
• Number of pages: 1088