Overview/Description To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables. 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 DDL, Views, Sequences, Indexes, and Synonyms recognize the steps for...

Overview/Description To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables. Target Audience System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers. Prerequisites Previous programming experience and knowledge of SQL Expected Duration (hours) 2.0 Lesson ObjectivesOracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors identify the steps for trapping non-predefined exceptions...

Overview/Description To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I Expected Duration (hours) 1.8 Lesson ObjectivesOracle Database 11g: Using RMAN...

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...