From Script | Spoken-Tutorial
Jump to: navigation, search
Time Narration
00:01 Welcome to the Spoken Tutorial on Overview of RDBMS - PostgreSQL.
00:07 In this tutorial, we will learn about:


features of PostgreSQL and the content available in various tutorials under this series.

00:20 For this tutorial, I am using:

Ubuntu Linux 14.04 operating system,

PostgreSQL 9.3.x,

pgAdmin 1.18

00:34 To follow this tutorial, you should have good understanding of basic computer concepts and

working knowledge of any programming language.

00:44 First, let us learn about RDBMS.
00:48 RDBMS stands for Relational Database Management System.
00:53 RDBMS is a program that helps to create, update and manage database.
01:00 MS SQL Server,



01:06 My-SQL and

Microsoft Access

are some of the software based on RDBMS.

01:14 Next, let us see some of the key features of the PostgreSQL.
01:19 PostgreSQL is the most advanced open source database management system.
01:25 It can run on various platforms such as Linux, Windows and Mac Operating System.
01:32 It requires minimum maintenance because of its stability.
01:37 We can define our own data types, index types and develop a custom plugin to meet our requirement.
01:45 An active community support is available to help solve issues when working with PostgreSQL.
01:53 PostgreSQL can be used by programmers, project managers, system administrators and

any software professional, who want to build products, websites, tools, etc.

02:09 Now, we will briefly go through the individual tutorials in this series.
02:15 The first tutorial in this series explains- Installation of PostgreSQL in Ubuntu Linux and Windows.
02:24 Installation of pgAdmin,

setting the password and how to connect and disconnect from the server.

02:34 Here is a glimpse of the tutorial.
-----Add the Audio------
02:49 The next tutorial is 'Create database using PgAdmin'.
02:54 It will help us to understand how to connect to the server,
02:59 create a new database,

create a new table,

03:04 add columns to the table and

common data types used in PostgreSQL.

03:10 Let us have a look at this tutorial.
-----Add the Audio------
03:29 The next tutorial is 'Table with Primary keys'.
03:33 Here we will learn to:

insert data,

retrieve data,

03:38 Data Redundancy,

importance of primary keys and create a table with primary keys.

03:46 Here is a glimpse of the tutorial.
-------Add the audio--------
04:01 The next tutorial is 'Select' statement.

This will help us to know how to write a basic Select statement.

04:11 Select with WHERE clause,

Select with relational operators,

04:16 Select with logical operators,

Alias for column names.

04:22 Let me play this tutorial.
-------Add the audio--------
04:47 The next tutorial will explain the Aggregate functions in select statement.
04:52 First, it covers more clauses that can be used with the select statement, such as-



05:00 Like,


Is Null.

05:05 PostgreSQL built-in functions, otherwise called as aggregate functions.
05:11 The functions such as Count,


05:16 Max ,



are covered later, in this tutorial.

05:23 Let's have a look at this tutorial.
-------Add the audio--------
05:43 The next tutorial is about Foreign Key constraint.

It explains the importance of using foreign keys.

05:51 Example to demonstrate the parent and child table relationship.
05:56 Alter table command to modify the existing table structure and

different types of constraints.

06:04 Here is a glimpse of the tutorial.
-------Add the audio--------
06:28 The next tutorial will explain the Aggregation facilities in SQL statements.
06:34 Here we will learn about

Group by ,

Having and

Order by clauses.

06:42 Let's have a look at this tutorial.
-------Add the audio--------
07:01 The last tutorial in the basic level of this series is Updating Data.
07:06 It will explain how to update data and delete data.
07:11 Here we will learn how to use

Update statement and Delete statement

07:18 Here is a glimpse of the tutorial.
-------Add the audio--------
07:27 This brings us to the end of this tutorial. Let us summarize.
07:32 In this tutorial, we learnt about RDBMS - PostgreSQL and went through the tutorials in this series.
07:42 The video at the following link summarizes the Spoken Tutorial project.

Please download and watch it.

07:50 The Spoken Tutorial Project team: conducts workshops and gives certificates.

For more details, please write to us.

07:59 Do you have questions in THIS Spoken Tutorial?

Please visit this site.

08:04 Choose the minute and second where you have the question,

explain your question briefly.

08:10 Someone from our team will answer them.
08:14 The Spoken Tutorial forum is for specific questions on this tutorial.

Please do not post unrelated and general questions on them.

08:23 This will help reduce the clutter.

With less clutter, we can use these discussion as instructional material.

08:32 Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

08:43 This is Nirmala Venkat from IIT Bombay, signing off. Thanks for watching.

Contributors and Content Editors

PoojaMoolya, Sandhya.np14