Focus on Training courses

...At the end of this course you will be able to:Use Oracle Restart to manage componentsUpgrade database to Oracle Database 12cInstall Oracle Grid Infrastructure... Learn about: Database training, Network Training...

...Resetting the Password Privileges Roles Profiles Managing Data Concurrency Overview of Locks Locking Mechanism Data Concurrency DML Locks Enqueue Mechanism... Learn about: Network Training, Database training...

...of SQL statements Describe the data set used by the course Log on to the database using SQL Developer environment Save queries to files and use script... 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...

...Use SQL Cursor Attributes to Obtain Feedback on DML Save and Discard Transactions Control Structures Conditional processing using IF Statements Conditional... Learn about: Database training...

...consolidation onto database clouds. Target Audience: Database AdministratorsAdministrator Learning Objectives At the end of this course you will be able... Learn about: Database training, Quality Training...

...manipulate data in tables and create database objects.Use single row functions to customize output.Invoke conversion functions and conditional expressions... Learn about: Database training...

...Data by Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Using Scalar subqueries in SQL Correlated... Learn about: Database training...

...Using the UTL_FILE Package to Interact With Operating System Files Using the UTL_MAIL Package Using Dynamic SQL The Execution Flow of SQL Working... Learn about: Application Development, Database training...

...programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)Handle runtime errorsCreate and execute simple... 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...

...to reduce risk and respond faster to business requirements. Become more effective at managing and monitoring a composite application to support your organization's...

...your organization’s applications into agile, reusable, service-based connectivity to reduce risk and respond faster to business requirements...

...AdministratorSupport EngineerTechnical ConsultantSystem Integrator Learning Objectives At the end of this course you will be able to:Manage business application... Learn about: Network Training...

...The SELECT and FROM Clauses Conditions and the WHERE Clause Other Conditional Operators Logical Operators The ORDER BY Clause Column Aliases Arithmetic... Learn about: Database training...

...DATE, TIME AND TIMEZONE SUPPORT Date, Timestamp and Interval datatypes Handling dates and times Handling intervals Date, timestamp and interval functions...

...updating and deleting rows in database tablesRetrieving Data Using Correlated Subqueries, In-Line Views and Multi-Column SubqueriesUsing the WITH ClauseInserting... Learn about: Database training...

...Workflow Converting Content and Publishing Working Online or Offline Development Considerations Assigning Development Tasks and Flow Creating Scripts Efficient...

...Message Record from the Library Changing Views and Layouts Split the Work Area Viewing Folder Content Changing the Outline Editor View Refine the Outline...