Re: Road to Oracle Certification
So question for both of you: From where can I get the DVD tutorials for Oracle RAC, Streams or Goldengate?? There used to be CBTs earlier back in time when I was learning. Not sure if these are still out there or no.
Mirch, wut kinda electronic material have you got for RAC? Can you please send me if I ask?
Re: Road to Oracle Certification
SID can u please share the material you hav so far ? Most of the material i have rgt now is in my system let me jst mak a list then will let u knw. For the time being u jst share ur oracle knowledge , sources n the material tht u r using .
Re: Road to Oracle Certification
Mirch, wut kinda electronic material have you got for RAC? Can you please send me if I ask?
That is Oracle University Student guide and it is 11.3 M. If you have account at some fileshare server I can upload it for you there.
This is what it says :
•This course is designed for anyone interested in implementing a Real Application Clusters (RAC) database.
•The coverage is general and contains platform- specific information only when it is necessary to explain a concept using an example.
•Knowledge of and experience with Oracle Database 10g** architecture are assumed.**
**Lecture material is supplemented with hands-on practices
**
Re: Road to Oracle Certification
Jst Take A Look of my Oracle
And The Topic Covered Are
Oracle Database Administration Fundamentals I
Author - Gavin Powell
Total Time - 8 Hours
Welcome
Welcome
Prerequisites for this Course
About this Course
Technet Database Administration Manuals
Database Administration
Oracle Database Administration? pt. 1
Oracle Database Administration? pt. 2
The Basic Architecture of Oracle
Oracle Database Administration Tools
What are the Tools?
SQLPlus
SQLPlus Worksheet
iSQL*Plus
All the Other Oracle Tools
Database Configuration Assistant pt. 1
Database Configuration Assistant pt. 2
Oracle Enterprise Manager Console pt. 1
Oracle Enterprise Manager Console pt. 2
The Management Server and the Agent
Net Configuration Assistant and Net Manager
Oracle Enterprise Manager Console pt. 3
Oracle Enterprise Manager Console pt. 4
The Architecture of Oracle
Oracle Database Architecture
Memory Structures
Processes
Datafiles/Tablespaces/Objects
Control Files/Logging/Archiving/Recovery
COMMIT vs ROLLBACK
Rollback and Undo
Temporary Sort Space
How it all Fits Together
Oracle Managed Files
Partitioning
Installing Oracle and Creating a Database
The Oracle Installer pt. 1
The Oracle Installer pt. 2
The Oracle Installer pt. 3
Configuration Parameter Files pt. 1
Configuration Parameter Files pt. 2
SQL*Net Configuration Files
Oracle Optimal Flexible Architecture
Windows Specifics pt. 1
Windows Specifics pt. 2
Creating a Database with a Script pt. 1
Creating a Database with a Script pt. 2
Starting Up and Shutting Down a Database
Connecting to a Database
STARTUP Command pt. 1
STARTUP Command pt. 2
SHUTDOWN Command pt. 1
SHUTDOWN Command pt. 2
Combining STARTUP and ALTER DATABASE
The Oracle Enterprise Manager Console
Configuration Parameters
What is the Parameter File?
Looking at Parameters
The Parameters and What They Do pt. 1
The Parameters and What They Do pt. 2
The Parameters and What They Do pt. 3
DDL and the Physical Database
DDL and the Physical Database?
The ALTER DATABASE Command
Looking at the Database
Changing Datafiles
Sizing of Datafiles
Datafiles and Tempfiles
Control Files
Logfiles and Archives pt. 1
Logfiles and Archives pt. 2
The ALTER SYSTEM Command pt. 1
The ALTER SYSTEM Command pt. 2
Automated Undo/Manual Rollback pt. 1
Automated Undo/Manual Rollback pt. 2
Metadata Views
DDL and the Logical Database
What is the Logical Database?
Tablespace Management pt. 1
Tablespace Management pt. 2
Tablespace Management pt. 3
Metadata Views
Expanding Database Objects
Tables pt. 1
Tables pt. 2
Tables pt. 3
Indexes pt. 1
Indexes pt. 2
Clusters
Index Organized Tables
Sequences
UNDROP, PURGE and the Recycle Bin
Partitioning
Metadata Views pt. 1
Metadata Views pt. 2
Expanding Security for Database Administration
Types of Users
Grants and Revokes
Create and Alter User Syntax
Administration Users
Database Auditing
Scheduling
The DBMS_JOB Package
Job Scheduling in Oracle
Scheduling/Executing Jobs in Windows and Unix
Utilities
Export
Import
SQL*Loader
ORAPWD and ORADIM
Built-In Packages
Supplied Packages
Scripting for Automation
Some Example Scripts
Oracle Database Administration Fundamentals II
Welcome
Welcome
Prerequisites for this Course
About this Course
Oracle Net Services on Technet
Oracle Backup and Recovery on Technet
Other Applicable Technet Options
Introducing Oracle Net Services
What is Oracle Net Services?
Three Basic Configurations
Managing Oracle Database Networks
Local Versus Centralized Naming
Simple Server Configuration
Oracle Shared Servers or MTS pt. 1
Oracle Shared Servers or MTS pt. 2
Simple Client Configuration
Connection Profiles
Introducing Naming Options pt. 1
Introducing Naming Options pt. 2
Oracle Connection Manager
Net Configuration Assistant
Net Manager
Using Oracle Enterprise Manager
Introducing Backup/Recovery Options/Utilities
Different Backup and Recovery Options
Import and Export
Cold Backups (Offline)
Hot Tablespace Backups (Online)
RMAN or Recovery Manager
Recovery
Standby Databases
Physical Standby Databases
Logical Standby Databases
Replication
Replication by Other Means
What are Transportable Tablespaces?
What is SQL*Loader?
Oracle Net Services Architecture
Net Services Architecture
The Open Systems Interconnection (OSI) Model
Oracle OSI Model
Protocols
Net Services Communication
Dedicated and Shared Connections
Shared Server Processes and Dispatchers
Configuring a Simple Connection
Listener Configuration File
The TNS Names Configuration File
The Profile Parameters File
Basic Database Configuration Parameters pt. 1
Basic Database Configuration Parameters pt. 2
Using the Net Configuration Assistant pt. 1
Using the Net Configuration Assistant pt. 2
The Listener
What is the Listener? pt. 1
What is the Listener? pt. 2
Basic Listener Configuration
The Listener Control Utility
Service Registration
Listener Queue Size
Switching Off Listener Logging and Tracing
Timeouts
Multiple Listeners pt. 1
Multiple Listeners pt. 2
Connection Load Balancing and Failover
The Session Data Unit Buffer (SDU)
Connection Profile Configuration
Connection Strings and Naming Methods
Connection Strings
Naming Methods
Local Naming Using TNS
Host Naming
External Naming
Directory Naming pt. 1
Directory Naming pt. 2
Oracle Names Server
Oracle Shared Servers
Multithreaded Server
Introducing Dispatchers
Dispatchers and Connection Pooling
Other Shared Server Parameters
Overriding Shared Servers
Connection Manager
What is Connection Manager?
Connection Concentration
Multiple Protocol Support
Configuring Connection Manager
Other Oracle Net Services Utilities
Other Oracle Net Services Utilities
Oracle Net Services Advanced Features
What is TAF?
TAF Parameters
Configuring TAF
Non-Oracle Database Connections
Oracle Net Services Metadata
Performance Views
Backup and Recovery
What is Backup and Recovery?
Why Backup and Recovery?
Things to Remember
Things to Consider with Datafiles
Redo Logs
Controlfiles
Archive Logs
More Things to Consider
Yet More Things to Consider
Importance of Backup and Recovery
Points of Failure 1312 Backup Strategy
How Backup and Recovery Works
Processes/Memory Structures/Checkpoints
All the Files
SCNs
Restore and Recovery
Archive Configuration
Basic Archive Configuration Parameters
Archive Log Mode Configuration pt. 1
Archive Log Mode Configuration pt. 2
Multiple Archiving Processes
Multiple Archive Destinations
Standby Archiving pt. 1
Standby Archiving pt. 2
Logical Backups Using Exports
Full Exports and Imports
Schemas
Multiple Schemas
Importing to a Different Schema
Tables
The Parameter File
Export and Import Options
Physical Backup/Restore/Recovery
Cold Backups
Hot Backups
Verify Backups Using DBVERIFY
Recovering using Offline Physical Backups
Recovering using Online Physical Backups
Read Only Tablespaces
Incomplete Recovery
Scripting Hot Backups
RMAN (Recovery Manager)
What is RMAN?
Repository and Catalog
The Recovery Catalog
RMAN Architecture
What is a Channel?
Allocating and Releasing Channels
Creating an RMAN Database
Creating a Repository
Connecting to RMAN
Registering Databases with the Repository
Viewing the Repository
Backup Sets
Types of Backups
Controlfile Backups
Datafile Backups
Tablespace Backups
Archive Log Backups
Binary Parameter File Backups
Database Backups
Incremental Backups
Restore and Recovery
Restore and Recovery in Action
Scripts and RMAN
Deleting RMAN Backups
Oracle Enterprise Manager Backup and Recovery
Configuring Oracle Enterprise Manager
Communications
Win2K Log on as Batch Job
Export
Import
Backup and Recovery
Backup and Recovery Metadata
Performance Views
Transportable Tablespaces
What are Transportable Tablespaces?
Uses of Transportable Tablespaces
Limitations
Tablespace Sets
Tablespace Set Verification
Transporting a Tablespace Set
Plug In
SQLLoader
What is SQLLoader?
The Control File and Complexity
Input Data File
Input Data File Structures
How Rows are Loaded
Multiple Tables and Formats
Column Delimiters
NULL Values
Load Filtering
Filler Fields
Data Types
Conditional Replacement
Using SQL
Generating Data Not in Input Files
Executing SQL*Loader
Conventional Versus Direct
The Parameter File
A Simple Example Load pt. 1
A Simple Example Load pt. 2
Oracle Enterprise Manager
3 ) racle\Oracle Database 10g Express Edition Tutorial
Learning Objectives
After taking this tutorial, you should be able to:
Install Oracle Database 10g Express Edition
Access the Oracle Database Home Page
Manage Database Objects
Access and Manipulate Data
Create an Application using HTML DB 2.1
Add PL/SQL Functionality to an Application
Administer and Monitor the Database
Create an Application using Visual Studio .NET
Create an Application using PHP
ORACLE DBA - THE COMPLETE VIDEO COURSE
Oracle NBU Video
this covers the Following
Oracle Fundamentals Brown Bag
Session Description Video / Presentation Links
Architectural Components Watch Video
Accessing & Controling the Oracle Database Watch Video
Transactions and Consistency Watch Video
Oracle Recovery Structures & Processes Watch Video
Oracle Backup and Recovery Configuration Watch Video
User Managed Backup Watch Video
User Managed Complete Recovery Watch Video
Incomplete Recovery Watch Video
Watch Video
Backups Using Recovery Manager Watch Video
RMAN Complete Recovery Watch Video
RMAN Incomplete Recovery Watch Video
Oracle Recovery Catalog Reporting & Maintenance Watch Video
Complete Vdo CD
Time Title
07:03 Series Intro
40:14 SQL Plus and iSQL Plus
28:01 Installing Oracle Software and Creating a Database
33:08 Oracle Database and Instance Architecture
28:58 Startup, Shutdown, and the Initialization File
34:14 Managing Tables, Views, Constraints and Sequences
32:55 Data Moving Utilities
43:23 PL/SQL Basics
47:49 Triggers, procedures, functions
22:49 Packages
23:47 Managing undo
28:57 Tablespaces
25:52 Managing users
29:43 Oracle net services
30:39 Oracle’s shared server option
24:39 Oracle security
37:21 Locks, latches, and waits
42:39 Performance
27:45 Backup and Recovery Techniques
30:31 Backups using RMAN
42:59 Database recovery
26:41 Enterprise Manager
This Floder size is around 7 Gb . Thats the Biggest oracle warehouse that i have. Might ther r are alot of Books ther in my other drives . I wish i can cover them all thoroughly. U can Cover the VTC oracle-10g-tutorials that is i gues enough for the prep.
Re: Road to Oracle Certification
That is Oracle University Student guide and it is 11.3 M. If you have account at some fileshare server I can upload it for you there.
This is what it says : •This course is designed for anyone interested in implementing a Real Application Clusters (RAC) database. •The coverage is general and contains platform- specific information only when it is necessary to explain a concept using an example. •Knowledge of and experience with Oracle Database 10g** architecture are assumed.** **Lecture material is supplemented with hands-on practices
**
can u pleez upload it onlin n share the link if u wont mind. u can upload it any good dataserver n share the link.
Re: Road to Oracle Certification
I will see if I can open an account on a fileshare website.
Re: Road to Oracle Certification
Just went through this link and thought to share it:
Re: Road to Oracle Certification
Um.. may be very big organizations like AIG or others let you do that but it doesnt happen in ours. Also, things were way different three years back. Now its totally opposite. Your BIL can let you in if you talk to him upfront. Earlier, many ppl used to go bak to india and do all that, come back and take the best of jobs. But remember, when they used to come back, they used to show 9, 10 years experiance. Thats wut its all about.
I was gonna make a mention of showing at least 5-6 years of experience after the training. It is just that somehow you need to back up your claim of training & get through the interview process, especially the skills interview portion. A lot of consulting firms re-do your resume and fudge it to show experience, but the problem arises when future employer requests Business References. Now if you have been working (just not in that field) you can always get away with it. However if you don't have any work experience as of late, I am not sure what you can do.
Re: Road to Oracle Certification
Amazing link …
thank u so much .