O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Book II

Relational Database Development

9780470929964-pp0201.eps

Contents at a Glance

Chapter 1: System Development Overview

The Components of a Database System

The System Development Life Cycle

Chapter 2: Building a Database Model

Finding and Listening to Interested Parties

Building Consensus

Building a Relational Model

Being Aware of the Danger of Anomalies

The Database Integrity versus Performance Tradeoff

Chapter 3: Balancing Performance and Correctness

Designing a Sample Database

Maintaining Integrity

Avoiding Data Corruption

Speeding Data Retrievals

Working with Indexes

Reading SQL Server Execution Plans

Chapter 4: Creating a Database with SQL

First Things First: Planning Your Database

Building Tables

Setting Constraints

Keys and Indexes

Ensuring Data Validity with Domains

Establishing Relationships between Tables

Altering Table Structure

Deleting Tables

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required