RDBMS PostgreSQL

By Prof Kannan Moudgalya - Principal Investigator of Spoken Tutorial Project | Indian Institute of Technology Bombay

Learners enrolled: 13618

This course comprises 9 audio-video spoken tutorials, using which you can self-learn RDBMS PostgreSQL with ease.

STEP 1-

First of all install RDBMS PostgreSQL by following the steps given in this sheet.

https://spoken-tutorial.org/RDBMS-PostgreSQL-Installation-Sheet-English.pdf/

This sheet gives the steps to install RDBMS-PostgreSQL on Linux and Windows OS.
Open the sheet, read the instructions for your OS and install RDBMS-PostgreSQL on your machine.
Cross-verify (as mentioned in the sheet) to confirm successful installation.
For Windows OS, please ensure Notepad ++ is also installed on the machine.

STEP 2-

Next, read this sheet. https://spoken-tutorial.org/RDBMS-PostgreSQL-Instruction-Sheet-English.pdf/

This sheet explains how to learn from spoken tutorials.
This sheet also mentions some important information about the text editors while coding, how to use the command prompt (in Windows OS), how to use the Code Files, how to do the Assignments, etc.
Read this sheet carefully and make a note of all the information, before you begin.

STEP 3-
Follow the side-by-side learning methodology while learning from spoken tutorials - watch the video, listen to the instructions, pause the video, try out the command on your system. You should get the exact same results as shown in the video. If successful, proceed with the video. Else, rewind and watch the video again and replicate the commands shown.

Complete all the videos in the given sequence one by one.
The Assignment for each tutorial is for your self-assessment only. Do not upload it anywhere for evaluation.

Summary

Course Status :	Upcoming
Course Type :	Elective
Duration :	Self Paced
Category :	Multidisciplinary
Credit Points :	1
Level :	Undergraduate/Postgraduate

Page Visits

Course layout

RDBMS PostgreSQL

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, PostgreSQL and Microsoft Access. In this series we are handling with PostgreSQL database.

The data in an RDBMS is stored in database objects which are called as tables. A table is a collection of related data entries and contains rows and columns to store data.

A field is a column in a table that maintains specific information about every record in the table. A row of table is called record. It contains the specific information of each individual entry in the table. A column is a vertical entity in the table which contains all information associated with a specific field in a table.

PostgreSQL is a powerful, open source relational database system. It runs on all major operating systems, including Linux, Windows and Mac OS. It supports most SQL data types, foreign keys, joins, views, triggers and stored procedures.. It has programming interfaces for C/C++, Java, Perl, Python, Ruby etc.

The Spoken Tutorial effort for RDBMS – PostgreSQL has been contributed by Nirmala Venkat from Spoken Tutorial project.

The domain review of this series is done by Prof. N.L.Sarda from IIT Bombay.

Learners: UG/PG CSE/IT/CS students to learn industry database management.

Click here for brochure