RDBMS-PostgreSQL/C2/Overview-of-RDBMS---PostgreSQL/English-timed
| Time | Narration |
| 00:01 | Welcome to the Spoken Tutorial on Overview of RDBMS - PostgreSQL. |
| 00:07 | In this tutorial, we will learn about:
RDBMS, 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,
IBM DB2, ORACLE, |
| 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-
Distinct, Between, |
| 05:00 | Like,
In, Is Null. |
| 05:05 | PostgreSQL built-in functions, otherwise called as aggregate functions. |
| 05:11 | The functions such as Count,
Sum, |
| 05:16 | Max ,
Min, Avg 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. |
