SQL may be a standard language for accessing and manipulating databases.
What is SQL?
- SQL stands for Structured command language
- SQL allows you to access and manipulate databases
- SQL is an ANSI (American National Standards Institute) standard
What Can SQL do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records during a database
- SQL can update records during a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables during a database
- SQL can create stored procedures during a database
- SQL can create views during a database
- SQL can set permissions on tables, procedures, and views
- SQL may be a Standard - BUT...
- Although SQL is an ANSI (American National Standards Institute) standard, there are different versions of the SQL language.
However, to be compliant with the ANSI standard, all of them support a minimum of the main commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.
Note: Most of the SQL database programs even have their own proprietary extensions added to the SQL standard!
Using SQL in Your internet site
To build an internet site that shows data from a database, you'll need:
- An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
- To use a server-side scripting language, like PHP or ASP
- To use SQL to urge the info you would like
- To use HTML / CSS
- RDBMS
- RDBMS stands for electronic database Management System.
RDBMS is that the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in RDBMS is stored in database objects called tables.
A table may be a collection of related data entries and it consists of columns and rows.