31–40 of 49 posts
Others have given you excellent suggestions; I will simply offer an addition -- a side quest, if you will: Remember that the local single-user databases SQLite and DuckDB exist, and that you can use them to wrangle data without even having to set up a separate server. You just create a database file on your machine and go from there.
It's not SQL directly (it's the Kusto query language) which is more geared towards reading data and analytics.
I'm suggesting it however because the queries in it are also basically relational algebra (aka much of the knowledge is transferable to SQL - minus some special features like anomaly analysis), they give decently sized datasets with billions of rows and the challenges themselves were fun.
Others have given you excellent suggestions; I will simply offer an addition -- a side quest, if you will: Remember that the local single-user databases SQLite and DuckDB exist, and that you can use them to wrangle data without even having to set up a separate server. You just create a database file on your machine and go from there.
Others have given you excellent suggestions; I will simply offer an addition -- a side quest, if you will: Remember that the local single-user databases SQLite and DuckDB exist, and that you can use them to wrangle data without even having to set up a separate server. You just create a database file on your machine and go from there.
There's also nothing stopping you from running postgres, sql server, MySQL etc locally.
Earlier quoted context omitted.
There's also nothing stopping you from running postgres, sql server, MySQL etc locally.
Postgres running local has good ROI. You can reuse that knowledge on a remote server. More than SQL you can learn about setting up databases and schemas etc.
I'm familiar with MySQL/MariaDB, but have no experience with Postgres.
Earlier quoted context omitted.
Postgres running local has good ROI. You can reuse that knowledge on a remote server. More than SQL you can learn about setting up databases and schemas etc.
Can you recommend any good book/resource to pick up PostgreSQL? I'm familiar with MySQL/MariaDB, but have no experience with Postgres.
I teach uni. couses on databases and made the game for my student to give them a more self-driven way to learn SQL.