Difference between revisions of "RDBMS-PostgreSQL/C2/Overview-of-RDBMS---PostgreSQL/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with " {| border=1 | '''Time''' | '''Narration''' |- | 00:01 | Welcome to the''' Spoken Tutorial''' on''' Overview of RDBMS - PostgreSQL''' |- | 00:07 | In this tutorial, w...")
 
 
Line 6: Line 6:
 
|-  
 
|-  
 
| 00:01
 
| 00:01
| Welcome to the''' Spoken Tutorial''' on''' Overview of RDBMS - PostgreSQL'''  
+
| Welcome to the''' Spoken Tutorial''' on''' Overview of RDBMS - PostgreSQL'''.
  
 
|-  
 
|-  
Line 12: Line 12:
 
| In this tutorial, we will learn about:  
 
| In this tutorial, we will learn about:  
  
'''RDBMS'''  
+
'''RDBMS''',
  
features of '''PostgreSQL''' and the content available in various tutorials under this series  
+
features of '''PostgreSQL''' and the content available in various tutorials under this series.
  
 
|-  
 
|-  
 
| 00:20
 
| 00:20
| For this tutorial, I am using: '''Ubuntu Linux '''14.04 operating system  
+
| For this tutorial, I am using:  
 +
'''Ubuntu Linux '''14.04 operating system,
  
'''PostgreSQL 9.3.x'''  
+
'''PostgreSQL 9.3.x''',
  
 
'''pgAdmin 1.18'''  
 
'''pgAdmin 1.18'''  
Line 36: Line 37:
 
|-  
 
|-  
 
| 00:48
 
| 00:48
|  '''RDBMS''' stands for '''Relational Database Management System'''  
+
|  '''RDBMS''' stands for '''Relational Database Management System'''.
  
 
|-  
 
|-  
 
| 00:53
 
| 00:53
|  '''RDBMS '''is a program that helps to create, update and manage database.  
+
|  '''RDBMS '''is a program that helps to create, '''update''' and manage database.  
  
 
|-  
 
|-  
 
| 01:00
 
| 01:00
| '''MS SQL Server'''  
+
| '''MS SQL Server''',
  
'''IBM DB2'''  
+
'''IBM DB2''',
  
'''ORACLE'''  
+
'''ORACLE''',
  
 
|-  
 
|-  
 
| 01:06
 
| 01:06
|  '''My-SQL '''and''' '''
+
|  '''My-SQL '''and  
  
 
'''Microsoft Access'''  
 
'''Microsoft Access'''  
Line 64: Line 65:
 
|-  
 
|-  
 
| 01:19
 
| 01:19
|  '''PostgreSQL''' is the most advanced open source '''database management system.'''  
+
|  '''PostgreSQL''' is the most advanced '''open source''' '''database management system.'''  
  
 
|-  
 
|-  
 
| 01:25
 
| 01:25
|  It can run on various platforms such as '''Linux, Windows '''and '''Mac Operating System.'''  
+
|  It can '''run''' on various platforms such as '''Linux, Windows '''and '''Mac Operating System.'''  
  
 
|-  
 
|-  
Line 76: Line 77:
 
|-  
 
|-  
 
| 01:37
 
| 01:37
| We can define our own '''data types, index types''' and develop a custom plugin to meet our requirement.  
+
| We can define our own '''data type'''s, '''index''' types and develop a '''custom plugin''' to meet our requirement.  
  
 
|-  
 
|-  
 
| 01:45
 
| 01:45
| An active community support is available to help solve issues, when working with '''PostgreSQL'''.  
+
| An active community support is available to help solve issues when working with '''PostgreSQL'''.  
  
 
|-  
 
|-  
 
| 01:53
 
| 01:53
| '''PostgreSQL''' can be used by  Programmers, Project Managers, System Administrators and  
+
| '''PostgreSQL''' can be used by  programmers, project managers, system administrators and  
  
Any software professional, who wants to build products, websites, tools, etc.  
+
any software professional, who want to build products, websites, tools, etc.  
  
 
|-  
 
|-  
Line 98: Line 99:
 
|-  
 
|-  
 
| 02:24
 
| 02:24
|  Installation of '''pgAdmin'''.
+
|  Installation of '''pgAdmin''',
  
Setting the password and How to connect and disconnect from the '''server'''.  
+
setting the password and how to connect and disconnect from the '''server'''.  
  
 
|-  
 
|-  
Line 116: Line 117:
 
|-  
 
|-  
 
| 02:54
 
| 02:54
| It''' '''will help us to understand how to  Connect to the '''server'''  
+
| It will help us to understand how to  connect to the '''server''',
  
 
|-  
 
|-  
 
| 02:59
 
| 02:59
Create a new '''database'''  
+
create a new '''database''',
  
Create a new '''table'''  
+
create a new '''table''',
  
 
|-  
 
|-  
 
| 03:04
 
| 03:04
Add '''columns''' to the '''table''' and  
+
add '''columns''' to the '''table''' and  
  
Common '''data types''' used in '''PostgreSQL'''.  
+
common '''data types''' used in '''PostgreSQL'''.  
  
 
|-  
 
|-  
Line 144: Line 145:
 
|-  
 
|-  
 
| 03:33
 
| 03:33
| Here we will learn to  
+
| Here we will learn to:
  
Insert data  
+
insert data,
  
Retrieve data  
+
retrieve data,
  
 
|-  
 
|-  
 
| 03:38
 
| 03:38
|  '''Data Redundancy'''  
+
|  '''Data Redundancy''',
  
Importance of '''primary keys '''and  Create a '''table '''with '''primary keys'''  
+
importance of '''primary keys '''and  create a '''table '''with '''primary keys'''.
  
 
|-  
 
|-  
Line 166: Line 167:
 
|-  
 
|-  
 
| 04:01
 
| 04:01
| The next tutorial is ''''Select statement'.'''  
+
| The next tutorial is ''''Select' statement.'''  
  
This will help us to know how to write  A basic '''Select statement'''  
+
This will help us to know how to write  a basic '''Select statement'''.
  
 
|-  
 
|-  
 
| 04:11
 
| 04:11
|  '''Select''' with '''WHERE clause'''  
+
|  '''Select''' with '''WHERE''' clause,
  
'''Select''' with '''relational operators'''  
+
'''Select''' with '''relational operators''',
  
 
|-  
 
|-  
 
| 04:16
 
| 04:16
|  '''Select''' with '''logical operators'''  
+
|  '''Select''' with '''logical operators''',
  
'''Alias''' for '''column''' names  
+
'''Alias''' for '''column''' names.
  
 
|-  
 
|-  
Line 196: Line 197:
 
|-  
 
|-  
 
| 04:52
 
| 04:52
| First, it covers more '''clauses''' that can be used with the '''select statement, '''such as-  
+
| First, it covers more '''clause'''s that can be used with the '''select '''statement, such as-  
  
'''Distinct'''  
+
'''Distinct''',
  
'''Between'''  
+
'''Between''',
  
 
|-  
 
|-  
 
| 05:00
 
| 05:00
| '''Like'''  
+
| '''Like''',
  
'''In'''  
+
'''In''',
  
'''Is Null'''  
+
'''Is Null'''.
 
   
 
   
 
|-  
 
|-  
Line 216: Line 217:
 
|-  
 
|-  
 
| 05:11
 
| 05:11
| The '''functions''' such as  '''Count'''  
+
| The '''functions''' such as  '''Count''',
  
'''Sum'''  
+
'''Sum''',
  
 
|-  
 
|-  
 
| 05:16
 
| 05:16
| '''Max '''  
+
| '''Max ''',
  
'''Min'''  
+
'''Min''',
  
 
'''Avg'''  
 
'''Avg'''  
Line 240: Line 241:
 
|-  
 
|-  
 
| 05:43
 
| 05:43
| The next tutorial is about '''Foreign Key constraint.'''  
+
| The next tutorial is about '''Foreign Key''' constraint.
  
It explains the  Importance of using foreign keys
+
It explains the  importance of using '''foreign key'''s.
  
 
|-  
 
|-  
 
| 05:51
 
| 05:51
|  Example to demonstrate the '''parent '''and '''child table relationship'''  
+
|  Example to demonstrate the '''parent '''and '''child table relationship'''.
  
 
|-  
 
|-  
Line 252: Line 253:
 
|  '''Alter table command''' to modify the existing '''table''' structure and
 
|  '''Alter table command''' to modify the existing '''table''' structure and
  
Different types of '''constraints'''  
+
different types of '''constraints'''.
  
 
|-  
 
|-  
Line 270: Line 271:
 
| Here we will learn about  
 
| Here we will learn about  
  
'''Group by '''  
+
'''Group by ''',
 
   
 
   
 
'''Having '''and  
 
'''Having '''and  
  
'''Order by clauses'''  
+
'''Order by clauses'''.
  
 
|-  
 
|-  
Line 286: Line 287:
 
|-  
 
|-  
 
|07:01
 
|07:01
| The last tutorial in the basic level of this series, is '''Updating Data.'''  
+
| The last tutorial in the basic level of this series is '''Updating Data.'''  
  
 
|-  
 
|-  
Line 308: Line 309:
 
|-  
 
|-  
 
| 07:27
 
| 07:27
| This brings us to the end of this tutorial. Let us summarise.  
+
| This brings us to the end of this tutorial. Let us summarize.  
  
 
|-  
 
|-  
Line 316: Line 317:
 
|-  
 
|-  
 
| 07:42
 
| 07:42
| The video at the following link summarises the Spoken Tutorial project.  
+
| The video at the following link summarizes the '''Spoken Tutorial''' project.  
  
 
Please download and watch it.  
 
Please download and watch it.  
Line 322: Line 323:
 
|-  
 
|-  
 
|07:50
 
|07:50
| The''' Spoken Tutorial Project''' Team:  conducts workshops and gives certificates  
+
| The''' Spoken Tutorial Project''' team:  conducts workshops and gives certificates.
  
 
For more details, please write to us.  
 
For more details, please write to us.  
Line 330: Line 331:
 
|  Do you have questions in THIS Spoken Tutorial?  
 
|  Do you have questions in THIS Spoken Tutorial?  
  
Please visit this site  
+
Please visit this site.
  
 
|-  
 
|-  
 
| 08:04
 
| 08:04
| Choose the minute and second where you have the question  
+
| Choose the minute and second where you have the question,
  
Explain your question briefly  
+
explain your question briefly.
  
 
|-  
 
|-  
 
| 08:10
 
| 08:10
|  Someone from our team will answer them  
+
|  Someone from our team will answer them.
  
 
|-  
 
|-  
 
| 08:14
 
| 08:14
|  The Spoken Tutorial forum is for specific questions on this tutorial  
+
|  The '''Spoken Tutorial forum''' is for specific questions on this tutorial.
  
Please do not post unrelated and general questions on them  
+
Please do not post unrelated and general questions on them.
  
 
|-  
 
|-  
 
| 08:23
 
| 08:23
|  This will help reduce the clutter  
+
|  This will help reduce the clutter.
  
With less clutter, we can use these discussion as instructional material  
+
With less clutter, we can use these discussion as instructional material.
  
 
|-  
 
|-  
 
| 08:32
 
| 08:32
| Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.  
+
| Spoken Tutorial project is funded by '''NMEICT, MHRD''', Government of India.  
  
 
More information on this mission is available at this link.  
 
More information on this mission is available at this link.  

Latest revision as of 12:01, 1 February 2019

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.

Contributors and Content Editors

PoojaMoolya, Sandhya.np14