Oracle training courses

After presenting entity relationship (ER) and dimensional modelling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very large data warehouse. Using real-world business scenarios, SALES, for example, the instructor will...oracle training

After reviewing Dimensional Modelling fundamentals, this course focuses on tuning the Oracle DB engine and DW application interfaces with especial emphasis on: Star schema design Indexes Materialized views Partitioning DB parameters oracle training

This course focuses on the extract, transform and load (ETL) phase of the data warehouse (DW) development life cycle. After discussing ETL as it relates to all DBMSs (DB2, MS SQL Server, Sybase, etc.) we elaborate on Oracle's ETL offering: Change Data...oracle training

Skills Gained The delegates will practise: • Creating Oracle SQL statements to query database tables • Using standard aggregate functions and related SELECT statement clauses • Implementing extended SQL functions • Joining Tables • Using subqueries • Creating and altering tables and views • Inserting, updating and deleting rows in database tables • Retrieving Data Using Correlated Subqueries,...oracle training

Skills Gained The delegates will practise: • Using SQL*Plus and SQL Developer to access the database • Creating and running SQL script files • Querying the database • Using Oracle's numeric, character and date functions • Implementing Oracle's enhanced grouping features • Creating and altering tables, indexes and views • Inserting, updating, merging and deleting rows • Granting...oracle training

The delegates will practise: • Implementing various types of trigger • Creating, managing and invoking stored procedures • Creating, managing and executing stored functions • Developing and using packages • Using package features and constructs effectively • Wrapping packages • Using Cursor Variables • Using records and tables or associative arrays in packages • Implementing Bulk Binding and Bulk...oracle training

Skills Gained The delegates will practise: • Writing and running PL/SQL programs from SQL*Plus or SQL Developer • Declaring and using variables and constants • Assigning and manipulating values • Using SQL statements within PL/SQL • Implementing conditional execution and loop constructs • Declaring and using cursors with and without parameters • Updating data with cursors • Trapping...oracle training

Skills Gained The delegates will practise: • Writing code to interface with external applications and the operating system • Creating PL/SQL applications that use collections • Implementing a virtual private database with fine-grained access control • Manipulating large objects • Administering SecureFile LOBs • Designing PL/SQL packages and program units for execution efficiency • Tuning PL/SQL...oracle training

Skills Gained The delegate will practice: • Tuning goals and methodology • Planning initial database configuration • Tuning database applications for optimal performance • Identifying and resolving common tuning problems • Using diagnostic sources • Logging a SR with Oracle support • Managing statistics • Structuring SQL statements for performance • Using the SQL optimizers • Using Indexes effectively • Examining the execution plan...oracle training

The delegate will practise: • Tuning Database Applications for Optimal Performance • Managing Statistics • Creating and Using Indexes • Structuring SQL Statements for Performance • Using the SQL Optimizers • Examining the Execution Plan of a SQL Statement using EXPLAIN PLAN • Examining the Efficiency of SQL Statements using SQL Trace and Autotrace • Using Hints...oracle training

Skills Gained The delegates will practise: • Testing Oracle Forms using runform.htm • Deploying Oracle Forms for End-Users • Creating application-specific configurations • Deploying Custom Images and Icons • Setting default environment variables and fonts • Using the Jinitiator Control Panel • Implementing techniques to improve performance Who will the Course Benefit? Software development personnel who need an...oracle training

Skills Gained The delegates will practise: • Using the Oracle Form Builder productively • Generating text items, buttons, radio groups and other interface items • Creating toolbars, canvases and windows • Writing triggers to enhance application functionality • Calling standard built-in procedures and functions • Developing program units and code libraries • Generating objects for re-use...oracle training

Skills Gained The delegates will practise: • Implementing mouse and key triggers • Creating and using timers • Generating and manipulating runtime record groups • Controlling Data Block relationships explicitly • Building multiple-form applications • Generating custom menus • Defining Data Blocks based on objects, queries and procedures • Using Database Server features within a form • Reusing standard components...oracle training

Skills Gained The delegate will practice: • Creating paper and web reports • Defining report queries • Building reports in various different formats • Applying queries, groups, calculations and summaries to a report • Editing and manipulating boilerplate and layout objects • Editing and enhancing the Web source code • Using Cascading Stylesheets in Web Reports • Building...oracle training

Skills Gained The delegate will practice: • Developing an Apex Web Application • Using the Apex SQL Workshop • Creating Reports • Creating Forms • Managing Web Pages and Regions in the Apex Application • Using and Managing Shared Components in an Application • Using Cascading Stylesheets and Javascripts in Apex Applications • Adding graphs and charts to...oracle training

Skills Gained The delegate will practise: • Installing Oracle Database 10g Software • Creating an Oracle database • Administering an Oracle database with Enterprise Manager • Configuring the Oracle Network Environment • Creating and Managing Database Storage Structures • Managing Schema Objects • Managing Users • Maintaining Database Security • Backing up, Restoring and Recovering the Database • Monitoring the Performance of...oracle training

Skills Gained The delegate will practice: • Installing Oracle Database 11g Release 2 Software • Creating an Oracle database • Administering an Oracle database with Enterprise Manager • Configuring the Oracle Network Environment • Creating and Managing Database Storage Structures • Managing Schema Objects • Managing Users • Maintaining Database Security • Backing up, Restoring and Recovering the Database • Monitoring the...oracle training

Skills Gained The delegate will practise: • Installing and Configuring Oracle • Creating and Managing an Oracle Database • Administering an Oracle Database • Configuring the Oracle Network Environment • Configuring Shared Servers • Creating and Managing Database Storage Structures • Managing Redo Log Files and Control Files • Managing Schema Objects • Managing Users, Profiles, Privileges and Roles • Managing Undo...oracle training

Skills Gained The delegate will practise: • Planning a backup strategy and a disaster recovery strategy • Altering a database to ARCHIVELOG and NOARCHIVELOG modes • Performing online and offline backups • Performing complete and incomplete database recovery • Recovering a database from non-critical losses • Using troubleshooting utilities • Using Recovery Manager to perform backups...oracle training

Skills Gained The delegate will practise: • Planning a backup and recovery strategy and a disaster recovery strategy • Altering a database to archivelog and noarchivelog modes • Creating and managing a recovery catalog database • Using Recovery Manager to perform backups • Using Recovery Manager to perform recoveries • Monitor and Tune Recovery...oracle training