New in XMod Pro
Free Module Kits
XMod Pro Addons
Browse it all or refine your selection using the filters below on the left.
By: Kelly Ford
Link to this Article
While XMod Pro doesn't require that you know SQL to build basic solutions, the more SQL you know the more powerful solutions you can build. With that goal in mind, we've created this beginner's guide to SQL for those of you who want to learn more. We'll dispense with the theory and advanced topics, focusing on the core, basic features of SQL that you should know to work effectively in XMod Pro.
Back in the days before Skynet became sentient and computers ruled the world, humans needed a way to talk to databases -- to ask them questions -- to "query" them for information. So, they created SQL, which stands for Structured Query Language. Essentially, it's a way you can talk to the database to retrieve data or add, update, and delete data.
Since we all tend to want different data or ask our questions in different ways, you'll find a lot of features and functions in SQL that help you do that. We won't go into the advanced uses of SQL in this article. Our goal is to give you a basic understanding of the language and how to use it for standard operations - without overloading you with theory, advanced topics, or minutia.
SQL, by the way, is pronounced in two equally valid ways: 1) As the individual letters: S-Q-L; 2) "see-kwul" like "Seagull" but replace the "g" sound with "kw".
First, a smattering of vocabulary to make your learning easier...
We could cover a lot of other vocabulary, but I always hate it when I have to spend too much time in "foundations" and not enough time learning something meaningful. So, we'll cover additional vocabulary items as we encounter them.
Next: Retrieving Data >>
Articles in this this SQL for Beginners Series: