Vi ste ovdje
Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database 11g: Controlling User Access and Managing Schema Objects
identify the steps for granting and revoking system and...
Overview/Description
To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).
Expected Duration (hours)
1.7
Lesson ObjectivesOracle Database 11g: Data Dictionary Views and Large Data Sets
identify the steps...
Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).
Expected Duration (hours)
1.3
Lesson ObjectivesOracle Database 11g: Managing Data in Different Time Zones
recognize the steps for managing time zones and time intervals.
recognize the...
Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database 11g: Using Subqueries and Regular Expressions
identify the steps for writing multiple-column and scalar subqueries.
recognize the steps...