Baseline.SQL 0: Learn SQL from Scratch to Query Databases - Structured Query Language

This video is the first in the baseline.SQL series helping you learn SQL from the ground up. SQL stands for Structured Query Language and can be either pronounced as S Q L or as Sequel.

With SQL you are able to query SQL databases. The latter is the de-facto standard in most enterprise and website databases.

The best known SQL databases are:
PostgreSQL:
Microsoft SQL Server:
MySQL:
MariaDB:
SQLite:

All of the above databases, with the exception of Microsoft SQL Server are open source and can be downloaded freely.

For SQLite, you can use DB Browser for SQLite:

All of the databases above with the exception of SQLite represent databases servers and can handle huge loads of data and queries.

SQLite, as the name suggests, is a lighter version of such database servers. It is not a server, but a single file. It does not offer the full SQL functionality the others offer. However an SQLite database, being so compact in one file, makes it ideal for small applications.

This series is not tied to a specific database product. It is a general SQL course.

The data used in this course comes from Open Food Facts.
Website:
Terms of use:
CSV file:

The data in the CSV file is too big. For the course you initially only need the first 400,000 rows. You can use CSV Splitter to split the CSV in multiple smaller chunks.
CSV Splitter:

Links for course data:
Postgres Dump:
Plain Dump:
SQLite Database (DB Browser):
CSV 400.000 Rows:
CSV 100.000 Rows:

zaitt.works,software,data,programming,prototyping,simulation,sql,sequel,beginner,newbie,postgres,postgresql,sqlite,mysql,mariadb,openfoodfacts,food facts,food,structured query language,