What is SQL?
SQL, which stands for Structured Query Language, has been described as the way we tell the computer what we want and give it the information it needs to go and get it. If you want to get data out of the database, chances are you will have to write the sql to get the information out.

Like most general technologies, there is a set a standards that have been setup so the language can be consistent between the different vendors. The ISO (the International Organization for Standardization) is the board that set up the rules for the standards we use now.

There are differences between the various database vendors, but most items we talk about in this series will meet this standard, so it doesn’t matter if you use Oracle, SQL Server, Access, postgresql, MySQL, or DB2.  When it is database specific, we will note it in on the page.

Database Diagram

As you use this site, we will use this structure for our queries.

Did we miss something or need a better example?  Let me know.  You can reach me on Twitter or by filling out the contact form.