Focus on Training courses

...and provision pluggable databases to support your business needs. Benefit from learning how to configure the Oracle Network Environment to perform database... Learn about: Database training, Network Training...

...EngineerData Warehouse AdministratorDatabase AdministratorsTechnical AdministratorDatabase Designers Learning Objectives At the end of this course you will be able... Learn about: Network Training, Database training...

...Learn the DESCRIBE command to display the table structure Learn to Restrict and Sort Data Write queries that contain a WHERE clause to limit the output... Learn about: Database training...

...Use ROW ARCHIVAL clause to enable row lifecycle state for applications Set ROW ARCHIVAL VISIBILITY for session level visibility control Use predicate... Learn about: Database training...

...Data Types Use PL/SQL Records The %ROWTYPE Attribute Insert and Update with PL/SQL Records INDEX BY Tables Examine INDEX BY Table Methods Use INDEX... Learn about: Database training...

...Upgrades Planning and Preparing for Upgrade Performing Out of Place Release Install or Upgrade Post Upgrade Tasks Application Continuity What is... Learn about: Quality Training, Database training...

...implicit and explicit data type conversion Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nesting multiple functions Apply the... Learn about: Database training...

...and complex subqueries.Use the in-built functions supporting the usage of regular expressions and time zone.Use the regular expression support in... Learn about: Database training...

...and exceptionsUse the compiler warnings... Introduction Course Objectives, Course Agenda and Appendixes Used in this Course Describe the full Human Resources... Learn about: Application Development, Database training...

...Same Data Type Using Explicit Cursors Define Cursors Explain Explicit Cursor Operations Controlling Explicit Cursors Use Explicit Cursors to Process... Learn about: Database training...

...programs from SQL*Plus or SQL Developer Declaring and using variables and constants Assigning and manipulating values Using SQL statements within PL/SQL... Learn about: Database training...

...Programming LanguageWho will the Course Benefit?Oracle database administrators, software development personnel and database support staff who need to write... Learn about: Database training...

...Architecture (SOA) Explaining Service Component Architecture Reviewing of Services and Key Standards Explaining the Oracle SOA Suite 12c Architecture...

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

...Storage Pool Managing ZFS Properties Configuring Data Backup and Restore Configuring Network and Traffic Failover Configuring Systems on a Local Network... Learn about: Network Training...

...parametersUsing complex subqueriesCreating and altering tables and viewsInserting, updating and deleting rows in database tablesManaging sequences and synonyms... Learn about: Database training...

...Eliminating nodes and branches Session 3: ENHANCED GROUPING FEATURES Review of basic grouping concepts The ROLLUP and CUBE extensions The GROUPING...

...USING SQL*PLUS What is SQL*Plus Getting Started Entering and Executing SQL Statements Editing SQL Statements Creating, Editing and Executing SQL Files Session... Learn about: Database training...

...and Effective Development Usage Tracking Introduction to Usage Tracking Using Reports...

...Bubble Properties Use the Bubble Templates for a Frame Add and Edit Custom Bubble Text Change the Bubble Icon, Pointer and Colour Manipulate Bubble...