Sandhya.np14 at 06:31, 1 February 2019

2019-02-01T06:31:53Z

PoojaMoolya: 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..."

2019-01-30T10:57:18Z

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..."

New page

{| 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.

|}

RDBMS-PostgreSQL/C2/Overview-of-RDBMS---PostgreSQL/English-timed - Revision history

Sandhya.np14 at 06:31, 1 February 2019

PoojaMoolya: 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..."