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

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