EESP Home Page
Introduction to Oracle SQL & PL/SQL

Relational databases are a vital part of everyday life. They are probably the most useful way to store, organize, and access data. There is no doubt that Oracle is a leader in providing Enterprise solutions for corporations, governmental agencies, and small companies through the relational database model. There is high demand for people with knowledge of (and experience with) the Oracle database management tools. This course serves as an introduction to Oracle, SQL (the fundamental language used to access an Oracle database), and SQL*Plus (an interface designed to assist with creating ad hoc reports through the use of SQL commands).

Courses
Winter 2009:  Introduction to Oracle: SQL and SQL*Plus
Spring 2009:  Introduction to Oracle:  PL/SQL Language

Upon completion of the program you will:
  • Have a good understanding of relational database concepts
  • Be able to create and maintain database tables as well as the data in the tables
  • Understand how to create and maintain other database objects
  • Be able to perform simple and complex SQL queries
  • Know how to use SQL*Plus to develop simple reports
This program is designed for:
  • Businesses, nonprofit organizations, government agencies or educational institutions seeking expertise in a database development platform product
  • IT professionals considering Oracle certification
  • Individuals working for organizations that rely on Oracle or are considering the purchase or migration to Oracle
  • DB professionals seeking to expand their database expertise to become multi-database experienced
  • Anyone wanting to study Oracle SQL and/or PL/SQL (Oracle’s programming language extension to SQL)


 

Mailing address: Western Washington University, MS 5293, 516 High Street, Bellingham, WA 98225   360.650.3308