What is SQL?

           Structured Query Language

* Identifying SQL*



SQL is the standard language for accessing data in a database.



This tutorial will explain how to use SQL to access and manipulate data in MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other databases.




* What is SQL?



* SQL stands for Structured Query Language.



* Allows access and handling of data in a SQL database.



* SQL is an ANSI (American National Standards Institute) standard.





* What can be done using SQL?



* SQL can run Query against databases.



* SQL can retrieve data from databases.



* SQL can add new records to databases.



* SQL can update records in databases.



* SQL can delete records in databases.



* SQL can create new databases.



* SQL can create new tables in databases.



* SQL can create storege procedures in databases.



* SQL can create displays of databases.



* SQL can set permissions for displaying and processing tables, procedures and ideas in a database.



* SQL is the standard. but ....*





Although SQL is an ANSI standard, there are instances where SQL language is used differently in different databases.



However, the main commands (commands like SELECT, UPDATE, DELETE, INSERT, WHERE) all support the same databases. Therefore, the ANSI standard only complies with the main commands.





 Most of the SQL database programs have their own long log in addition to the SQL standard extension!





* Using SQL in your websites... *





If you want to build a website that displays the data in the database,





* An RDBMS database program (ie MS Access, SQL Server, MySQL)



* Client scripting language, such as PHP or ASP, net,



* SQL helps you get and use the data you need.