Monday 29 June 2015

Database Introduction

What is DBMS?

A database management system (DBMS) is a system that stores and retrieves information in a database. It is used to help you organize your data according to a subject, so that it is easy to track and verify your data, and you can store information about how different subjects are related, so that it makes it easy to bring related data together.

What is RDBMS? 

RDBMS stands for Relational Database Management System. It organizes data into related rows and columns.

Features:-

It stores data in tables.Tables have rows and column. These tables are created using SQL. And data from these tables are also retrieved us

What is SQL?

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. 

SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.
Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.

No comments:

Post a Comment