RDBMS
RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, PostgreSQL and Microsoft Access. In this series we are handling with PostgreSQL database.
The data in an RDBMS is stored in database objects which are called as tables. A table is a collection of related data entries and contains rows and columns to store data.
A field is a column in a table that maintains specific information about every record in the table. A row of table is called record. It contains the specific information of each individual entry in the table. A column is a vertical entity in the table which contains all information associated with a specific field in a table.
PostgreSQL is a powerful, open source relational database system. It runs on all major operating systems, including Linux, Windows and Mac OS. It supports most SQL data types, foreign keys, joins, views, triggers and stored procedures.. It has programming interfaces for c/c++, Java, Perl, Python, Ruby etc.
The Spoken Tutorial Effort for RDBMS – PostgreSQL has been contributed by Nirmala Venkat from Spoken Tutorials.
The domain review of this series is done by Prof. N.L.Sarda from IIT Bombay.
Contents
Basic Level
- Installation of PostgreSQL
- Installation of PostgreSQL on Linux
- Installation of PostgreSQL on Windows
- Installation of PgAdmin
- Connect to PostgreSQL database
- Set password for the database
- Show the current user and current date
- Disconnect from the server
- Create database using PgAdmin
- How to connect to the server
- Introduction to database and its objects
- How to create a database
- Table and its attributes
- PgAdmin Interface
- How to create a table
- Various data types
- Create table syntax
- Table with Primary keys
- Insert single row to the table
- Insert Multiple Row to the table
- How to execute the query
- Retrieve the data using select statement
- Introduction to Primary keys
- Rules to define a Primary key
- Data redundancy
- How to prevent duplication of data
- Create a table with primary keys
- Drop table
