Learn SQL from Scratch 0 | Kovolff

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: www.postgresql.org/
Microsoft SQL Server: www.microsoft.com/en-us/sql-server/sql-server-2019
MySQL: www.mysql.com/
MariaDB: mariadb.org/
SQLite: www.sqlite.org/index.html

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: sqlitebrowser.org/

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: world.openfoodfacts.org/
Terms of use: world.openfoodfacts.org/terms-of-use
CSV file: static.openfoodfacts.org/data/en.openfoodfacts.org…

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: www.erdconcepts.com/dbtoolbox.html

Links for course data:
Postgres Dump: downloads.zaitt.works/openfoodfacts_data.sql
Plain Dump: downloads.zaitt.works/openfoodfacts_data.txt
SQLite Database (DB Browser): downloads.zaitt.works/baseline_sql.db
CSV 400.000 Rows: downloads.zaitt.works/openfoodfacst_data_400k.csv
CSV 100.000 Rows: downloads.zaitt.works/openfoodfacst_data_100k.csv

#sql #postgres #databases