Hundreds of data tutorials for growing companies

Use selective GRANT statements to limit PostgreSQL access to specific tables and columns for certain users.

Connect to your PostreSQL server and grant privileges so that the new user can connect.

Create a new read-only user for your PostgreSQL database using pgAdmin so you can create your data source connection in Chartio.

This tutorial will show you how to parse columns with substring in PostgreSQL and Redshift. A substring is a part of a string.

Selecting records from the previous day observes daily performance. We look at how to write a PostgreSQL query to select records from the last 24 hours.

The search term “12 Month Rolling report” has over 12 million search results, and experts believe the rolling report is one of the best ways to show trends. In this tutorial we will show how to generate a period over period rolling running total chart in PostgreSQL.

Learn how to check a database table for duplicate values using a simple query.

One function that can be useful in determining how two numbers relate to each other is the correlation function. In this tutorial we will explain the corr() PosrgreSQL function as well as show it in real world use.

The correlation function is useful in determining how two numbers relate. Read this tutorial to learn how to utilize the correlation function in a SQL query.

Analyzing PostgreSQL table statistics is essential for monitoring the number of active and non-active rows or tuples in a table. In this tutorial, learn the SQL commands that enable you to analyze PostgreSQL table statistics.