You are previewing SQL All-in-One For Dummies®, 2nd Edition.
O'Reilly logo
SQL All-in-One For Dummies®, 2nd Edition

Book Description

The soup-to-nuts guide on all things SQL!

SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into easily digestible pieces for you to understand. You'll get the goods on relational database design, development, and maintenance, enabling you to start working with SQL right away!

  • Provides an overview of the SQL language and examines how it is integral for the storage and retrieval of database information
  • Includes updates to SQL standards as well as any new features
  • Explores SQL concepts, relational database development, SQL queries, data security, database tuning, and more
  • Addresses the relationship between SQL and programming as well as SQL and XML

If you're looking for an up-to-date sequel to the bestelling first edition of SQL All-in-One For Dummies, then this is the book for you!

Table of Contents

  1. Cover
  2. Table of Contents
  3. Title Page
  4. Introduction
  5. Book I: SQL Concepts
    1. Book I: Chapter 1: Understanding Relational Databases
    2. Book I: Chapter 2: Modeling a System
    3. Book I: Chapter 3: Getting to Know SQL
    4. Book I: Chapter 4: SQL and the Relational Model
    5. Book I: Chapter 5: Knowing the Major Components of SQL
    6. Book I: Chapter 6: Drilling Down to the SQL Nitty-Gritty
  6. Book II: Relational Database Development
    1. Book II: Chapter 1: System Development Overview
    2. Book II: Chapter 2: Building a Database Model
    3. Book II: Chapter 3: Balancing Performance and Correctness
    4. Book II: Chapter 4: Creating a Database with SQL
  7. Book III: SQL Queries
    1. Book III: Chapter 1: Values, Variables, Functions, and Expressions
    2. Book III: Chapter 2: SELECT Statements and Modifying Clauses
    3. Book III: Chapter 3: Querying Multiple Tables with Subqueries
    4. Book III: Chapter 4: Querying Multiple Tables with Relational Operators
    5. Book III: Chapter 5: Cursors
  8. Book IV: Data Security
    1. Book IV: Chapter 1: Protecting Against Hardware Failure and External Threats
    2. Book IV: Chapter 2: Protecting Against User Errors and Conflicts
    3. Book IV: Chapter 3: Assigning Access Privileges
    4. Book IV: Chapter 4: Error Handling
  9. Book V: SQL and Programming
    1. Book V: Chapter 1: Database Development Environments
    2. Book V: Chapter 2: Interfacing SQL to a Procedural Language
    3. Book V: Chapter 3: Using SQL in an Application Program
    4. Book V: Chapter 4: Designing a Sample Application
    5. Book V: Chapter 5: Building an Application
    6. Book V: Chapter 6: Understanding SQL's Procedural Capabilities
    7. Book V: Chapter 7: Connecting SQL to a Remote Database
  10. Book VI: SQL and XML
    1. Book VI: Chapter 1: Using XML with SQL
    2. Book VI: Chapter 2: Storing XML Data in SQL Tables
    3. Book VI: Chapter 3: Retrieving Data from XML Documents
  11. Book VII: Database Tuning Overview
    1. Book VII: Chapter 1: Tuning the Database
    2. Book VII: Chapter 2: Tuning the Environment
    3. Book VII: Chapter 3: Finding and Eliminating Bottlenecks
  12. Book VIII: Appendices
    1. Book VIII: Appendix A: SQL:2008 Reserved Words
    2. Book VIII: Appendix B: Glossary
  13. Cheat Sheet