Oracle Database 11g Data Dictionary Views and Large Data Sets

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.

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

WEB

Using Data Dictionary Views| - identify the steps for using data dictionary views to find information about tables, constraints, views, sequences, and synonyms.|Querying Data Dictionary Views| - query the appropriate dictionary views to find information about schema objects in a given scenario.|Using Subqueries to Manipulate Data| - recognize the steps for manipulating data using subqueries and explicit default values.|Using Multitable Inserts| - identify the steps for inserting into multiple tables, merging rows in tables, and tracking changes in data.|Performing Multiple INSERTs and MERGE Operations| - manipulate large data sets using multitable INSERT and MERGE operations.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...