Home Page    Courses    OCA    SQL and PL/SQL1Z0-001

Introduction to Oracle: SQL and PL/SQL1Z0-001 Exam Topics

.

  • Creating and Managing Tables:
    • Describe the main database objects
    • Create tables
    • Describe the datatypes that can be used when specifying column definition
    • Alter table definitions
    • Drop, rename, and truncate tables.
  • Including Constraints:
    • Describe constraints
    • Create and maintain constraints
  • Create and maintain constraints:
    • Describe a view
    • Create a view
    • Retrieve data through a view
    • Insert, update, and delete data through a view
    • Drop a view
  • Oracle Data Dictionary:
    • Describe the data dictionary views a user may access
    • Query data from the data dictionary
  • Writing Control Structures:
    • Identify the uses and types of control structures
    • Construct an IF statement
    • Construct and identify different loop statements
    • Use logic tables
    • Control block flow using nested loops and labels.
  • Working with Composite Datatypes:
    • Create user-defined PL/SQL records
    • Create a record with the % ROWTYPE attribute
    • Create a PL/SQL table
    • Create a PL/SQL table of records
    • Describe the difference between records, tables, and tables of records
  • Overview of Relational Databases, SQL, and PL/SQL:
    • Discuss the theoretical and physical aspects of a relational database
    • Describe the Oracle implementation of the RDBMS and ORDBMS
    • Describe the use and benefits of PL/SQL.
  • Aggregating Data using Group Functions:
    • Identify the available group functions
    • Use group functions
    • Group data using the GROUP BY clause
    • Include or exclude grouped rows by using the HAVING claus.
  • Creating Views:
    • Describe a view
    • Create, alter the definition, and drop a view
    • Retrieve data through a view
    • Insert, update and delete data through a view
    • Create and use an inline view
    • Perform Top 'N' Analysis.

OCA