Online Data Dictionary Views eLearning
Data Dictionary Views Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle Database 11g Data Dictionary Views and Large Data Sets

Oracle Database 11g: Data Dictionary Views and Large Data Sets Oracle
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.
more...
Oracle Database 11g Data Dictionary Views and Large Data Sets
Managing Database Objects in Oracle Database 10g

Managing Database Objects in Oracle Database 10g Oracle
To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g
more...
Oracle Database 11g Managing Data Dictionary Views Large Data Sets

Oracle Database 11g: Managing Data Dictionary Views & Large Data Sets Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert
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.
more...
Oracle Database 10g SQL Fundamentals I Part 2

...he data dictionary.
Identify the contents and usage of data dictionary views.
Unit 2: Objects and Data Management
Identify tasks to be performed for granting system privileges.
Identify tasks to be performed for granting object privileges.
Identify syntax for performing various tasks for maintaining columns.
Identify syntax for performing various tasks for managing
more...
Oracle SQL Specifics Creating and Managing Database Objects

...to create a table from rows in another table.
Match the data dictionary views used to confirm tables and constraints with their purpose.
Identify the naming conventions to follow when naming tables and columns.
Identify the four most common datatypes used in the Oracle8 database.
Match the five Oracle8 data integrity constraints with their descriptions.
Identify the default constraint
more...
Oracle8 Database Administration - Create Databases

...contents of a database after its creation.
Unit 2 - Data Dictionary Views and Standard Packages
Duration: 1 - 2 Hour(s)
Identify the types of information stored in the data dictionary.
Identify the features of the data dictionary components.
Create a data dictionary view for a specific database by executing the appropriate script.
Identify the contents of the data
more...
Oracle8i Database Admin Create Databases

... To: Identify and create a database. Identify the data dictionary views. Identify the data dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators,
more...
Oracle8i Backup and Recovery Strategies Backups

...by setting parameters in the init.ora file. Identify the data dictionary views used to obtain the archive log information. Unit 3: Oracle Recovery Manager Duration: 2 Hour(s) Select the features of Recovery Manager (RMAN). Start Recovery Manager by using the RMAN command. Identify the events that occur during the connection process after the RMAN command is executed. Select the
more...
Oracle9i Peformance Tuning Managing Memory and Disk I O

This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the
more...
Oracle8 Database Administration - Manage Data

... the guidelines for implementing clusters.
Identify the data dictionary views to be used for retrieving specified information about clusters.
Identify the data storage and retrieval features of an index-organized table.
Identify the features of an index-organized table that distinguish it from a regular table.
Create an index-organized table with an overflow area in a specified
more...
Oracle8 Backup and Recovery - Strategies and Backups

...ds.
Display information from the recovery catalog using data dictionary views.
Identify data dictionary views used for extracting recovery catalog information.
Unit 4: Oracle Backup Methods
Duration: 2 Hour(s)
Sequence the steps to perform a closed database backup.
Perform an open database backup.
Identify the requirements to perform an open database backup.
Write the
more...
Oracle8 Network Administration Net8 Configuration and Troubleshooting

...configuration parameters with their functions. Match the data dictionary views used to verify MTS setup with their contents. Sequence the steps involved in the Connection Pooling process. Identify the syntax of the init.ora parameter MTS_DISPATCHERS that needs to be configured to enable Connection Pooling. Unit 3: Connection Manager Duration: 2 Hour(s) Identify the benefits of the
more...
Oracle Database 10g PL SQL Fundamentals Part 2

This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named
more...
From Serebra Learning Corporation
Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure
The course is aimed at familiarizing the learner with the Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands
more...
Oracle 8i DBA - Data Dictionary and Database Files
...The course is aimed at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data
more...
Oracle 8i DBA - Oracle Storage Architecture
This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical
more...
Oracle 8i DBA - Managing Oracle Database Security
This course is aimed to familiarize the learner with the basic concepts of Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle
more...
Advanced Oracle PL/SQL: Design Considerations and Object Types
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.
more...
