We will be working with the soccer database from kaggle : https://www.kaggle.com/hugomathien/soccer. It contains data for soccer matches, players, and teams from several European countries from 2007/2008 to 2015/2016 (Some players are not available in year 2016). In the file query.sql there are all the queries to get informations from the db.
-black){kind=icon}
▪️ DBeaver
▪️ PostgreSQL
▪️ SQL Shell (psql)
European Soccer Database
Link to download sqlite db : https://www.kaggle.com/hugomathien/soccer .
With DBeaver we can migrate from SQLite database to PostgreSQL database, and we can convert the datatype of the column date in every table from text to timestamp.
All the queries are in the file query.sql
We use SQL shell (psql) to connect to the database and run the queries
Type in psql the following command
\i C:/some/path/query.sql
❗ Please not that also in Windows we need to use the slashes (/) instead of blackslashes
