Oracle 9i Training (CBT)

We have "Oracle 9i" prepaid courseware currently available. To get more information about this computer based training, please contact us.

Course Description:

This computer based training for Oracle 9i covers:
  • relational database principles and Oracle concepts
  • how to write basic SQL statements
  • restricting and sorting data and using single-row functions
  • introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database
You will learn to:
  • Identify the components of the relational model
  • Match the structural elements of a relational database table with their descriptions
  • Sequence the phases of the system development life cycle
  • Match the types of SQL statements with their descriptions
  • Match the capabilities of SQL SELECT statements with their functions
  • Identify the guidelines for constructing basic SQL SELECT statement
  • Write a query that restricts rows returned by using the WHERE clause
  • Write a WHERE clause to accommodate different datatypes
  • Use comparison operators with the WHERE clause
  • Identify the different categories of datatypes
  • Match the character datatypes with their descriptions
  • Identify the features of the NUMBER datatype

View related prepaid training courseware: