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