NORTHERN VIRGINIA COMMUNITY COLLEGE

ANNANDALE CAMPUS

COMMUNITY EDUCATION

Course Title : ORACLE SQL 11G

Instructor ; Hung Vu (W) (202) 283-8793 ( C) (202) 498 9785 (C) (703) 835-0555

home page : http://www.nvcc.edu/home/hvu

Class Description:

Learn the theoretical and practical foundation concepts of the relational database and ANSI standard SQL. The Oracle relational database query language SQL*Plus set thru Oracle version 11g will be discussed and used as tools to reinforce new knowledge. Upon completion, you’ll be able to define database structure, construct database tables, set up constraints, make ad hoc queries and manipulate and access data from the database. You’ll acquire an extensive knowledge of building relational database tables and in writing SQL scripts to manipulate data and generate reports. User creating and managing, new constraints in creating tables and new features from Object-Relational database in Oracle Version 11g will also be discussed.

Student Assessment:

* Students will be awarded 4.02 CEU after class completion

* Attendance requirements : At least 90% of lecture

Course Prerequisite :

None

Course Methodology :

This course covers fundamental concepts on Oracle 11G Relational Database concepts. Lecture and practical examples will be covered. Labs will be used to consolidate material covered.

Course Materials:

Handouts and Labs prepared by instructor

Reference Book

Textbook: Oracle Database 11g: The Complete Reference, by Kevin Loney, ISBN : 978-0-07-159875-0

CLASS SCHEDULE

SESSION 1 : UNIT I. INTRODUCTION TO RELATIONAL DATABSEE

1. Conventional File structure and problems

2. Relational Database

3. RDBMS Benefits

4. RDBMS Concepts

5. RDBMS Generations & Features

6. SQL Editing Commands

SESSION 2 : UNIT II. RDBMS TABLES

1. CREATE TABLE Statement

2. RDBMS Tables and Constraints

3. Set Up Constraints

4. Rules for Naming Tables and Columns

5. ALTER TABLE statement

6. INSERT statement

7. DELETE and UPDATE statements

SESSION 3/4/5/6

: UNIT III. SQL 10G SELECTED SQL examples

SESSION 7 : UNIT IV. REPORT and SQL

1. Formatting Columns

2. Break and Order Clauses

3. Compute Statement

4. A Sample Command File

5. Output report

6. Top Title and Bottom Title

7. Set Commands

8. Group Functions

9. Substitution

SESSION 8 : UNIT V. VIEW, INDEX and SEQUENCE

1. Crate View

2. Create Index

3. Create Sequence

4. Set Operations

SESSION 9/10 : UNIT VI. OBJECT-RELATIONAL DATABASE

1. Basic Concepts

2. Structure of Object

3. Object-Related Benefits

4. System tables