Chapter 3

Getting to Know SQL

IN THIS CHAPTER

Bullet Seeing where SQL came from

Bullet Seeing what SQL does

Bullet Looking at the ISO/IECSQL standard

Bullet Seeing what SQL doesn’t do

Bullet Examining your SQL implementation options

In the early days of relational database management systems (RDBMS), there was no standard language for performing relational operations on data. (If you aren’t sure what an RDBMS is, please take a look at the first chapter in this book.) A number of companies came out with relational database management system products, and each had its own associated language. There were some general similarities among the languages because they all performed essentially the same operations on the same kinds of data, structured in the same way. However, differences in syntax and functionality made it impossible for a person using the language of one RDBMS to operate on data that had been stored by another relational database management system. (That’s RDBMS, if you missed it the first time.) All the ...

Get SQL All-In-One For Dummies, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.