Course Objectives
Specific subject areas to be explored and objectives to be reached are:
• A summation of relational database principles and an introduction to the Oracle relational database server. • Using the iSQL*Plus web-based database interface and other traditional interfaces. • Writing simple SQL queries and moderately complex SQL queries using various join techniques. • Summarizing, grouping and sorting data. • Advanced query techniques such as correlated sub queries. • Developing simple SQL*Plus reports. • Creating and maintaining database tables. • Taking advantage of new features such as the use of regular expressions. |