Introduction to SQL ( Structured Query Language )

Structured Query Language

Q) What is database ?
A)  A database is a collection of data , By data we mean known facts that can be recorded and that have implicit meaning 

Q) Why we need database ?
A)  Database technology have a major impact on the growing use of computers . It is fair to say that database play a critical role in almost all area where computers are used  .

    Ex :- Banking ,Hotel management ,Library Catalog .

Q) What is SQL ? 

  •   SQL Stands for  Structural Query Language .
  •   SQL statements are used to perform tasks such as update data on a database, or retrieve data from  database.
  •   SQL is an ANSI (American National Standards Institute) standard .
  •   Almost most of the relational database management systems supports SQL  
               Ex :- Oracle db, MySql , SqlServer etc

Q)  What is DBMS ?
  •  DBMS Stands for Database Mangement System .
  •  DBMS is defined as the software program that is used to manage the databases

     Q) What is RDBMS ?
    • RDBMS Stands for Relational Database Mangement System .
    • RDBMS is defined as the software program that is used to manage the relational database .
    • The database system in which the relationships among different tables are maintained is called Relational Database Management System .

    No comments:

    Post a Comment