SQL (Database app)

SQL (Database app)

INTRODUCTION
• SQL is based on the standard language for manipulating, storing and retrieving data into
database.
• Structure query language is the standards for relational database system. there are
different types of RDBMS such as MS Access, MySQL, Postgres, MS Access and SQL
server.

Why use SQL in database
• SQL is the most popular and suitable for database creation because they provide various
facilities to user.
• It allow for user to access data in the relational database management system.
• It allow for user to define and manipulate data in proper manner.
• It useful for embedded with other standard language such as pre-complier, SQL modules
and other libraries.

Cont.
• It allow for user to create and drop database and multiple table by using SQL commands.
• It allow for user to set permissions on procedures, views and tables.
• It allow for user to perform different function in database and create, stored procedure
for further development.
• It useful for user to set up specific permission on table, views and procedures.