Oracle - OCA,OCP, Developer and Administrator

Training

In Barking/East Ham

£ 599 + VAT

Description

  • Type

    Training

  • Location

    Barking/east ham

  • Duration

    1 Month

Facilities

Location

Start date

Barking/East Ham (London)
See map
160 London Road, IG11 8BB

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Duration : 5 Days Monday - Friday for each Module. Module 1 - Oracle SQL Training . Module 2 - Oracle 11g PL/SQL Training. Module 3 - Oracle Administration Basic Fundamental I. Module 4 - Oracle Administration Advance Fundamental II. Module 5 - Oracle Administration Backup & Recovery and Performance Tuning. Oracle 11g SQL Training Outline Relational Databases & SQL About Relational Databases Elements of SQL Choosing A SQL & PL/SQL Interface About Database Connections About Bind Variables Using SQL Developer Using SQL*PLUS Using Application Express Building A Statement About the Select Statement Using Alias Names Restricting Data with the Where Clause About Logical Operators Equality Operator Boolean Operators Null & Between Operators Is [Not] Null Operator [Not] Between Operator Finding Text Strings [Not] Like Operator Regexp_Like() In Operator Sorting Data with the Order By Clause About the Order By Clause Multiple Column Sorts Specifying the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns & Functions Using Rowid Using Rownum Using the Functions Sysdate User & Uid Using the Dual Table Sessiontimezone Function Joining Tables About Joins Inner Join Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators Set Operator Examples Summary Functions About Summary Functions Summary Functions with Distinct Using Sub-Queries About Sub-Queries Standard Sub-Queries Correlated Sub-Queries Aggregating Data within Groups About Summary Groups Finding Groups within the Base Tables Selecting Data from the Base Tables Selecting Groups from the Result Table Build Simple SQL*PLUS Reports Format Column Output with Column Defining Report Breaks with Break Produce Subtotals with Compute Use Data Definition Language to Create & Manage Tables Create Table Statement Not Null Default Alter Table Statement Drop Table Statement Supportive Statements Describe Rename Use Data Manipulation Language to Manipulate Data About the Insert Statement About the Delete Statement About the Update Statement About Transactions Rollback Commit Savepoint Set Transaction Truncate Table Complex Table References SQL99 Join Techniques Cross Joins Natural Joins Inner Joins Outer Joins Anti Joins Using Named Subqueries Enhancing Groups with Rollup & Cube Using Rollup Using Cube Using the Case Expression SQL Functions: Character String Formatting Functions Ascii Codes Functions Pad & Trim Functions String Manipulation Functions String Comparison Functions Phonetic Search Functions SQL Functions: Numeric About the Numeric Functions Null Value Functions SQL Functions: Date Date Format Functions Date Arithmetic Functions> Database Objects: Relational Views About Database Objects About Relational Views Updating View Data Maintaining View Definitions Alter View Drop View Database Objects: Data Dictionary Storage About the Data Dictionary Object-Specific Dictionary Views User_Updatable_Columns Understanding the Data Dictionary Structure Database Objects: Indexes About Indexes Use B-Tree Indexes Database Objects: Other Objects More About Creating Tables About Sequences Alter Sequence & Drop Sequence Alter Sequence Drop Sequence About Synonyms Drop Synonym Create Schema Authorization Database Objects: Security User Passwords Object Security Data Using Constraints About Constraints Not Null Constraint Check Constraint Unique Constraint Primary Key Constraint References Constraint Defining Constraints On Existing Tables Managing Constraint Definitions Renaming & Dropping Constraints Enabling & Disabling Constraints Deferred Enforcement Set Constraints Handling Constraint Exceptions Constraints with Views Data Dictionary Storage Advanced SQL*PLUS Reports Break Compute Column Ttitle & Btitle Conclusion ---------------------------------------------------------- Oracle 11g PL/SQL Training Outline Choosing A SQL & PL/SQL Interface Using SQL Developer Using SQL*PLUS Using Application Express Using JDeveloper Studio Language Features Understanding PL/SQL Structure of A PL/SQL Program Block Using PL/SQL from SQL*PLUS Declare Clause About the Declare Clause Declare Simple Types Declare Complex Types Type ... Table Type ... Record Begin Clause About the Begin Clause Performing Data Manipulation Logic Control & Branching Loop If-Then-Else Case Exception Clause About the Exception Clause Isolating the Specific Exception Pragma Exception_Init SQL%Rowcount & Select...Into Explicit Cursors About Explicit Cursors Advanced Cursor Techniques Introducing Database Program Units About Database Program Units Types of PL/SQL Program Units Types of Stored Program Units Advantages of Using Stored Program Units Creating Stored Procedures & Functions About Stored Procedures & Functions Creating Procedures & Functions Executing Procedures & Functions Maintaining Stored Procedures & Functions Recompiling & Dropping Programs Data Dictionary Storage Managing Dependencies Creating & Maintaining Packages About Packages Creating Packages Advanced Programming Techniques Maintaining Packages Advanced Cursor Techniques Using Cursor Variables Using Cursor Expressions Using System-Supplied Packages Dbms_Output() Utl_File() Creating Database Triggers About Database Triggers Statement-Level Triggers Row-Level Triggers Examples of Triggers Instead of Triggers EMploying Triggers within an Application Maintaining Database Triggers Call Syntax Trigger Maintenance Tasks Show Errors Trigger Drop Trigger Alter Trigger Handling Multiple Triggers for A Table Handling Mutating Table Issues Implementing System Event Triggers What Are System Event Triggers? Defining the Scope Available System Events System Event Attributes Conclusion ---------------------------------------------------------------------------- Oracle 11g Administration Training Outline Fundamental I Enterprise Edition Installation Identify System Requirements The Optimal Flexible Architecture (OFA) Oracle_Base Oracle_Home Configure the Installation Environment Enterprise Edition Installation DBCA The Administrator Interface Enterprise Manager Tour Using EM SQL Worksheet Duties of A Database Administrator Exploring the Oracle Database Architecture: General The Oracle Enterprise Architecture Exploring the Oracle Database Architecture: Instance Memory What Is an Oracle Database Instance? More about the System Global Area (SGA) About the PGA Managing Memory Exploring the Oracle Database Architecture: Instance Processes Instance Background Processes SQL Execution Processes Creating an Oracle Database Create A New Database Configure an Existing Database Drop A Database Manage DBCA Templates Manually Create A Database Managing the Database Instance Configuring A Linux Environment Starting & Stopping Database Control Starting & Stopping the Database Listener Starting & Stopping the Database Instance More about the Database Files Manage Database Storage Structures: Tablespaces about Tablespaces Tablespace Management Drop Tablespace Alter Tablespace Manage Database Storage Structures: Advanced Tablespaces More about Temporary Tablespaces about Temporary Tablespace Groups More about Permanent Tablespaces More about Bigfile Tablespaces More about the Sysaux Tablespace Manage Database Storage Structures Data Files & Temp Files Managing Data Files Managing Temp Files Enable Oracle-Managed Files (OMF) Managing Undo Data about Undo Space Management Configure Automatic Undo Management Undo_Management Undo_Tablespace Undo_Retention Guarantee Undo Retention Monitor Undo Space Use the Undo Advisor Network Environment: Oracle Shared Servers Shared Servers Architecture Configure Shared Servers Monitor Shared Servers V$Shared_Server V$Shared_Server_Monitor V$Session V$Circuit V$Dispatcher & V$Dispatcher_Config V$Queue Security: Implementing Database Security Database System Privileges Database Object Privileges Administrator Auditing Of Database Activity Enhanced Default Security Settings Security: Administering User Security Create & Manage Database Accounts Grant & Revoke Database Privileges Resource Limits Via Profiles Alter Profile Drop Profile Password Management Via Profiles about Role-Based Security With Admin Option Alter User...Default Role Set Role Enhanced Default Security Settings Moving Data: SQL Loader Loader Concepts Control File Options Load Methods Using the EM Interface Moving Data: Export & Import Manage Directory Objects about the Data Pump Architecture Data Pump Export Data Pump Import Data Pump Data Dictionary Views Using the EM Interface Database Maintenance & Performance Management the Management & Advisory Framework Manage the Automatic Workload Repository Automatic Database Diagnostic Monitor Use Metrics & Alert Thresholds Automatic Maintenance Tasks Managing Concurrency & Locks about Latches & Locks Manage & Monitor Latches Manage & Monitor Locks V$Lock V$Locked_Object V$Session V$Session_Wait Dba_Blockers & Dba_Waiters Dba_DML_Locks & Dba_DDL_Locks DML_Locks Backup & Recovery Concepts & Configuration About Database Backup & Recovery Structures Managing Redo Data Managing Archival Data Automatic Crash Recovery Creating A Basic Backup Strategy Conclusion ----------------------------------------------------------------------------------- Oracle 11g Administration Fundamental II Training Outline Managing Memory About Manual Memory Management Automatic Memory Management Memory_Target Memory_Max_Target Sga_Target Sga_Max_Size Workarea_Size_Policy & Pga_Aggregate_Target Using EM & The Memory Advisors Monitor In Memory Access Mode Managing Storage & The Segment Advisor Monitor Tablespaces About Resumable Space Allocation Table Storage Management Pctfree Illustrated Use The Segment Advisor Using The Shrink Space Option Cascade To Dependent Objects Optionally Call Delete_Task() Managing Resources Database Resource Manager Architecture Consumer Groups Resource Plans Automatic & Adaptive Consumer Group Mapping Activating Plans Monitoring Resource Allocation Explicit Consumer Group Switching Automating Tasks With The Scheduler (Basic) Scheduler Architecture Rac Environment Manage Programs Manage Schedules Manage Jobs Automating Tasks With The Scheduler (Advanced) Manage Job Classes Manage Windows & Window Groups Manage Chains About Events & The Scheduler Globalization Globalization Settings Nls_Lang Nls_Language & Nls_Territory Date & Time Localization Linguistic Indexes About Locale Builder Diagnosing Database Problems About The Fault Diagnosability Infrastructure ADR Highlights From EM Using The Alert Log About The Trace Files Database Instance Health Snapshot Using The Support Workbench Enable Oracle Configuration Manager Automatic Storage Management ASM & The Broader Database Architecture Creating The ASM Instance Administering The ASM Instance Sysasm Super Administrator ASM Storage Parameters Using DBCA Using ASMcmd Configuring Databases For ASM Storage DBCA DBUA ASM Migration Using EM Recovery Concepts About The Backup & Recovery Structures Managing Redo Data Is Log_Buffer Large Enough? What V$Log Reveals What V$Log_History Reveals What V$Logfile Reveals What V$Archived_Log Reveals Managing Archived Redo Data Archivelog Status Creating A Foundation For Sound Recovery Oracle Flashback Technology About Flashback Technology Flashback Query Select...As Of Timestamp Select...As Of SCN Using Dbms_Flashback() Configuring Undo Management For Flashback Undo_Retention Flashback Table Flashback Drop Flashback Versions Query Flashback Transaction Query Flashback Transaction Backout Flashback Database About Flashback Database Configuring The Flash Recovery Area More About Db_Recovery_File_Dest Performing Database Flashback Monitoring Flashback Performance Flashback Database Considerations Configure Flashback Data Archive Instance Recovery About Instance Recovery Smon Process & Instance Recovery Pmon Process & Process Recovery Instance Recovery Parallelism Changing Recovery_Parallelism Mttr Advisor & Tuning Checkpoints Log_Checkpoints_To_Alert Redo Logfile Size Advisor Fast-Start On-Demand Parallelism Configuring RMAN RMAN Architecture RMAN Sample Backup Session Launch & Use RMAN Configure RMAN Settings Allocate RMAN Channels Backup With RMAN About Backup File Types Performing Full Backups Performing Incremental Backups Establishing A Backup Retention Policy Generate Reports Report Unrecoverable Report Need Backup List Incarnation Validate Backup Data Integrity RMAN Management With EM Monitoring The Flash Recovery Area The EM Interface To RMAN Scheduling RMAN Backups Using The Oracle-Suggested Backup Strategy Manage Current Backups Backup Reports Manage Restore Points User-Managed Recovery Operations Recovery Concepts Recover Temporary Tablespaces Recover Read-Only Tablespaces Recover Index Tablespaces Recover Redo Log Group Member Recreate The Password File Recovery With RMAN Complete Media Recovery Incomplete Media Recovery TSPITR DBPITR Recovery Using EM Using The RMAN Recovery Catalog Configuring The Recovery Catalog Using A Virtual Private Catalog Advanced RMAN Capabilities Backup Set Encryption RMAN Duplicate Database Conclusion -------------------------------------------------------- Oracle 11g Backup & Recovery Training Outline Recovery Concepts About The Backup & Recovery Structures Managing Redo Data Managing Archived Redo Data Creating A Foundation For Sound Recovery Oracle Flashback Technology About Flashback Technology Flashback Query Select...As Of Timestamp Select...As Of SCN Configuring Undo Management For Flashback Undo_Retention Flashback Table Flashback Drop Flashback Versions Query Flashback Transaction Query Flashback Transaction Backout Flashback Database About Flashback Database Configuring The Flash Recovery Area Performing Database Flashback Monitoring Flashback Performance Flashback Database Considerations Configure Flashback Data Archive Instance Recovery About Instance Recovery Instance Recovery Parallelism Mttr Advisor & Tuning Checkpoints Log_Checkpoints_To_Alert Redo Logfile Size Advisor Fast-Start On-Demand Parallelism Configuring RMAN RMAN Architecture Launch & Use RMAN Configure RMAN Settings Allocate RMAN Channels Backup With RMAN About Backup File Types Performing Full Backups Performing Incremental Backups Establishing A Backup Retention Policy Generate Reports Report Unrecoverable Report Need Backup List Incarnation RMAN Management With EM Monitoring The Flash Recovery Area The EM Interface To RMAN Scheduling RMAN Backups Using The Oracle-Suggested Backup Strategy Manage Current Backups Backup Reports Manage Restore Points User-Managed Recovery Operations Recovery Concepts Recover Temporary Tablespaces Recover Read-Only Tablespaces Recover Index Tablespaces Recover Redo Log Group Member Recreate The Password File Recovery With RMAN Complete Media Recovery Incomplete Media Recovery Recovery Using EM Using The RMAN Recovery Catalog Understanding Catalog Concepts Create The Recovery Catalog Manage Virtual Private Catalogs Data Protection Of The Recovery Catalog Using RMAN Scripts Database Duplication & Cloning Why Perform Database Duplication? RMAN Duplicate Database RMAN Duplicate Database Cloning Advanced RMAN Capabilities Backup Optimization Enhancing Parallelism With Section Sizes Archival Backups Backup Set Encryption Copying Files Between Databases Transporting Tablespaces About Tablespace Transportation Read-Only Tablespace Transportation Read-Write Tablespace Transportation Transport Tablespaces Using EM Recovering From Corruption With Data Recovery Advisor How Does Corruption Occur? Detecting Corruption Analyze V$Database_Block_Corruption View Db_Block_Checking Db_Block_Checksum Db_Lost_Write_Protect Db_Ultra_Safe Recovery Using The Data Recovery Advisor Block Media Recovery Isolating Corruption With Dbms_Repair() Conclusion

Oracle - OCA,OCP, Developer and Administrator

£ 599 + VAT