Difference between revisions of "RDBMS-PostgreSQL/C2/Overview-of-RDBMS---PostgreSQL/English-timed"
PoojaMoolya (Talk | contribs) (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...") |
Sandhya.np14 (Talk | contribs) |
||
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 | + | | 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 | + | | An active community support is available to help solve issues when working with '''PostgreSQL'''. |
|- | |- | ||
| 01:53 | | 01:53 | ||
− | | '''PostgreSQL''' can be used by | + | | '''PostgreSQL''' can be used by programmers, project managers, system administrators and |
− | + | 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'''. | |
|- | |- | ||
Line 116: | Line 117: | ||
|- | |- | ||
| 02:54 | | 02:54 | ||
− | | It | + | | It will help us to understand how to connect to the '''server''', |
|- | |- | ||
| 02:59 | | 02:59 | ||
− | | | + | | create a new '''database''', |
− | + | create a new '''table''', | |
|- | |- | ||
| 03:04 | | 03:04 | ||
− | | | + | | add '''columns''' to the '''table''' and |
− | + | 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, | |
− | + | retrieve data, | |
|- | |- | ||
| 03:38 | | 03:38 | ||
− | | '''Data Redundancy''' | + | | '''Data Redundancy''', |
− | + | importance of '''primary keys '''and create a '''table '''with '''primary keys'''. | |
|- | |- | ||
Line 166: | Line 167: | ||
|- | |- | ||
| 04:01 | | 04:01 | ||
− | | The next tutorial is ''''Select | + | | The next tutorial is ''''Select' statement.''' |
− | This will help us to know how to write | + | This will help us to know how to write a basic '''Select statement'''. |
|- | |- | ||
| 04:11 | | 04:11 | ||
− | | '''Select''' with '''WHERE | + | | '''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 ''' | + | | 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 | + | | The next tutorial is about '''Foreign Key''' constraint. |
− | It explains the | + | 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'''. | |
|- | |- | ||
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 | + | | 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 | + | | 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 | + | | 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''' | + | | 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. | |
|- | |- | ||
| 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. |