Introduction to Oracle SQL & PL/SQL
June 20-22, 2002

Course Outline
Instructor
Who should attend
Date, time and place
Registration, fees and deadline
Certificate of Participation

Course Outline

• Introduction to Oracle RDBMS Structure
• SQL
  • Writing a basic SQL statement
  • Restricting and sorting data
  • Single row functions
  • Displaying data from multiple tables
  • Including constraints
  • Creating views
  • Other database objects
  • Controlling user access
• PL/SQL
  • Declaring variables
  • Writing executable statements
  • Interacting with the Oracle server
  • Writing control structures
  • Exception handling

[top]

Instructor

Mr. Mohammad Al Wazzan
Instructor
Software Institute
Lebanese American University

[top]

Who Should Attend

Expected participants are: Designers/developers, application developers, systems analysts, database administrators. Expected background is basic familiarity with data processing concepts and techniques.

[top]

Date, Time and Place

Date: June 20-22, 2002
Time:

• June 20 — 5:00 PM - 8:15 PM
• June 21 — 5:00 PM - 8:15 PM
• June 22 — 9:00 AM - 5:00 PM

Place: LAU, Beirut Campus, Sage Hall, 1st floor, Academic Computer Center.

[top]

Registration, Fees and Deadline

Registration fees are L.L. 45,000 per person, to be paid at LAU, Beirut, Business Office, Irwin Hall Ground Floor (opening hours are 9:00 AM - 12:00 PM and 1:30 PM - 3:00 PM).

The deadline for registration and payment is Wednesday June 12, 2002 or until the class is full (limited places).

You can reserve a place by sending an e-mail to si@lau.edu.lb. Afterwards, please register by filling out a registration form at the Business Office, LAU, Beirut Campus, upon payment of fees.

[top]

Certificate

A Certificate of Participation will be provided.

[top]