View source for RDBMS-PostgreSQL/C2/Overview-of-RDBMS---PostgreSQL/English-timed


{| border=1
|  '''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. 

|}