Oracle courses

...11i Financials Suite Overview of the Oracle 11i Financials Modules Integration within the Oracle 11i Financials Suite System Administration and Superuser...

...Summary: This course focuses on the extract, transform and load (ETL) phase of the data warehouse (DW) development life cycle. After discussing ETL...

...features and constructs of the PL/SQL Programming Language. This course is designed to introduce Oracle DBAs, software development personnel and database...

...and features of core service components in Oracle SOA Suite 12c.Explain the context of using each core service component of SOA Suite.Address business...

...Test and Monitor Workflow Processes View and Respond to Notifications Oracle Workflow Directory Service Workflow Engine Customize Workflow Processes Handle...

...In-Line Views The Exists Operator The WITH Clause Multi-Column Subqueries Insert and Update Using a Query Correlated Update and Delete Hiearchical Queries...

...and work with an Oracle Database. This course is suitable for users of versions 9i, 10g and 11g. This course is designed for experienced SQL users...

...standard aggregate functions and related SELECT statement clausesImplementing extended SQL functionsJoining TablesUsing subqueriesCreating and altering tables and viewsInserting... Learn about: Database training...

...Accessing PL/SQL Applications Deploying Java Applications Application Server Clustering Concepts Managing Log Files Backup and Recovery Overview Oracle...

...Button Bars Displaying Data Selecting Worksheet Sections Viewing Pages Workbook Formatting Re-Ordering and Resizing Columns Formatting Headings and...

...and Connecting to the Master Repository Creating and Connecting to the Work Repository Managing ODI Agents Creating a Physical Agent Launching a Listener...

...a comprehensive understanding of how the Oracle Procedural Language / Structured Query Language (PL/SQL) is used. This course is for programmers and support...

...(NO)ARCHIVELOG modes Create and manage a recovery catalog database Use Recovery Manager to perform backups Use Recovery Manager to perform recoveries Monitor...

...and advanced topics such as database management in the next level. The OCP certification is an absolute must if you want to achieve any sort of success...

...this course elaborates on the essential physical design and phases of an Oracle data warehouse (DW). Particular emphasis is placed on the following...

...Application second and third line support. This course is ideal for: Database administrators, Developers, Data warehouse support team members...

...Data Sorting Data Creating and Managing Queries Using Summaries Creating Calculated Items Customising Display Properties Conditions and Parameters Reporting...

...Creating and Managing Stored Functions Deterministic Functions Using Stored Functions in SQL Creating and Managing Packages Implementing Package Features...

...semantics, constructs, etc. The training goals and objectives are mainly realised through extensive use of real-world examples, exercises and hands-on computer-based...

...information systems architects, and Java and web-based application developers interested in becoming familiar with the application server platform. Oracle...