This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.
Course Objectives
This course covers the following elements:
- 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
- Write simple SQL queries and moderately complex SQL queries using various join techniques
- Summarize, group and sort data
- Advanced query techniques such as correlated sub queries
- Developing simple SQL *Plus reports
- Create and maintain database tables
- Taking advantages of new features such as the use of regular expressions
Course Benefits
Upon successful completion of this course students will be able to:
- Understand Oracle relational database principles
- Use the iSQL *Plus web based database interface and other traditional interfaces
- Write simple SQL queries and moderately complex SQL queries using various join techniques
- Summarize, group and sort data
- Advance query techniques such as correlated sub queries
- Develop simple SQL *Plus reports
- Create and maintain database tables
- Take advantage of new features such as the use of regular expressions