Your Library
Chapter 2 · Database and Table BasicsDefine structures, protect data, and understand query execution
Contents
Chapter 1Chapter 2

Database and Table Basics

Define structures, protect data, and understand query execution

This chapter moves from the purpose of databases to the SQL used to create and work with them. It introduces command families, tables and data types, keys and constraints, structural changes, NULL, and the broad stages of query execution.

By the end, you should be able to create a simple table, explain its keys and constraints, distinguish a missing value from zero or empty text, and describe how a database processes a query.

In this chapter

  1. 1.1Database and Table Basics