Focus on Training courses

...of Oracle Cloud Overview of the HR Schema Exploring the Oracle Database Architecture Oracle Database 12c Introduction Oracle Database Architecture... Learn about: Database training, Network Training...

...Lock Conflicts Managing Undo Data Undo Data Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing... Learn about: Database training, Network Training...

...refined code by developers.Create reports of sorted and restricted data.Run data manipulation statements (DML).Control database access to specific objects.Manage... Learn about: Database training...

...Connect to a PDB using a service name Start up a CDB Open / Close a PDB (SQL*Plus, srvctl, EM) Open / Close all PDBs Shut down a CDB Triggers ON PLUGGABLE... Learn about: Database training...

...SQL*Plus and JDeveloper are introduced in this course as optional tools.Target Audience:PL/SQL DeveloperForms DeveloperApplication DevelopersDatabase AdministratorsTechnical... Learn about: Database training...

...Resources and Management Library Cache Management Row cache management Buffer cache fusion Buffer Cache Management Requirements Accessing single blocks... Learn about: Database training, Quality Training...

...statements to access data from more than one table Join Tables Using SQL:1999 Syntax View data that does not meet a join condition by using outer joins... Learn about: Database training...

...Course Review of the SQL Concepts Introduction to Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using... Learn about: Database training...

...Identify the available parameter-passing modes Pass parameters using the positional, named, or combination techniques Handle exceptions in procedures... Learn about: Application Development, Database training...

...Cursors and Records Cursor FOR Loops Using Subqueries Explicit Cursor Attributes The %NOTFOUND and %ROWCOUNT Attributes Handling Exceptions Define Exception... Learn about: Database training...

...the use of SQL functions, SQL*Plus parameters and the basic table and view handling statements are introduced. The course also provides practical experience... Learn about: Database training...

...The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs... Learn about: Database training...

...IF-THEN rules and decision tablesTest, debug, and troubleshoot a SOA composite applicationInitiate SOA composite applications using the Events Delivery...

...BPEL process features Discussing basic programming constructs of a BPEL process Communicating message data by using variables in the BPEL process Consuming...

...and Packages Building an Image Installing and Managing Packages Managing Package Publishers Managing Business Application Data Managing devices in a... Learn about: Network Training...

...TablesUsing basic subqueries and the set operatorsUsing numeric, character and date functionsUsing conversion and other miscellaneous functionsUsing... Learn about: Database training...

...Update and Delete Session 2: HIERARCHICAL QUERIES Hierarchical data The START WITH and CONNECT BY clauses The LEVEL pseudo-column Sequencing the output...

...Functions Character Functions String Concatenation Date Arithmetic and Date Functions Session 8: CONVERSION AND MISCELLANEOUS FUNCTIONS Conversion Functions... Learn about: Database training...

...Creating Login Profiles Managing Login Profiles Multi-User Environment Multi-user Considerations Deleting Documents Collaboration with Other Authors Managing...

...an Action/Path Create Decision Frames Use Decision Frames during Playback Insert a Decision Frame Record Paths in a Decision Frame Rename Paths in a Decision...