Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Table of Contents
Introduction
About This Book
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Part 1: Getting Started with SQL
Chapter 1: Relational Database Fundamentals
Keeping Track of Things
What Is a Database?
Database Size and Complexity
What Is a Database Management System?
Flat Files
Database Models
Database Design Considerations
Chapter 2: SQL Fundamentals
What SQL Is and Isn’t
A (Very) Little History
SQL Statements
Reserved Words
Data Types
Null Values
Constraints
Using SQL in a Client/Server System
Using SQL on the Internet or an Intranet
Chapter 3: The Components of SQL
Data Definition Language
Data Manipulation Language
Data Control Language
Part 2: Using SQL to Build Databases
Chapter 4: Building and Maintaining a Simple Database Structure
Using a RAD Tool to Build a Simple Database
Building POWER with SQL’s DDL
Portability Considerations
Chapter 5: Building a Multi-table Relational Database
Designing a Database
Working with Indexes
Maintaining Data Integrity
Normalizing the Database
Part 3: Storing and Retrieving Data
Chapter 6: Manipulating Database Data
Retrieving Data
Creating Views
Updating Views
Adding New Data
Updating Existing Data
Transferring Data
Deleting Obsolete Data
Chapter 7: Handling Temporal Data
Understanding Times and Periods
Working with Application-Time Period Tables
Working with System-Versioned Tables
Tracking Even More Time Data with Bitemporal Tables
Formatting and Parsing Dates and Times
Chapter 8: Specifying Values
Values
Value Expressions
Functions
Chapter 9: Using Advanced SQL Value Expressions
CASE Conditional Expressions
CAST Data-Type Conversions
Row Value Expressions
Chapter 10: Zeroing In on the Data You Want
Modifying Clauses
FROM Clauses
WHERE Clauses
Logical Connectives
GROUP BY Clauses
HAVING Clauses
ORDER BY Clauses
Limited FETCH
Peering through a Window to Create a Result Set
Chapter 11: Using Relational Operators
UNION
INTERSECT
EXCEPT
Join Operators
ON versus WHERE
Chapter 12: Delving Deep with Nested Queries
What Subqueries Do
Chapter 13: Recursive Queries
What Is Recursion?
What Is a Recursive Query?
Where Might You Use a Recursive Query?
Where Else Might You Use a Recursive Query?
Part 4: Controlling Operations
Chapter 14: Providing Database Security
The SQL Data Control Language
User Access Levels
Granting Privileges to Users
Granting Privileges across Levels
Granting the Power to Grant Privileges
Taking Privileges Away
Using GRANT and REVOKE Together to Save Time and Effort
Chapter 15: Protecting Data
Threats to Data Integrity
Reducing Vulnerability to Data Corruption
Constraints Within Transactions
Avoiding SQL Injection Attacks
Chapter 16: Using SQL within Applications
SQL in an Application
Hooking SQL into Procedural Languages
Part 5: Taking SQL to the Real World
Chapter 17: Accessing Data with ODBC and JDBC
ODBC
ODBC in a Client/Server Environment
ODBC and the Internet
ODBC and an Intranet
JDBC
Chapter 18: Operating on XML Data with SQL
How XML Relates to SQL
The XML Data Type
Mapping SQL to XML and XML to SQL
SQL Functions That Operate on XML Data
Predicates
Transforming XML Data into SQL Tables
Mapping Non-Predefined Data Types to XML
The Marriage of SQL and XML
Chapter 19: SQL and JSON
Using JSON with SQL
The SQL/JSON Data Model
SQL/JSON Functions
SQL/JSON Path Language
There's More
Part 6: Advanced Topics
Chapter 20: Stepping through a Dataset with Cursors
Declaring a Cursor
Opening a Cursor
Fetching Data from a Single Row
Closing a Cursor
Chapter 21: Adding Procedural Capabilities with Persistent Stored Modules
Compound Statements
Flow of Control Statements
Stored Procedures
Stored Functions
Privileges
Stored Modules
Chapter 22: Handling Errors
SQLSTATE
WHENEVER Clause
Diagnostics Areas
Handling Exceptions
Chapter 23: Triggers
Examining Some Applications of Triggers
Creating a Trigger
Firing a Succession of Triggers
Referencing Old Values and New Values
Firing Multiple Triggers on a Single Table
Part 7: The Parts of Tens
Chapter 24: Ten Common Mistakes
Assuming That Your Clients Know What They Need
Ignoring Project Scope
Considering Only Technical Factors
Not Asking for Client Feedback
Always Using Your Favorite Development Environment
Using Your Favorite System Architecture Exclusively
Designing Database Tables in Isolation
Neglecting Design Reviews
Skipping Beta Testing
Not Documenting Your Process
Chapter 25: Ten Retrieval Tips
Verify the Database Structure
Try Queries on a Test Database
Double-Check Queries That Include Joins
Triple-Check Queries with Subselects
Summarize Data with GROUP BY
Watch GROUP BY Clause Restrictions
Use Parentheses with AND, OR, and NOT
Control Retrieval Privileges
Back Up Your Databases Regularly
Handle Error Conditions Gracefully
Appendix: ISO/IEC SQL: 2016 Reserved Words
Index
About the Author
Connect with Dummies
End User License Agreement
← Prev
Back
Next →
← Prev
Back
Next →