Scribd
Upload
53 views1 page

Dbsa

SQL is the standard language used to interact with relational database management systems (RDBMS) by enabling users to access, manage, and modify data in relational databases using commands that can create, query, update, or delete tables, rows, and databases. SQL commands are classified into categories like data definition language to create and modify database structures, data manipulation language to insert and manipulate data, and data control language to manage user permissions and access.

Uploaded by

Dark world
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
53 views1 page

Dbsa

SQL is the standard language used to interact with relational database management systems (RDBMS) by enabling users to access, manage, and modify data in relational databases using commands that can create, query, update, or delete tables, rows, and databases. SQL commands are classified into categories like data definition language to create and modify database structures, data manipulation language to insert and manipulate data, and data control language to manage user permissions and access.

Uploaded by

Dark world
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL is the language used by RDBMS for data base interaction.

It
enables the user to access and mange the relational database.

All task related to relational data management creating tables,


Quaring the data base for information ,modifying the data in the
database, deleting them, granting acess to user and so on can be
easily performed using SQL.

SQL COMMANDS:-

SQL statement can be used to create modifying and delete the data
base tables ,query the data in tables insert data in to the table,
modifying and delete the data , control acess to the data and so on.
An SQL in a simple set of instruction to the RDBMS to perform an
action. It contains reserve words ,and has a specific [Link]
statement can bcoadly classified in to the following categories.

I. Data definition language (DDL)


II. Data manipulation language (DML)
III. Data query language (DQL)
IV. Data control language(DCL)
V. Data administration language (DAL)
VI. Transaction control statement(TCS)

DATA DEFINATION LANGUAGE:-

The data base object can be created , altered or deleted using DDL
.The commands

You might also like