4.1 SQL Overview

The components of SQL are
a. Data Manipulation Language – Consists of SQL statements for operating on the data (Inserting, Modifying, Deleting and Retrieving Data) in tables which already exist.
b. Data Definition Language – Consists of SQL statements for defining the schema (Creating, Modifying and Dropping tables, indexes, views etc.)
c. Data Control Language – Consists of SQL statements for providing and revoking access permissions to users
Tables used:

Ord_Aug Ord# OrdDate Cust# 101 02-AUG-94 002 102 11-AUG-94 003 103 21-AUG-94 003 104 28-AUG-94 002 105 30-AUG-94 005

Items Item# Descr Price HW1 Power Supply 4000 HW2 101- Keyboard 2000 HW3 Mouse 800 SW1 MS-DOS 6.0 5000 SW2 MS-Word 6.0 8000

Customers Cust# CustName City 001 Shah Bombay 002 Srinivasan Madras 003 Gupta Delhi 004 Banerjee Calcutta 005 Apte Bombay

More Topis to Read

• 4.2.1Data Manipulation Language-SELECT
• 4.2.1.1 General SELECT statements
• 4.2.1.2 Nested SELECT statements
• 4.2.1.3 Date Arithemetic Arithmetic Expressions
• 4.2.1.4 Numeric Functions
• 4.2.1.5 Date Functions
• 4.2.1.6 Character Expressions & Functions
• 4.2.2 The INSERT statement
• 4.2.3 The UPDATE statement
• 4.2.4 The DELETE statement
• 4.3 Data Definition Language
• 4.4 Data Control Language