Oracle Database 11g: SQL Fundamentals II (Self-Study Course)

 

Who should attend

  • Database designers
  • Database administrators

Course Objectives

  • Identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using date-time functions
  • Recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings
  • Recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes
  • Recognize the steps for querying data dictionary views to view schema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables

Product Description

  • Oracle Database 11g: Controlling User Access and Managing Schema Objects
    • Controlling User Access
    • Managing Schema Objects
  • Oracle Database 11g: Data Dictionary Views and Large Data Sets
    • Managing Objects with Data Dictionary Views
    • Manipulating Large Data Sets
  • Oracle Database 11g: Managing Data in Different Time Zones
    • Using Time Zones and Datetime Functions
  • Oracle Database 11g: Using Subqueries and Regular Expressions
    • Retrieving Data Using Subqueries
    • Using Regular Expressions

Price on request