Oracle SQL
Relational databases often drive company-critical and web-enabled applications. Creating a database design that accurately and completely captures user requirements is vital for success. This course provides a comprehensive foundation for designing, building, and working with relational databases, enabling you to participate in the development process and to use a relational database to its maximum effectiveness.
Course Description
This course teaches you using SQL in a real-world Oracle9i environment. This course will also prepare you for the 1Z0-007 Introduction to Oracle9i SQL exam.
Exams
  • 1Z0-007 Introduction to Oracle9i SQL
    • Topics Covered
  • Basic SQL SELECT statements
  • SQL*Plus overview
  • Single row functions
  • Aggregating data and group functions
  • Joins and Sub-queries
  • Displaying data from multiple tables
  • Modifying data
  • Restricting and sorting data
  • Aggregating data using group functions
  • Producing readable output with SQL*Plus
  • Managing tables and constraints
  • Managing views
  • Other database objects
  • User access and security