Chapter 1

Relational Database Fundamentals


Bullet Organizing information

Bullet Defining “database” in digital terms

Bullet Deciphering DBMS

Bullet Looking at the evolution of database models

Bullet Defining “relational database” (can you relate?)

Bullet Considering the challenges of database design

SQL (pronounced ess-que-ell, not see’qwl, though database geeks still argue about that) is a language specifically designed with databases in mind. SQL enables people to create databases, add new data to them, maintain the data in them, and retrieve selected parts of the data. Developed in the 1970s at IBM, SQL has grown and advanced over the years to become the industry standard. It is governed by a formal standard maintained by the International Standards Organization (ISO).

Various kinds of databases exist, each adhering to a different model of how the data in the database is organized.

SQL was originally developed ...

Get SQL For Dummies, 9th Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.