Install postgres, administer it using cli, connect to it using jupyter notebook.
A collection of SQL posts.
We will look at a real-world scenarios of a health-care company data and learn how to query JSON data using normal PostgreSQL.
Since we don’t have DESCRIBE table in Postgres, we need to write this query again and again. So I am documenting it.
Work with dates and times in SQL
Convert a SQLite database to a Postgres Database. Example when given database.sqlite and you want to do your analysis in Postgres, then read on
Setup dvdrental database locally for demonstrating features of PostgresSQL
When data is stored in arrays we can make use of some special Postgres operators like ANY and CONTAINS to query, filter and aggregate records
A variety of SQL leetcode questions that I solved. This post captures Day 1 problems and their solutions.
Use PostgreSQL JSON operators and functions to explore and understand couple of datasets stored inside a database
Using simple SQL filtering, aggregations and joins answering business questions.