PostgreSQL Basics: Aggregate functions (SUM, AVG, etc)

In this article, I’m gonna show you different Aggregate functions in PostgreSQL. Basically, aggregate function are those function which performs a specific task on columns and then produce one aggregate result inside a row. We have different aggregate functions e.g. COUNT, SUM, MIN, MAX, AVG. We’re going to explore each of them one by one. … Read more

How to create a Database in PostgreSQL? The Basic Guide

Hi coders, Today I’m going to show you how you can create database in PostgreSQL, I’m going to show you two different methods – Using command line, and then Using PgAdmin. Creating Database in PostgreSQL: There are two things that you must have installed into your system before moving to given steps: PostgreSQL: Downloads Download … Read more

Connect PostgreSQL Database With Django 3.0(Full Setup)

Django PostgrSQL DB

Hey coders, today I’m going to show you how you can download, setup, and configure your PostgreSQL database. Later on, I’ll also show you how to connect your Postgresql database with the Django web framework. If you want to know the full process then please read full article till the end. Connect PostgreSQL with the … Read more