Focus on Training courses

...Block Space Management Row Chaining and Migration Free Space Management Within Segments Types of Segments Allocating Extents Allocating Space Creating... Learn about: Network Training, Database training...

...By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle DatabaseTarget Audience:Support... Learn about: Database training, Network Training...

...in Oracle Database 12cCreate tables to store dataUtilize views to display dataControl database... Course Outline. Introduction to Oracle Database... Learn about: Database training...

...databasesManage datafile online operations, data lifecycle management with heat map and automatic data optimization, archive data using Row-archival... Learn about: Database training...

...with PL/SQL Trap Predefined Oracle Server Errors Trap Non-Predefined Oracle Server Errors Trap User-Defined Exceptions Propagate Exceptions RAISE_APPLICATION_ERROR... Learn about: Database training...

...with Client Applications Services and Connection Load Balancing Services and Transparent Application Failover Services and the Resource Manager Managing... Learn about: Database training, Quality Training...

...manage database objects.Declare PL/SQL Variables.Conditionally control code flow (loops, control structures).Describe stored procedures and functions.Retrieve... Learn about: Database training...

...advanced features of SQL to query and manipulate data within the database. Learn to control privileges at the object and system level, while deep diving... Learn about: Database training...

...Describe PL/SQL blocks and subprograms Describe the uses and benefits of procedures Create, call, and remove procedures Use formal and actual parameters... Learn about: Database training, Application Development...

...Cursors and Records Cursor FOR Loops Using Subqueries Explicit Cursor Attributes The %NOTFOUND and %ROWCOUNT Attributes Handling Exceptions Define Exception... 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...

...Developer Declaring and using variables and constants Assigning and manipulating values Using SQL statements within PL/SQL Implementing conditional execution... Learn about: Database training...

...with the Pick Activity Looping with the While Activity Indexing XML Arrays Dynamically Examining Structured and Extension BPEL 2.0 Activities Handling...

...Oracle SOA Suite 12c Explaining product components in Oracle SOA Suite 12c Discussing management tools of Oracle SOA Suite 12c Building SOA Composite Applications...

...11 OS on Multiple Hosts Installing Oracle Solaris 11 Using the Automated Installer Building an Oracle Solaris Image Managing the Image Packaging System (IPS)... Learn about: Network Training...

...Indexes Dropping Indexes Listing Indexes Creating and Using Views Dropping Views Listing Views Session 15: MANAGING SEQUENCES AND SYNONYMS Create a Sequence... Learn about: Database training...

...and Updating Rows Using Complex SubqueriesCreating Hierarchical QueriesUsing ROLLUP, CUBE and GROUPING SETS Group By EnhancementsImplementing the GROUPING...

...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...

...Overview A high level overview of the UPK components and course topics Customising Published Output Customising Publishing Styles Customising the Player...

...an Action/Path Create Decision Frames Use Decision Frames during Playback Insert a Decision Frame Record Paths in a Decision Frame Rename Paths in a Decision...