What is SQL ?
- SQL is the abbreviation of structured query language
- SQL is used to access and control/manage databases
- SQL is a standard called ANSI (American National Standards Institute)
What actions SQL may perform in a database?
- SQL may create new tables
- SQL may create stored procedures
- SQL may create views
- SQL may execute query
- SQL may fetch data
- SQL may insert records
- SQL may update records
- SQL may delete records
- SQL may create new databases
- SQL may set permissions on tables, procedures, and views
The base of SQL is RDBMS, which is the abbreviation of "Relational Database Management System" and this is also a base for all modern database systems like MS SQL, MySQL, IBM DB2, Oracle and Microsoft Access.
In RDBMS the storage of data is in database objects that are called tables.
A table in this case is a collections that has related data entries and its structure is made of rows and columns.
No comments:
Post a Comment