§ Class Slides 12: Databases

Class Slides 10: Programming Exercise II
Class Slides 12: JDBC (Java DataBase Connectivity)
Home

Slide 11.1: Oracle database management systems
Slide 11.2: Using SQL*Plus: the Oracle interface
Slide 11.3: Using SQL*Plus: the Oracle interface (cont.)
Slide 11.4: Using SQL*Plus: the Oracle interface (cont.)
Slide 11.5: Introduction to SQL
Slide 11.6: SQL (Structured Query Language)
Slide 11.7: The CREATE TABLE statement
Slide 11.8: The INSERT INTO statement
Slide 11.9: The SELECT statement
Slide 11.10: The SELECT statement
Slide 11.11: The WHERE clause
Slide 11.12: The WHERE clause (cont.)
Slide 11.13: The UPDATE statement
Slide 11.14: The DELETE and DROP statements
Slide 11.15: The ORDER BY keyword
Slide 11.16: The AND and OR keywords
Slide 11.17: The IN operator
Slide 11.18: The BETWEEN operator
Slide 11.19: Aliases
Slide 11.20: The UNION command
Slide 11.21: The SQL functions