Chapter 3: Getting to Know SQL

In This Chapter

arrow Seeing where SQL came from

arrow Seeing what SQL does

arrow Looking at the ISO/IECSQL standard

arrow Seeing what SQL doesn’t do

arrow 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®, 2nd Edition now with O’Reilly online learning.

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