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

From Script | Spoken-Tutorial
Jump to: navigation, search

>>Title of script: Overview of RDBMS-PostgreSQL

Author: Nirmala Venkat

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


Visual Cue Narration
Slide 1: Welcome to the Spoken Tutorial on Overview of RDBMS - PostgreSQL
Slide 2:

Learning objectives

In this tutorial, we will learn about:
  • RDBMS
  • features of PostgreSQL and
  • the content available in various tutorials under this series
Slide 3:

System Requirements

For this tutorial, I am using:
  • Ubuntu Linux 14.04 operating system
  • PostgreSQL 9.3.x
  • pgAdmin 1.18
Slide 4:

Pre-requisites

To follow this tutorial, you should have
  • good understanding of basic computer concepts and
  • working knowledge of any programming language.
Slide 5(a):

RDBMS

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.
Slide 5(b):

RDBMS - Example

  • MS SQL Server
  • IBM DB2
  • ORACLE
  • My-SQL and
  • Microsoft Access

are some of the software based on RDBMS.

Next, let us see some of the key features of the PostgreSQL.
Slide 6:

Features of PostgreSQL

* 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.
Slide 7:

Who can use PostgreSQL?

PostgreSQL can be used by
  • Programmers, Project Managers, System Administrators and
  • Any software professional, who wants to build products, websites, tools, etc.
Now, we will briefly go through the individual tutorials in this series.
Slide 8:

Installation of PostgreSQL

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.
Show Installation of PostgreSQL” tutorial. Here is a glimpse of the tutorial.
Slide 9:

Create database using PgAdmin

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.
Show “Create database using PgAdmin” tutorial Let us have a look at this tutorial.
Slide 10:

Table with Primary keys

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
Show “Table with Primary keys” tutorial Here is a glimpse of the tutorial.
Slide 11:

Select statement

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
Show “Select statement” tutorial Let me play this tutorial.
Slide 12(a):

Select with Aggregate functions

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
Slide 12(b):

Select with Aggregate functions

PostgreSQL built-in functions, otherwise called as aggregate functions.

The functions such as

  • Count
  • Sum
  • Max
  • Min
  • Avg

are covered later, in this tutorial.

Show “Select with Aggregate functions” tutorial Let's have a look at this tutorial.
Slide 13:

Foreign Key Constraint

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
Show “Foreign Key Constraint” tutorial Here is a glimpse of the tutorial.
Slide 14:

Aggregation facilities in SQL

The next tutorial will explain the Aggregation facilities in SQL statements.

Here we will learn about

  • Group by
  • Having and
  • Order by clauses
Show “Aggregation facilities in SQL” tutorial Let's have a look at this tutorial.
Slide 15:

Updating Data

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
Show “Updating data” tutorial Here is a glimpse of the tutorial.
This brings us to the end of this tutorial. Let us summarise.
Slide 14:

Summary

In this tutorial, we
  • learnt about RDBMS - PostgreSQL
  • and went through the tutorials in this series.
Slide 15:

About Spoken Tutorial project

The video at the following link summarises the Spoken Tutorial project.

Please download and watch it.

Slide 16:

Spoken Tutorial workshops

The Spoken Tutorial Project Team:
  • conducts workshops and
  • gives certificates

For more details, please write to us.

Slide 17:

Forum for specific questions

* 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
Slide 18

Forum for specific questions:

* 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
Slide 19:

Acknowledgement

Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

This is Nirmala Venkat from IIT Bombay, signing off. Thanks for watching.

Contributors and Content Editors

Nirmala Venkat