Focus on Training courses

...Database Express Using the Enterprise Manager Database Express Home Page Understanding the Enterprise Manager Cloud Control Framework Using Enterprise... Learn about: Database training, Network Training...

...Tools for Configuring and Managing the Oracle Network Using the Listener Control Utility Using Oracle Net Configuration Assistant Using Oracle Net Manager... Learn about: Network Training, Database training...

...Using Joins Write SELECT statements to access data from more than one table View data that generally does not meet a join condition by using outer joins... Learn about: Database training...

...AnalysisData RedactionAdaptive Execution PlansSQL Plan DirectivesReal-Time ADDMCompare Period ADDMData PumpPartitioningSQL Benefits to You Ensure... Learn about: Database training...

...PL/SQL Variables.Benefits to You:Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver... Learn about: Database training...

...in a RAC environmentStart and stop RAC databases and instancesModify initialization parameters in a RAC environmentConfigure the RAC database to use ARCHIVELOG... Learn about: Quality Training, Database training...

...Join a table to itself by using a self join Create Cross Joins Usage of Subqueries to Solve Queries Use a Subquery to Solve a Problem Single-Row Subqueries... Learn about: Database training...

...Creating Views Overview of views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving... Learn about: Database training...

...Package Body Invoking the Package Constructs Creating and Using Bodiless Packages Removing a Package Working With Packages Overloading Subprograms Using... Learn about: Application Development, Database training...

...PL/SQL Variables Identify valid and invalid identifiers Declare and initialize variables List and describe various data types Identify the benefits... Learn about: Database training...

...Implementing conditional execution and loop constructs Declaring and using cursors with and without parameters Updating data with cursors Trapping... Learn about: Database training...

...PL/SQL scripts to enhance their productivity in manipulating data. The delegates will practise: Writing and running PL/SQL programs from SQL*Plus or... Learn about: Database training...

...applications using the Events Delivery Network.Test, debug and troubleshoot a SOA composite application.Apply security policies to service endpoints...

...with Business Rules Components Defining business rules Using Business Rule service components in SOA Composites Editing business rules by using SOA Composer...

...Resources to a Zone Managing Services and Service Properties Configuring SMF services Troubleshooting the SMF Services Configuring Privileges and... Learn about: Network Training...

...CHARACTER AND DATE FUNCTIONS Function Types Using the Table dual to try out Functions Numeric Functions Character Functions String Concatenation Date Arithmetic... Learn about: Database training...

...Learning Objectives The delegates will practise:Retrieving Data Using Correlated Subqueries, In-Line Views and Multi-Column SubqueriesUsing the WITH ClauseInserting...

...RETRIEVING DATA WITH THE SELECT STATEMENT The SELECT Statement The SELECT and FROM Clauses Conditions and the WHERE Clause Other Conditional Operators... Learn about: Database training...

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

...Input Text Set the Default Text Entry Adding Meta Entries to the Input Text (Review) Alternative Actions and Paths Insert an Alternative Action Display...