What
is SQL - Structured Query Language?
SQL (Structured Query Language) is defined as a
programming language for Relational Databases.
Features of SQL
1. It is designed over relational
algebra and tuple relational calculus.
2. SQL comes as a package with all major
distributions of RDBMS.
3. SQL consists of both data definition and data manipulation languages.
4. By
means of the data definition properties of SQL, one can design and modify
database schema, but data manipulation properties allows SQL to store and
retrieve data from database.
Data
Manipulation Language in SQL
SQL is furnished with data manipulation language (DML). DML is in charge for all forms of data modification in a database. DML modifies
or amends the database instance by inserting, updating, and deleting its data. SQL has the
following set of commands in its DML section:
1. SELECT/FROM/WHERE
2. INSERT INTO/VALUES
3. UPDATE/SET/WHERE
4. DELETE FROM/WHERE
These basic constructs let database programmers and users to input data
and information into the database and retrieve efficiently using a number of
filter options.
No comments:
Post a comment