Scribd
Upload
5 views1 page

Key SQL Functions and Capabilities

SQL is a powerful language used for managing and manipulating databases. It can execute queries, retrieve, insert, update, and delete records, as well as create databases, tables, stored procedures, and views. Additionally, SQL allows for setting permissions on various database objects.

Uploaded by

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

Key SQL Functions and Capabilities

SQL is a powerful language used for managing and manipulating databases. It can execute queries, retrieve, insert, update, and delete records, as well as create databases, tables, stored procedures, and views. Additionally, SQL allows for setting permissions on various database objects.

Uploaded by

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

What Can SQL do?

• SQL can execute queries against a database

• SQL can retrieve data from a database

• SQL can insert records in a database

• SQL can update records in a database

• SQL can delete records from a database

• SQL can create new databases

• SQL can create new tables in a database

• SQL can create stored procedures in a database

• SQL can create views in a database

• SQL can set permissions on tables, procedures, and views

You might also like