Sunday 5 June 2016

STRUCTURED QUERY LANGUAGE

when talk about SQL, you are not strange to it.

So, have a revision of what is SQL?

SQL is a standard computer language for accessing and manipulating database.


SQL - DML  - SELECT, UPDATE, DELETE, INSERT INTO  (this is all data)
         - DDL  - CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, DROP         
                         INDEX (this is all table)



Advantage of using database to store web data
1. access faster
2. better concurrent access
3. easy change to data and scripts
4. increased security



No comments:

Post a Comment