SQL Fundamentals

The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. At first glance, the language may seem intimidating and complex but it s really not all that bad. In a series of articles over the next few weeks we ll explore the inner workings of SQL together.

By the time we re through, you ll have the fundamental knowledge you need to go out there and start working with databases!

This week, our first article in the SQL series provides an introduction to the basic concepts behind SQL and we ll take a brief look at some of the main commands used to create and modify databases

Throughout this article, please keep our goal in mind: we re trying to get the "big picture" of SQL -- not a mastery of the individual commands. We ll provide a few examples for illustrative purposes and explain the theory behind them, but don t feel frustrated if you can t write your own SQL commands after reading this article. We ll cover each of the major commands in detail in future weekly installments. If you d like a reminder in your e-mail inbox each week when the next article is posted, please take a moment and subscribe to our newsletter.

By the way, the correct pronunciation of SQL is a contentious issue within the database community. In their SQL standard, the American National Standards Institute declared that the official pronunciation is "es queue el." However, many database professionals have taken to the slang pronunciation "sequel." The choice is yours.