Focus on Training courses

...for a Standalone ServerCreate a container databaseCreate an Oracle DatabaseInstall Oracle Database 12c softwareMonitor the DatabaseManage Database PerformanceImplement... Learn about: Network Training, Database training...

...Among Sessions and TasksSchedule Jobs to Run Inside or Outside of the DatabaseConfigure Oracle Net ServicesConfigure your Database For Backup and Recovery... Learn about: Network Training, Database training...

...of a basic SELECT statement Select All Columns Select Specific Columns Use Column Heading Defaults Use Arithmetic Operators Understand Operator Precedence... Learn about: Database training...

...onto database clouds. Multitenant Architecture After a brief review of the Oracle Enterprise Manager Cloud Control 12c and Enterprise Manager Database Express... Learn about: Database training...

...Errors by using Naming Conventions when using Retrieval and DML Statements Data Manipulation in the Server using PL/SQL Understand the SQL Cursor concept... 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...

...anonymous PL/SQL blocks, stored procedures and functions.Declare identifiers and trap exceptions.Use DML statements to manage data.Use DDL statements... Learn about: Database training...

...Introduction Course Objectives, Course Agenda and Appendixes Used in this Course Provide an insight of the development environments Tables used in... Learn about: Database training...

...Schema Review the online Oracle Database 12c SQL and PL/SQL documentation and the additional available resources List the PL/SQL development environments... Learn about: Database training, Application Development...

...Schema Identify the Appendices Used in this Course Introduction to PL/SQL Development Environments Oracle Database 12c SQL Documentation and Additional... Learn about: Database training...

...to the PL/SQL programming language. Learning Objectives To provide the skills needed to query and update data held in an Oracle Relational Database... Learn about: Database training...

...Implementing nested and labelled loops and blocks Raising exceptions Handling PL/SQL records and tables Using PL/SQL table built-in functions... Learn about: Database training...

...Adapters Introducing Binding Components and JCA Adapters Monitoring Adapters Discussing JMS Messaging Discussing Adapters and the WebLogic Application...

...Discussing fault handling Monitoring business activities Enabling On-Premises Integration How Oracle B2B is integrated with Oracle SOA to enable electronic...

...Based Access Control Configuring and Managing Privileges Configuring and Using RBAC Securing System Resources Using Solaris Auditing Configuring Solaris... Learn about: Network Training...

...Columns and Constraints Dropping Tables, Columns and Constraints Recovering Dropped Tables Copying Tables Session 14: MANAGING INDEXES AND VIEWS Creating... Learn about: Database training...

...The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle...

...USING SQL DEVELOPER What is Oracle SQL Developer Starting SQL Developer Configure a Connection Navigation Tabs SQL Worksheet Query Builder Session... Learn about: Database training...

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

...Role List Rename/Delete a Role Create a New Role List Assign Keywords Keywords Property Assign Keywords Delete Keywords Reuse Documents Paste and Paste...