Lesson 2:
Introduction to SELECT statement
WHERE, FROM commands
BETWEEN, IN commands

Lesson 3:
Continuation of SELECT statement
LIKE, DISTINCT commands
DISTINCT commands

Lesson 4:
Continuation of SELECT statement
COUNT, MAX, MIN Functions
AVG, VARIANCE, STDDEV functions

Lesson 5:
Introduction to updating tables, joining tables
INSERT, UPDATE, DELETE Statement
JOIN Statement

Lesson 6:
Introduction to CREATE TABLE. Review
CREATE TABLE Statement
Materials

Lesson 2:
Introduction to Exception Handling, Stream and Files, Applets
Exception Handling, Stream and Files
Applets, Utility Classes

Lesson 3:
Introduction to AWT, Swing
AWT
Swing

Lesson 4:
Introduction to Multithreading, Collections
Multithreading
Collections (Data Structures)

Lesson 5:
Introduction to JDBC, Batch Update, Stored Procedures
JDBC
Batch Update, Stored Procedures

Lesson 6:
Introduction to Networking, Security. Review, practice complex programs
Networking, Security
Materials

Lesson 2:
Introduction to Oracle Installations
General Installation
Component Installation

Lesson 3:
Introduction to Oracle Database Maintenance
Configurations
Tuning

Lesson 4:
Continuation of Oracle Database Maintenance
Database Optimizations
Configuring systems and Oracle

Lesson 5:
Introduction to Prevention of Data loss
Backups
Database Recovery

Lesson 6:
Introduction to Oracle Networking. Review, practice complex Database performance
Oracle Networking
Materials

Lesson 2:
Introduction to Security and Monitoring in Oracle
Security
Monitoring

Lesson 3:
Introduction to Auditing in Oracle
AUDIT Statement
AUDIT Statement (Continuation)

Lesson 4:
Introduction to Query Optimizations
All kinds of Queries
Combining Queries

Lesson 5:
Introduction to Enterprise Java Beans (EJB)
EJB Architectures
EJB, JDBC and Oracle

Lesson 6:
Introduction to applications of Oracle Architecture in E-commerce. Review, practice complex programs.
E-commerce architecture and Oracle
Materials Review