The Tutorials in this series are created in PostgreSQL 9.5.12 on Ubuntu 14.04. PostgreSQL is a open source relational database system. It runs on operating systems such as Linux, windows and Mac OS. It supports all major features like primary key, foreign keys, complex queries, aggregate functions, triggers, views, index, procedural languages etc. Read more
Foss : RDBMS PostgreSQL - English
Outline: Introduction to RDBMS Common Software based on RDBMS Prerequisites for learning PostgreSQL OS and PostgreSQL version used Features of PostgreSQL Who can use PostgreSQL? Glimp..
Outline: Installation of PostgreSQL on Linux Installation of PostgreSQL on Windows Installation of pgAdmin Connect to PostgreSQL database Set Password for the database Disconnect from ..
Outline: How to connect to the server Introduction to database and its objects How to create a database Table and its attributes pgAdmin interface. New server registration How to crea..
Outline: Insert single row to the table Insert multiple rows to the table How to execute the query Retrieve the data using select statement Introduction to Primary key Rules to define ..
Outline: View data in the Edit data window Insert records in the Edit data window Inserting a NULL value in a record Basic SELECT statement SELECT statement with WHERE clause Compariso..
Outline: DISTINCT clause in SELECT statement How to use BETWEEN operator in SELECT statement How to use LIKE operator in SELECT statement Usage of percent and underscore wildcards with e..
Outline: What is a Foreign key? Foreign key link between students and department table Create a parent table department Alter table command Add a new column to the existing students tab..
Outline: Aggregate functions What is Group by clause? Syntax for Group by clause Examples for using Group by clause with one/multiple columns Having clause Syntax for Having clause Ex..
Outline: Update statement Syntax for Update statement Examples for Update statement Updating multiple columns Syntax for Delete statement Examples for Delete statement Delete rows for..