What is SQL...
- SQL stands for Structured Query Language & allows you access & manipulate databases
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.
What Can SQL do?
- Create new databases / tables in a database
- Insert records in a database
- Retrieve data from a database
- Execute queries against a database
- Update records in a database
- Delete records from a database
- SQL can create stored procedures in a database
- Create views in a database
- Permissions on tables, procedures, and views
Although SQL is a standardized language, there are different variations of SQL . However, to be compliant with the ANSI standard, they all support the major commands (such as
SELECT,
DELETE, INSERT, UPDATE,
WHERE) in a similar fashion.
SQL statements are further classified depending on their function OR characteristic OR the way they are executed.
An SQL statement can be executed in two ways -either dynamically or statically. This blog thus shall focus on concepts of Dynamic SQL and Static/Embedded SQL.
Click on the topic name below to navigate to other pages
Good job
ReplyDeletegood job
ReplyDelete