SQL All-In-One For Dummies, 3rd Edition

Book 1

SQL Concepts

Contents at a Glance

1. Chapter 1: Understanding Relational Databases
   1. Understanding Why Today’s Databases Are Better than Early Databases
   2. Databases, Queries, and Database Applications
   3. Examining Competing Database Models
   4. Why the Relational Model Won
2. Chapter 2: Modeling a System
   1. Capturing the Users’ Data Model
   2. Translating the Users’ Data Model to a Formal Entity-Relationship Model
3. Chapter 3: Getting to Know SQL
   1. Where SQL Came From
   2. Knowing What SQL Does
   3. The ISO/IEC SQL Standard
   4. Knowing What SQL Does Not Do
   5. Choosing and Using an Available DBMS Implementation
4. Chapter 4: SQL and the Relational Model
   1. Sets, Relations, Multisets, and Tables
   2. Functional Dependencies
   3. Keys
   4. Views
   5. Users
   6. Privileges
   7. Schemas
   8. Catalogs
   9. Connections, Sessions, and Transactions
   10. Routines
   11. Paths
5. Chapter 5: Knowing the Major Components of SQL
   1. Creating a Database with the Data Definition Language
   2. Operating on Data with the Data Manipulation Language (DML)
   3. Maintaining Security in the Data Control Language (DCL)
6. Chapter 6: Drilling Down to the SQL Nitty-Gritty
   1. Executing SQL Statements
   2. Using Reserved Words Correctly
   3. SQL’s Data Types
   4. Handling Null Values
   5. Applying Constraints