PostgreSQL Tutorial for Beginners

PostgreSQL Tutorial for Beginners - student project

PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system. PostgreSQL was developed based on POSTGRES 4.2 at Berkeley Computer Science Department, University of California. PostgreSQL is free and open source software. Its source code is available under PostgreSQL license, a liberal open source license. You are free to use, modify and distribute PostgreSQL in any form.

All major operating systems support PostgreSQL, including Linux and Windows. It supports text, images, sounds, and video, and includes programming interfaces for C / C++, Java, Perl, Python, Ruby and Open Database Connectivity (ODBC).

Key Features:

PostgreSQL has many advanced features that other enterprise database management systems offer, such as:

  • Complex SQL queries
  • SQL Sub-selects
  • Foreign keys
  • Trigger
  • Views
  • Transactions
  • Multi-version concurrency control (MVCC)

This course has been prepared for the beginners and there is no prerequisite as such. Anyone can go through this course and understand the basics of PostgreSQL.

For the class project, you'll have to create a few tables in PostgreSQL database and fetch some rows out of them. The tables would be related to one another with foreign key. You will be required to use nested queries and joins to get the desired output.

Course Outline: