PostgreSQL Tutorial

PostgreSQL Tutorial

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. This tutorial will give you quick start with PostgreSQL and make you comfortable with PostgreSQL programming.

Audience

This tutorial has been prepared for the beginners to help them understand the basic to advanced concepts related to PostgreSQL Database.

Prerequisites

Before you start practicing with various types of examples given in this reference, I'm making an assumption that you are already aware of what a database is, especially RDBMS and what a computer language is.

PostgreSQL Tutorial

PostgreSQL - Home

PostgreSQL - Overview

PostgreSQL - Environment Setup

PostgreSQL - Syntax

PostgreSQL - Data Types

PostgreSQL - Create Database

PostgreSQL - Select Database

PostgreSQL - Drop Database

PostgreSQL - Create Table

PostgreSQL - Drop Table

PostgreSQL - Schema

PostgreSQL - Insert Query

PostgreSQL - Select Query

PostgreSQL - Operators

PostgreSQL - Expressions

PostgreSQL - Where Clause

PostgreSQL - AND & OR Clauses

PostgreSQL - Update Query

PostgreSQL - Delete Query

PostgreSQL - Like Clause

PostgreSQL - Limit Clause

PostgreSQL - Order By Clause

PostgreSQL - Group By

PostgreSQL - With Clause

PostgreSQL - Having Clause

PostgreSQL - Distinct Keyword

Advanced PostgreSQL

PostgreSQL - Constraints

PostgreSQL - Joins

PostgreSQL - Unions Clause

PostgreSQL - NULL Values

PostgreSQL - Alias Syntax

PostgreSQL - Triggers

PostgreSQL - Indexes

PostgreSQL - Alter Table Command

Truncate Table Command

PostgreSQL - Views

PostgreSQL - Transactions

PostgreSQL - Locks

PostgreSQL - Sub Queries

PostgreSQL - Auto Increment

PostgreSQL - Privileges

Date/Time Functions & Operators

PostgreSQL - Functions

PostgreSQL - Useful Functions

PostgreSQL Interfaces

PostgreSQL - C/C++

PostgreSQL - Java

PostgreSQL - PHP

PostgreSQL - Perl

PostgreSQL - Python

PostgreSQL Useful Resources

PostgreSQL - Quick Guide

PostgreSQL - Useful Resources

PostgreSQL - Discussion