Database Essentials Using Postgres Writing

Database Essentials using Postgres - Writing Basic SQL Queries - Overview of Data Model

We will be

Database Essentials using Postgres - Writing Basic SQL Queries - Selecting or Projecting Data

Let us understand different aspects of projecting

Database Essentials using Postgres - Writing Basic SQL Queries - Joining Tables - Inner

Let us understand how to join

Database Essentials using Postgres - Writing Basic SQL Queries - Sorting Data

Let us understand how to sort the

Database Essentials using Postgres - Writing Basic SQL Queries - Performing Aggregations

Let us understand how to aggregate the

Database Essentials using Postgres - Writing Basic SQL Queries - Filtering Data

Let us understand how we can filter the

Database Essentials using Postgres - Writing Basic SQL Queries - Joining Tables - Outer

Let us understand how to perform outer joins

Database Essentials using Postgres - Writing Basic SQL Queries - Preparing Tables

Let us prepare retail tables to come up with the solution for the problem statement. Click below to get access to the...

Database Essentials using Postgres - Writing Basic SQL Queries - Standard Transformations

Here are some of the transformations we typically perform on regular basis. Click below to get access to the course...

Database Essentials using Postgres - Writing Basic SQL Queries - Solution - Daily Product Revenue

Let us review the Final Solution for our problem statement daily_product_revenue. Click below to get access to the...

Database Essentials using Postgres - Writing Basic SQL Queries - Define Problem Statement

Let us try to get daily product revenue

I replaced my entire tech stack with Postgres...

Sign up for Neon and create up to 10

Database Essentials using Postgres - Creating Tables and Indexes - Overview of Data Types

Let us get an overview of