Nirmala Venkat: Created page with "'''>>Title of script''':''' Overview of RDBMS-PostgreSQL''' '''Author: Nirmala Venkat''' '''Keywords:''' '''PostgreSQL, PgAdmin, RDBMS Features of postgreSQL, Overview, Vide..."

2017-11-23T07:29:30Z

Created page with "'''>>Title of script''':''' Overview of RDBMS-PostgreSQL''' '''Author: Nirmala Venkat''' '''Keywords:''' '''PostgreSQL, PgAdmin, RDBMS Features of postgreSQL, Overview, Vide..."

New page

'''>>Title of script''':''' Overview of RDBMS-PostgreSQL'''

'''Author: Nirmala Venkat'''

'''Keywords:''' '''PostgreSQL, PgAdmin, RDBMS Features of postgreSQL, Overview, Video tutorial'''

{| style="border-spacing:0;"
| style="background-color:#c0c0c0;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| '''Visual Cue'''
| style="background-color:#c0c0c0;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| '''Narration'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 1:

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Welcome to the''' Spoken Tutorial''' on''' Overview of RDBMS - PostgreSQL'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 2:

'''Learning objectives'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| In this tutorial, we will learn about:

* '''RDBMS'''
* features of '''PostgreSQL''' and
* the content available in various tutorials under this series

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 3:

'''System Requirements'''
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| For this tutorial, I am using:
* '''Ubuntu Linux '''14.04 operating system
* '''PostgreSQL 9.3.x'''
* '''pgAdmin 1.18'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 4:

'''Pre-requisites'''
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| To follow this tutorial, you should have

* good understanding of basic computer concepts and
* working knowledge of any programming language.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 5(a):

'''RDBMS'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| First, let us learn about '''RDBMS.'''

* '''RDBMS''' stands for '''Relational Database Management System'''
* '''RDBMS '''is a program that helps to create, update and manage database.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 5(b):

'''RDBMS - Example'''
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"|
* '''MS SQL Server'''
* '''IBM DB2'''
* '''ORACLE'''
* '''My-SQL '''and''' '''
* '''Microsoft Access'''

are some of the software based on '''RDBMS'''.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"|
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Next, let us see some of the key features of the''' PostgreSQL.'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 6:

'''Features of PostgreSQL'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| * '''PostgreSQL''' is the most advanced open source '''database management system.'''

* It can run on various platforms such as '''Linux, Windows '''and '''Mac OSX.'''

* It requires minimum maintenance because of its stability.

* We can define our own '''data types, index types''' and develop a custom plugin to meet our requirement.

* An active community support is available to help solve issues, when working with '''PostgreSQL'''.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 7:

'''Who can use PostgreSQL?'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| '''PostgreSQL''' can be used by

* Programmers, Project Managers, System Administrators and
* Any software professional, who wants to build products, websites, tools, etc.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"|
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Now, we will briefly go through the individual tutorials in this series.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 8:

Installation of '''PostgreSQL'''
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The first tutorial in this series explains-

* Installation of '''PostgreSQL''' in '''Ubuntu''' '''Linux''' and '''Windows'''.
* Installation of '''pgAdmin'''.
* Setting the password and
* How to connect and disconnect from the '''server'''.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“'''Installation of '''PostgreSQL”''' tutorial.
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Here is a glimpse of the tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 9:

'''Create database using PgAdmin'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The next tutorial is ''''Create database using PgAdmin'.'''

It''' '''will help us to understand how to

* Connect to the '''server'''
* Create a new '''database'''
* Create a new '''table'''
* Add '''columns''' to the '''table''' and
* Common '''data types''' used in '''PostgreSQL'''.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“Create database using PgAdmin”''' tutorial
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Let us have a look at this tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 10:

'''Table with Primary keys'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The next tutorial is ''''Table with Primary keys'. '''

Here we will learn to

* Insert data
* Retrieve data
* '''Data Redundancy'''
* Importance of '''primary keys '''and
* Create a '''table '''with '''primary keys'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“Table with Primary keys”''' tutorial
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Here is a glimpse of the tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 11:

'''Select statement'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The next tutorial is ''''Select statement'.'''

This will help us to know how to write

* A basic '''Select statement'''
* '''Select''' with '''WHERE clause'''
* '''Select''' with '''relational operators'''
* '''Select''' with '''logical operators'''
* '''Alias''' for '''column''' names

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“Select statement”''' tutorial
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Let me play this tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 12(a):

'''Select with Aggregate functions'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The next tutorial will explain the '''Aggregate functions''' in '''select statement.'''

First, it covers more '''clauses''' that can be used with the '''select statement, '''such as-

* '''Distinct'''
* '''Between'''
* '''Like'''
* '''In'''
* '''Is Null'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 12(b):

'''Select with Aggregate functions'''
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| '''PostgreSQL built-in functions,''' otherwise called as''' aggregate functions'''.

The '''functions''' such as

* '''Count'''
* '''Sum'''
* '''Max '''
* '''Min'''
* '''Avg'''

are covered later, in this tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“Select with Aggregate functions”''' tutorial
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Let's have a look at this tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 13:

'''Foreign Key Constraint'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The next tutorial is about '''Foreign Key constraint.'''

It explains the

* Importance of using foreign keys
* Example to demonstrate the '''parent '''and '''child table relationship'''
* '''Alter table command''' to modify the existing '''table''' structure
* Different types of '''constraints'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“Foreign Key Constraint”''' tutorial
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Here is a glimpse of the tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 14:

'''Aggregation facilities in SQL '''
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The next tutorial will explain the '''Aggregation facilities in SQL statements'''.

Here we will learn about

* '''Group by '''
* '''Having '''and
* '''Order by clauses'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“Aggregation facilities in SQL”''' tutorial
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Let's have a look at this tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 15:

'''Updating Data'''
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The last tutorial in the basic level of this series, is '''Updating Data.'''

It will explain how to update data and delete data.

Here we will learn how to use

* '''Update statement '''and
* '''Delete statement'''

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Show '''“Updating data”''' tutorial
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Here is a glimpse of the tutorial.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"|
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| This brings us to the end of this tutorial. Let us summarise.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 14:

'''Summary'''

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| In this tutorial, we

* learnt about '''RDBMS - PostgreSQL '''
* and went through the tutorials in this series.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 15:

About Spoken Tutorial project

| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The video at the following link summarises the Spoken Tutorial project.

Please download and watch it.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 16:

Spoken Tutorial workshops
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| The''' Spoken Tutorial Project''' Team:

* conducts workshops and
* gives certificates

For more details, please write to us.

|-
| style="background-color:#ffffff;border-top:1pt solid #000001;border-bottom:0.75pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 17:

Forum for specific questions
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0.097cm;padding-bottom:0.097cm;padding-left:0.206cm;padding-right:0.097cm;"| * Do you have questions in THIS Spoken Tutorial?
* Please visit this site
* Choose the minute and second where you have the question
* Explain your question briefly
* Someone from our team will answer them

|-
| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.078cm;padding-right:0.106cm;"| Slide 18

Forum for specific questions:

| style="background-color:#ffffff;border:0.75pt solid #000001;padding-top:0.106cm;padding-bottom:0.106cm;padding-left:0.078cm;padding-right:0.106cm;"| * The Spoken Tutorial forum is for specific questions on this tutorial
* Please do not post unrelated and general questions on them
* This will help reduce the clutter
* With less clutter, we can use these discussion as instructional material

|-
| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Slide 19:

Acknowledgement

| style="background-color:#ffffff;border-top:0.75pt solid #000001;border-bottom:1pt solid #000001;border-left:1pt solid #000001;border-right:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

|-
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"|
| style="background-color:#ffffff;border:1pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.062cm;padding-right:0.191cm;"| This is Nirmala Venkat from '''IIT Bombay''', signing off. Thanks for watching.

|}

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

Nirmala Venkat: Created page with "'''>>Title of script''':''' Overview of RDBMS-PostgreSQL''' '''Author: Nirmala Venkat''' '''Keywords:''' '''PostgreSQL, PgAdmin, RDBMS Features of postgreSQL, Overview, Vide..."