O'Reilly logo

Beginning Rails 3 by Rida Al Barazi, Cloves Carneiro Jr.

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

Appendix B. Databases 101

Let's begin with a simple definition. A database is a piece of software that governs the storage, retrieval, deletion, and integrity of data.

Databases are organized into tables. Tables have columns (or if you prefer, fields), and data is stored in rows. If you're familiar with spreadsheets, then the idea is fairly similar. Of course, databases blow spreadsheets out of the water in terms of power and performance.

Structured Query Language (SQL) is the standard way of communicating with databases. Using SQL, you can view column information, fetch a particular row or a set a rows, and search for rows containing certain criteria. You also use SQL to create, drop, and modify tables, as well as insert, update, and destroy the ...

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