Postgres and Jupyter notebooks
Install postgres, administer it using cli, connect to it using jupyter notebook.
SQL posts
A collection of SQL posts.
How to work with JSON data using PostgreSQL
We will look at a real-world scenarios of a health-care company data and learn how to query JSON data using normal PostgreSQL.
Query information_schema in Postgres
Since we don’t have DESCRIBE table in Postgres, we need to write this query again and again. So I am documenting it.
Working with Dates and Times in Postgresql
Work with dates and times in SQL
Convert SQLite database to Postgres database
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 sample database in Postgres
Setup dvdrental database locally for demonstrating features of PostgresSQL
How to work with ARRAYs in Postgres
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
Day 1: Leetcode SQL problems
A variety of SQL leetcode questions that I solved. This post captures Day 1 problems and their solutions.
Exploratory Data Analysis of JSON data using PostgreSQL
Use PostgreSQL JSON operators and functions to explore and understand couple of datasets stored inside a database
Data driven decision making part 1
Using simple SQL filtering, aggregations and joins answering business questions.