- Cover
- Introduction
- Book 1: SQL Concepts
- Book 2: Relational Database Development
- Book 3: SQL Queries
- Book 4: Data Security
- Chapter 1: Protecting Against Hardware Failure and External Threats
- Chapter 2: Protecting Against User Errors and Conflicts
- Reducing Data-Entry Errors
- Coping with Errors in Database Design
- Handling Programming Errors
- Solving Concurrent-Operation Conflicts
- Passing the ACID Test: Atomicity, Consistency, Isolation, and Durability
- Operating with Transactions
- Getting Familiar with Locking
- Tuning Locks
- Enforcing Serializability with Timestamps
- Tuning the Recovery System
- Chapter 3: Assigning Access Privileges
- Chapter 4: Error Handling
- Identifying Error Conditions
- Getting to Know SQLSTATE
- Handling Conditions
- Dealing with Execution Exceptions: The WHENEVER Clause
- Getting More Information: The Diagnostics Area
- Examining an Example Constraint Violation
- Adding Constraints to an Existing Table
- Interpreting SQLSTATE Information
- Handling Exceptions
- Book 5: 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 an Application
- Chapter 6: Understanding SQL’s Procedural Capabilities
- Chapter 7: Connecting SQL to a Remote Database
- Book 6: SQL, XML, and JSON
- Book 7: Database Tuning Overview
- Book 8: Appendices
- Index
- About the Author
- Advertisement Page
- Connect with Dummies
- End User License Agreement
SQL All-In-One For Dummies®
To view this book's Cheat Sheet, simply go to www.dummies.com and search for “SQL All-In-One For Dummies Cheat Sheet” in the Search box.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.