From Basic to Intermediate SQL in 10 Minutes

Photo by Lauren Mancke on Unsplash

Table of Contents

• Basics
  - SELECT, WHERE, ORDER BY
  - WHERE details
  - Strings & Dates
• Intermediate
  - Aggregation
  - Aggregation filtering
  - Joins
  - Unions

Introduction

If you need a more general introduction to SQL and Databases, check out the first part of this tutorial:

The Easiest Local SQL Server

In this article, we will look at basic SQL syntax; selecting data from tables, filtering and working with data types. We will then look at Joins and aggregate measures.

The syntax in this article is all you really need to work with data in SQL competently. Anything else just makes life easier.

SQL for Data Science — why?

SQL remains one of the most important skills for all data related roles in 2020. Regardless of the advances and uptake in NoSQL databases, companies still use relational databases widely and SQL is essential to extract data out.