What is SQL? What are its features?
https://www.computersprofessor.com/2017/09/what-is-sql-what-are-its-features.html
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.
Structure Query Language(SQL) is a programming
language used for storing and managing data in RDBMS. SQL was the first
commercial language introduced for E.F Codd's Relational model.
- QL 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
·
Every table is broken up into
smaller entities called fields. The fields in the Customers table consist of
CustomerID, CustomerName, ContactName, Address, City and PostalCode. A field is
a column in a table that is designed to maintain specific information about
every record in the table.
·
A record, also called a row, is
each individual entry that exists in a table. For example, there are 91 records
in the above Customers table. A record is a horizontal entity in a table.
·
A column is a vertical entity
in a table that contains all information associated with a specific field in a
table.
