Overview/Description To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database Target Audience Anyone wanting to learn about Oracle Database 10g database administration Prerequisites An understanding of database concepts and technologies Expected Duration (hours) 2.0 Lesson ObjectivesOracle Database 10g: The SQL*Loader and PL/SQL Release 2 identify the function of the SQL*Loader and the files it uses. recognize how to load data using the SQL*Loader. load data using the SQL*Loader. identify the characteristics of PL/SQL objects, functions, and procedures....

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 manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements. 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.9 Lesson ObjectivesOracle Database 11g: Subqueries, Set Operators, and...