SQL Crash Course
SQL (Structured Query Language) is a standard language for accessing databases.
It is highly useful in business analytics and reporting, but has many uses outside this realm as well. However, my focus will be in utilizing SQL to access and manipulate data for the purposes of business analytics and reporting.
I recently started learning SQL and am putting this section together as an online reference for myself. However, I hope that if you are trying to learn SQL, that you will find this to be a crash course, as even a SQL for Dummies book can be a handful.
You may want to create the following table in your SQL Server, as it will be used for examples.
The “Persons” table:
| P_Id | LastName | FirstName | Address | City |
|---|---|---|---|---|
| 1 | Hansen | Ola | Timoteivn 10 | Sandnes |
| 2 | Svendson | Tove | Borgvn 23 | Sandnes |
| 3 | Pettersen | Kari | Storgt 20 | Stavanger |
You can follow the links below to learn from scratch, or jump to sections you want to learn as refreshers.
