SQL standard
SQL standard could be a language for accessing and manipulating databases.
What is SQL?
SQL stands for Structured query language
SQL enables you to access and manipulate databases
SQL is associate ANSI (American National Standards Institute) standard
What will SQL do?
SQL will execute queries against a database
SQL will retrieve knowledge from a database
SQL will insert records in an exceedingly database
SQL will update records in an exceedingly database
SQL will delete records from a database
SQL will produce new databases
SQL will produce new tables in an exceedingly database
SQL will produce hold on procedures in an exceedingly database
SQL will produce views in an exceedingly database
SQL will set permissions on tables, procedures, and views
SQL could be a standard – however….
Although SQL is associate ANSI (American National Standards Institute) standard, there are totally different versions of the SQL language.
However, to be compliant with the ANSI standard, all of them support a minimum of the foremost commands (such as select, UPDATE, DELETE, INSERT, WHERE) in an exceedingly similar manner.
Using SQL in Your web site
To build an internet web site that shows data from a database, you may need:
associate RDBMS information program (i.e. MS Access, SQL Server, MySQL)
To use a server-side scripting language, like PHP or ASP
To use SQL to get the data you would like
To use HTML / CSS
