PostgreSQL

PostgreSQL

Master PostgreSQL, the powerful and open-source relational database management system trusted by developers worldwide! Our tutorials dive deep into everything you need to know about PostgreSQL, from installation and setup to advanced query optimization and database performance tuning. Learn how to efficiently manage large datasets, leverage ACID compliance for reliable transactions, and implement complex SQL queries with ease.

19 posts
Get started with PostgreSQL on Mac: A Step-by-Step Guide
Academy Membership PostgreSQL

Get started with PostgreSQL on Mac: A Step-by-Step Guide

Introduction PostgreSQL is one of the most widely used database management systems. One of the easiest ways to use PostgreSQL on macOS is the Postgres.app. Postgres.app provides a simple interface for setting up a server and a command-line interface (psql) for interacting with databases via the terminal. In...

PostgreSQL - SUM

PostgreSQL - SUM

Introduction In this tutorial, we want to calculcate the sum of values of a specific column. In order to do this, we use the SUM function. We have already created the table student with the following data: Example 1 We want to calculcate the sum of credit points of all...

PostgreSQL - COUNT DISTINCT

PostgreSQL - COUNT DISTINCT

Introduction In this tutorial, we want to count the number of unique values of a specific column. In order to do this, we use the COUNT function with the DISTINCT keyword. We have already created the table student with the following data: Example 1 We want to count the number...

PostgreSQL - COUNT

PostgreSQL - COUNT

Introduction In this tutorial, we want to count the number of values of a specific column. In order to do this, we use the COUNT function. We have already created the table student with the following data: Example 1 We want to count the total number of students. In order...

PostgreSQL - SELECT WHERE

PostgreSQL - SELECT WHERE

Introduction In this tutorial, we want to select data from a table that satisfy a certain condition. In order to do this, we use the SELECT Statement with the WHERE Clause. We have already created the table student with the following data: Example 1 We want to select all columns...

PostgreSQL - ORDER BY

PostgreSQL - ORDER BY

Introduction In this tutorial, we want to select data from a table and sort the result set. In order to do this, we use the SELECT Statement with the ORDER BY Clause. We have already created the table student with the following data: Example 1 - Sort rows in ascending...

PostgreSQL - LIMIT

PostgreSQL - LIMIT

Introduction In this tutorial, we want to select a specific number of rows from a table by using a SQL Statement. In order to do this, we use the SELECT Statement with the LIMIT Clause. We have already created the table student with the following data: SQL Statement We want...

PostgreSQL - SELECT DISTINCT

PostgreSQL - SELECT DISTINCT

Introduction In this tutorial, we want to select data from a table by using a SQL Statement. The result should not contain duplicate rows. In order to do this, we use the SELECT Statement with the DISTINCT Clause. We have already created the table student with the following data: Example...

PostgreSQL - SELECT

PostgreSQL - SELECT

Introduction In this tutorial, we want to select data from a table by using a SQL Statement. In order to do this, we use the SELECT Statement. We have already created the table student with the following data: Example 1 - SELECT specific columns We want to select the columns...

You’ve successfully subscribed to Deep Learning Nerds | The ultimate Learning Platform for AI and Data Science
Welcome back! You’ve successfully signed in.
Great! You’ve successfully signed up.
Success! Your email is updated.
Your link has expired
Success! Check your email for magic link to sign-in.