|
This course provides questions to prepare users who plan to take exam 1Z0-007: Introduction to Oracle9i: SQL.
Objectives:
After completing this course, students will be able to:
- Answer practice questions in the format of the 1Z0-007 Introduction to Oracle 9i SQL exam
- Assess readiness to take the exam and identify topic areas requiring further practice
Topics:
- SQL Plus reports
- Writing basic SQL select statements
- Restricting and sorting data
- Single-row functions
- Displaying data from multiple tables
- Aggregating data using group functions
- Subqueries
- Producing readable output with iSQL Plus
- Manipulating data
- Creating and managing tables
- Including constraints
- Creating views
- Creating other database objects
- Controlling user access
|