Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

Dummies.com
  • Print
  • Share
SQL All-in-One Desk Reference For Dummies (0470119284) cover image

SQL All-in-One Desk Reference For Dummies

ISBN: 978-0-470-11928-0
Paperback
720 pages
July 2007
This title is out-of-print and not currently available for purchase from this site.
Introduction.

Book I: SQL Concepts.

Chapter 1: Relational Database Basics.

Chapter 2: Modeling a System.

Chapter 3: SQL Overview.

Chapter 4: SQL and the Relational Model.

Chapter 5: The Major Components of SQL.

Chapter 6: SQL Characteristics.

Book II: Relational Database Development.

Chapter 1: System Development Overview.

Chapter 2: Building a Database Model.

Chapter 3: Balancing Performance and Correctness.

Chapter 4: Creating a Database with SQL.

Book III: SQL Queries.

Chapter 1: Values, Variables, Functions, and Expressions.

Chapter 2: SELECT Statements and Modifying Clauses.

Chapter 3: Querying Multiple Tables with Subqueries.

Chapter 4: Querying Multiple Tables with Relational Operators.

Book IV: Data Security.

Chapter 1: Protecting Against Hardware Failure and External Threats.

Chapter 2: Protecting Against User Errors and Conflicts.

Chapter 3: Assigning Access Privileges.

Chapter 4: Error Handling.

Book V: SQL and Programming.

Chapter 1: Database Development Environments.

Chapter 2: Interfacing SQL to a Procedural Language.

Chapter 3: Using SQL in an Application Program.

Chapter 4: Designing a Sample Application.

Chapter 5: Building a Sample Application.

Chapter 6: SQL’s Procedural Capabilities.

Chapter 7: Connecting to a Remote Database.

Book VI: SQL and XML.

Chapter 1: XML/SQL Basics.

Chapter 2: Storing XML Data in SQL Tables.

Chapter 3: Retrieving Data from XML Documents.

Book VII: Database Tuning Overview.

Chapter 1: Tuning the Database.

Chapter 2: Tuning the Environment.

Chapter 3: Finding and Eliminating Bottlenecks.

Book VIII: Appendixes.

Appendix A: SQL:2003 Reserved Words.

Appendix B: Glossary.

Index.

  • Print
  • Share