Web Resources > Developing Your Site > Do It Yourself > SQL
SQL or Structured Query Language is a 4th generation programming language that allows you to access databases. SQL is the standard language for retrieving and updating data in databases. It also provides a means of creating databases. In general, SQL is portable. That is to say it has been standardized across all platforms. Therefore, once you learn SQL, you can use it on any platform.
|
Key
Points - SQL
|
 Industry
standard |
| Easy
to learn |
| Portable |
SQL works with relational databases. A relational database stores data in tables (relations). A database is a collection of tables. A table consists a list of records - each record in a table has the same structure, each has a fixed number of "fields" of a given type.
SQL also has commands to create tables, to add records, to delete records and to change the value of fields of existing records; you can specify read and write permissions for other users; you can commit and roll back transactions; you can add and delete fields from existing tables, specify indexes and create views.
Resources For SQL
SQL
Course - Online SQL tutorial
SQL
School - Online SQL tutorial
