SQL: A Beginner's Guide, Fourth Edition, 4th Edition

Contents

ACKNOWLEDGMENTS

INTRODUCTION

PART I Relational Databases and SQL

1 Introduction to Relational Databases and SQL

Understand Relational Databases

The Relational Model

Try This 1-1: Normalizing Data and Identifying Relationships

Learn About SQL

The SQL Evolution

Types of SQL Statements

Types of Execution

SQL Standard versus Product Implementations

Try This 1-2: Connecting to a Database

Chapter 1 Self Test

2 Working with the SQL Environment

Understand the SQL Environment

Understand SQL Catalogs

Schemas

Schema Objects

Then What Is a Database?

Name Objects in an SQL Environment

Qualified Names

Create a Schema

Create a Database

Try This 2-1: Creating a Database and a Schema

Chapter 2 Self Test

3 Creating and Altering Tables

Create SQL Tables ...