database_09.pptVIP

Copyright 2005 Radian Publishing Co. Chapter 9 SQL and RDBMS Part C - SQL Contents Chapter 9 SQL and RDBMS 9.1 What is SQL 9.1 A. DDL 9.1 B. DML 9.1 C. DCL 9.2 SQL and RDBMS 9.2 A. MS Access 97, 2003 and Visual FoxPro 9.2 B. MySQL 9.3 Creating a Database 9.4 Creating a Table 9.5 Creating a Table with Constraints 9.6 Filling Table with Data 9.7 Other DDL Commands Chapter 9 SQL and RDBMS SQL Structured Query Language A relational database management system (RDBMS) fully supports SQL 9.1 What is SQL Set-oriented SQL processes sets of data in groups Non-procedural SQL does not care about how the result is obtained but it stresses on what result will be obtained SQL commands can be classified into three types: Data Definition Language (DDL) commands Data Manipulation Language (DML) commands Data Control Language (DCL) commands 9.1 A. DDL DDL are used to create, alter and delete tables, views and indexes DDL commands CREATE DATABASE DROP DATABASE CREATE TABLE DROP TABLE ALTER TABLE CREATE INDEX DROP INDEX CREATE VIEW DROP VIEW 9.1 B. DML (1/2) DML are used to update, insert, modify and query the data in the database DML commands SELECT INSERT UPDATE DELETE 9.1 B. DML (2/2) The reasons for writing programs to issue SQL commands are meeting specific needs of an organisation providing interface for users who do not know SQL handling errors enforce database security 9.1 C. DCL DCL commands help DBA to control and maintain the database, including GRANT, ALTER USER etc. 9.2 SQL and RDBMS The SQL standards are promoted by two standards organisations: The American National Standards Institute (ANSI) International Standards Organisation (ISO) In the textbook, ANSI-92 (launched in 1992) will be used. Proprietary Extensions mean including extension to the standards, like ANSI-92. 9.2 A. Microsoft software Access? 97 Access? 2003 Visual FoxPro? 5.0 9.2 B. MySQL MySQL open source RDBMS product possible for anyone to use and