WEEK 7: WEB APPLICATION DEVELOPMENT (Database & SQL, Database integration, Redirecting Page)

Server side script (MySQL)

1. SQL Data Manipulation Language (DML)

• SELECT
• UPDATE
• DELETE
• INSERT INTO

2. SQL Data Definition Language( DDL)

• CREATE TABLE
• ALTER TABLE 
• DROP TABLE
• CREATE INDEX
• DROP INDEX

Basic select query

SELECT * FROM tablename

SELECT AuthorID, lastName FROM Authors;

DATABASE INTEGRATION

Advantage of using database to store web data

1. faster access
2. better concurrent access
3. easier change to data script
4. increased security

a