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 wants 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 summarise. |
| 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 summarises 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. |
