Best Oracle Personal Training (On-line Training) by Oracle Architect at cheap, affordable Price.
Unparalleled Programming Techniques, Unmatched Collection Programming & Object Oriented Programming Techniques in ORACLE.
Trainer Suv can be reachable at suv.can@gmail.com and on his India Number +91-9090169089
Provided Services to Clients like "Logica, Fidelity, Kean India (Formerly CARITOR), CISCO & ERICSSON)
Price: Rs. 9900/- only , $200 per candidate (BOOK YOUR SLOT NOW)
| Syllabus (Oracle Developer) | Syllabus (Oracle DBA) | ||
| Introduction to DBMS | Exploring the Oracle Database Architecture | ||
| o Oracle Database Architecture Overview | |||
| What is DBMS | o Oracle ASM Architecture Overview | ||
| Relational Data Models | o Process Architecture | ||
| Data integrity rules | o Memory structrues | ||
| Normalization | o Logical and physical storage structures | ||
| Introduction to data processing methods - Client/Server | o ASM storage components | ||
| Oracle Architecture | Installing your Oracle Software | ||
| What is grid computing? | o Tasks of an Oracle Database Administrator | ||
| SQL | o Tools Used to Administer an Oracle Database | ||
| o Installation: System Requirements | |||
| Creating Tables | o Oracle Universal Installer (OUI) | ||
| Integrity Constraints | o Installing Oracle Grid Infrastructure | ||
| Adding, updating and dropping columns | o Installing Oracle Database Software | ||
| Transaction and locking | o Silent Install | ||
| Functions | Creating an Oracle Database | ||
| Grouping data | o Planning the Database | ||
| Using ROLLUP and CUBE | o Using the DBCA to Create a Database | ||
| Joing tables | o Password Management | ||
| ANSI Join | o Creating a Database Design Template | ||
| Sub queries | o Using the DBCA to Delete a Database | ||
| Working with TOPn analysis | Managing the Oracle Database Instance | ||
| Views | o Start and stop the Oracle database and components | ||
| Materialized Views | o Use Oracle Enterprise Manager | ||
| Using indexes and clusters | o Access a database with SQLPlus | ||
| Index Skip Scan | o Modify database installation parameters | ||
| Secutiry | o Describe the stages of database startup | ||
| Report generation using SQL*Plus commands | o Describe database shutdown options | ||
| Distributed databases | o View the alert log | ||
| Partitioning | o Access dynamic performance views | ||
| List partitioning | Manage the ASM Instance | ||
| Lobs | o Set up initialization parameter files for ASM instance | ||
| PL/SQL Programming | o Start up and shut down ASM instances | ||
| o Administer ASM disk groups | |||
| What is PL/SQL | Configuring the Oracle Network Environment | ||
| Structure of PL/SQL block | o Use Enterprise Manager to create and configure the Listener | ||
| Control statement | o Enable Oracle Restart to monitor the listener | ||
| CASE expression | o Use tnsping to test Oracle Net connectivity | ||
| Exception handling | o Identify when to use shared servers and when to use dedicated servers | ||
| Cursor handling | Managing Database Storage Structures | ||
| Writing stored procedures and functions | o Storage Structures | ||
| Definer rights vs. Invoker's rights | o How Table Data Is Stored | ||
| Autonomous transactions | o Anatomy of a Database Block | ||
| Database triggers | o Space Management in Tablespaces | ||
| Native dynamic SQL | o Tablespaces in the Preconfigured Database | ||
| Flashback query | o Actions with Tablespaces | ||
| MERGE statement | o Oracle Managed Files (OMF) | ||
| Multitable insert | Administering User Security | ||
| Using Regular Expressions | o Database User Accounts | ||
| Object Features | o Predefined Administrative Accounts | ||
| o Benefits of Roles | |||
| Object types | o Predefined Roles | ||
| Object Inheritance | o Implementing Profiles | ||
| Varrays | Managing Data Concurrency | ||
| Nested tables | o Data Concurrency | ||
| Object views | o Enqueue Mechanism | ||
| New Features Of Oracle Database 11g | o Resolving Lock Conflicts | ||
| o Deadlocks | |||
| Audit Vault and Hot patching | Managing Undo Data | ||
| Security enhancements - case sensitive passwords | o Data Manipulation | ||
| Query result cache and PL/SQL function result cache | o Transactions and Undo Data | ||
| Fine grained depedency tracking | o Undo Data Versus Redo Data | ||
| Enhancements related to Triggers | o Configuring Undo Retention | ||
| PL/SQL sequences | Implementing Oracle Database Auditing | ||
| Virtual Columns & readonly tables | o Describe DBA responsibilities for security | ||
| o Enable standard database auditing | |||
| o Specify audit options | |||
| o Review audit information | |||
| o Maintain the audit trail | |||
| Database Maintenance | |||
| o Manage optimizer statistics | |||
| o Manage the Automatic Workload Repository (AWR) | |||
| o Use the Automatic Database Diagnostic Monitor (ADDM) | |||
| o Describe and use the advisory framework | |||
| o Set alert thresholds | |||
| o Use server-generated alerts | |||
| o Use automated tasks | |||
| Performance Management | |||
| o Performance Monitoring | |||
| o Managing Memory Components | |||
| o Enabling Automatic Memory Management (AMM) | |||
| o Automatic Shared Memory Advisor | |||
| o Using Memory Advisors | |||
| o Dynamic Performance Statistics | |||
| o Troubleshooting and Tuning Views | |||
| o Invalid and Unusable Objects | |||
| Backup and Recovery Concepts | |||
| o Part of Your Job | |||
| o Statement Failure | |||
| o User Error | |||
| o Understanding Instance Recovery | |||
| o Phases of Instance Recovery | |||
| o Using the MTTR Advisor | |||
| o Media Failure | |||
| o Archive Log Files | |||
| Performing Database Backups using RMAN | |||
| o Backup Solutions: Overview | |||
| o Oracle Secure Backup | |||
| o User-Managed Backup | |||
| o Terminology | |||
| o Recovery Manager (RMAN) | |||
| o Configuring Backup Settings | |||
| o Backing Up the Control File to a Trace File | |||
| o Monitoring the Flash Recovery Area | |||
| Performing Database Recovery | |||
| o Opening a Database | |||
| o Data Recovery Advisor | |||
| o Loss of a Control File | |||
| o Loss of a Redo Log File | |||
| o Data Recovery Advisor | |||
| o Data Failures | |||
| o Listing Data Failures | |||
| o Data Recovery Advisor Views | |||
| Data Replication | |||
| o Describe ways to move data | |||
| o Create and use directory objects | |||
| o Use SQL*Loader to move data | |||
| o Use external tables to move data | |||
| o General architecture of Oracle Data Pump | |||
| o Use Data Pump export and import to move data | |||
| Working with Support | |||
| o Use the Enterprise Manager Support Workbench | |||
| o Work with Oracle Support | |||
| o Log service requests (SR) | |||
| o Manage patches | |||
| Advance Features | |||
| o (1) Enterprise Manager Grid Control | o (3) Streams | ||
| o (2) Real Application Clusters | o (4) Data Guard. | ||
