PostgreSQL Tutorial

Welcome to the PostgreSQL Tutorial at Linux Concept website!

This PostgreSQL tutorial teaches you how to use PostgreSQL efficiently.

Learn PostgreSQL Database - Linux Concept

PostgreSQL will be easy for you to learn because there are lots of practical examples and you’ll use the knowledge when building applications with PostgreSQL.

In this tutorial, you will learn everything about PostgreSQL in easy 12 units:

  1. Getting started with PostgreSQL
  2. Querying and Filtering Data
  3. Joining Multiple Tables and Grouping Data
  4. Set Operation, Grouping sets, Cube and Rollup
  5. Subquery and Common table expression
  6. Modifying Data and Transaction
  7. Import and Export data
  8. Managing Tables
  9. Understanding PostgreSQL Constraints
  10. PostgreSQL Data Types in Depth
  11. Conditional Expressions & Operators
  12. PostgreSQL Utilities and PostgreSQL Recipes
Introduction

Getting started with PostgreSQL

In this section you will start by installing PostgreSQL on your system. You will also install some basic tools that will help us work with databases.

Learn Filtering - Linux Concept

Querying and Filtering Data

In this section you will learn how to query and filter data using SQL statements. You will see how to write queries to get information from tables and views. You will also learn how to create a view that can be used as an alternative to a table.

Learn Joining multiple tables - Linux Concept

Joining Multiple Tables and Grouping Data

In this section you will look at joining multiple tables together. We will also look at grouping data based on columns from different tables.

Learn Database Operations - Linux Concept

Set Operation, Grouping Sets, Cube and Rollup

In this section you will look into set operations, groupings sets, cube and rollup. These concepts are very important to understand if you want to build efficient database applications.

Learn Regular Expression - Linux Concept

Subquery and Common Table Expression

In this section you look at subqueries and common table expressions. A subquery is a part of a larger query that returns only one row or column. A common table expression (CTE) is similar to a subquery but it allows us to perform more complex calculations.

Learn DB Transaction - Linux Concept

Modifying Data and Transaction

In this section you learn how to modify data and transactions. This includes creating new rows, updating existing rows, deleting rows and locking rows so they cannot be modified while you are working with them.

Learn Data import and export - Linux Concept

Import and Export data

In this section you learn how import and export data. You will learn how to copy data between tables. You will also learn about loading data from files and importing data from external sources such as web services.

Learn Tables in Database - Linux Concept

Managing Tables

In this section you will look at managing tables. You will learn how many tables exist in a database, how to drop tables, rename tables and add indexes to tables.

Learn PostgreSQL Database - Linux Concept

Understanding PostgreSQL Constraint

In this section you explore constraints. You will learn what constraints are, how to define them and how to check whether a constraint exists.

Learn Data types - Linux Concept

PostgreSQL Data Types in Detail

In this section you look at all the data types available in PostgreSQL. We look at the most commonly used data types and their characteristics. We also look at the differences between character string and text data types.

Learn Regular Expression - Linux Concept

Conditional Expressions and Operators

In this section we look at conditional expressions and operators. We look at the various conditions that can be specified in these expressions. We also look at how to use logical operators like AND, OR and NOT.

Learn Utility - Linux Concept

PostgreSQL Utilities and PostgreSQL Recipes

In this section you learn how PostgreSQL utilities can be used to make our life easier when working with databases. We look at how to use pg_dump to backup and restore databases.