Our great sponsors
-
pgadmin4
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
Northwind-Database
This repository contains 50 queries and answers to the popular northwind database using MySQL
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
If you're not comfortable at the command line or want a more traditional text editing experience, a database gui like pgAdmin or tableplus will let you connect to a database and provide a text editor where you can write and run queries.
If you're not comfortable at the command line or want a more traditional text editing experience, a database gui like pgAdmin or tableplus will let you connect to a database and provide a text editor where you can write and run queries.
There's a famous sample database called Northwind https://github.com/pthom/northwind_psql . I think it was originally included by microsoft in MSAccess for training purposes. You can download it, load it into postgres through Adminer. Finally, I just now googled "northwind practice queries" and found this, there's questions and answers, and some more resources there to use.
There's a famous sample database called Northwind https://github.com/pthom/northwind_psql . I think it was originally included by microsoft in MSAccess for training purposes. You can download it, load it into postgres through Adminer. Finally, I just now googled "northwind practice queries" and found this, there's questions and answers, and some more resources there to use.
You can install Adminer and run queries on your local postgreSQL database directly through a web-browser interface. It's often less scary than a command-line interface.