About this lesson
Download this lesson’s exercise file.An Overview of SQL.docx
An Overview of SQL
SQL is the language we use to program databases.
When to use
Anytime you want to put data in, take data out, or use databases programmatically - you'll use SQL.
SQL is the programming language of databases. It allows us to do things to databases programmatically.
The type of Database you use will determine the type of SQL you'll use. In our case, we'll be using T-SQL because we are using Microsoft SQL Server. The different versions of SQL are so similar that you will be able to apply most of what you learn to many other databases such as MySQL, PostgreSQL, Oracle and more.
SQL is easy to learn, and very straightforward to use because it is close to spoken English.
Hints & tips
- SQL stands for Structured Query Language
- We'll be using T-SQL in this course
Lesson notes are only available for subscribers.