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 identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information. 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) 2.2 Lesson ObjectivesOracle Database 11g: Using SQL to Query Your Database identify the...

Overview/Description To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings. 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 Triggers and the PL/SQL Compiler identify the steps for creating and using database triggers....