Sunday 12 May 2013

Best Oracle Personal Training (On-line Training) by Oracle Architect at cheap, affordable Price.


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.