Sponsored Links
Oracle 10g Tutorials
- Oracle 10g Tutorials : Oracle Net Services
- Oracle 10g Training - Triggers And Triggering Events
- Oracle 10g Tutorials - Identifying PL/SQL Objects
- Oracle 10g Tutorials - SQL*Loader Discarded and Rejected Records
- Oracle 10g Tutorials- SQL*Loader - Input Data and Datafiles
- Oracle 10g - SQL*Loader
- Oracle 10g - Using Data Pump Export
- Oracle 10g Free Training - Using Data Pump Import
- Oracle 10g Free Training - Data Pump Components
- Oracle 10g Free Training - Manipulating data through SQL
- Oracle 10g Free Training - Synonyms
- Oracle 10g Free Training - Sequences
- Oracle 10g Tutorials- Updating Views
- Oracle 10g Tutorials - Creating Views, Altering, Dropping and Replacing Views
- Oracle 10g Tutorials -Creating Index-Organized Tables
- Oracle 10g Tutorials: Altering Tables
- Oracle 10g Tutorials : Dropping Tables
- Oracle 10g Tutorials : Creating Tables
- Oracle 10g Tutorials: Tables
- Oracle 10g Tutorials: Overview of Schemas and Common Schema Objects
Tutorials
Oracle 10gOracle 10g DBA Free Training
Oracle 10g DBA Free Training: We are excited to let you know that we will be starting Oracle 10g DBA training course shortly. We will provide code samples along with the screen shots and step by step instructions for you to learn and practice on your own. All these tutorials are prepared exclusively for Exforsys.com by Oracle Professionals and Certified DBA's. Feel free to post any questions you might have during this training in our forums. Let us know if you have any specific topics in mind which are not covered.
This course enables learners to gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.
You also will learn salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed at length.
You also will learn about Database Security. This course will help the learner to understand the benefits of database auditing and monitoring. It also covers Database Listeners and Services. The concept of shared and dedicated servers is also covered. After going through this course, the learners would be able to tune the system for best performance by configuring automatic alerts and thresholds.
You must have SQL knowledge prior to this course. Please go though the Oralce 9i SQLand SQL*Plus training course prior to start with this. Here is the link...
Oracle 9i SQL and PL*SQL Training Course
Here are the list of topics will be covered in this Learning Series..
Click here for Oracle 10g DBA training course
1. Introduction:
Identify the oracle
product
Describe the basic
concept of a relational database
2. Installing oracle database 10g software:
System requirements.
Use Oracle Optimal
Flexible Architecture (OFA)
Install software with the
Oracle Universal Installer.
3. Create an oracle database:
Oracle Database
Architecture.
Oracle instance
architecture.
Use the management
framework.
Use the Database Creation
Assistant.
4. Controlling the database:
Start and stop the
agent
Start and stop the
enterprise manager database console
Start and stop the
listener
Startup and shutdown the
database
5. Storage Structures
Defining the
tablespaces and data files
Create tablespaces
Manage tablespaces
Obtain tablespace
information
Create and manage
tablespace using oracle enterprises manager.
6. Administering users:
Create and manage
database user accounts
Create and manage roles
Grant and revoke
privileges
Control resource usage by
users.
7. Managing schema objects
Create and modify
tables
Define constraints
View the attributes of a
table
View the contents of a
table
Create indexes and views
8. Managing Data
Manipulating data
through SQL
Using Import
Using Export
Using SQL Loader
9. PL/SQL
Identify PL/SQL
objects
Understand triggers and
triggering events
Identify configuration
options that affect PL/SQL performance
10. Oracle Database Security
Apply the principal
of least privilege
Manage default user
accounts
Implement standard
password security features
Audit database activity
11. Oracle Net Services
Understand Oracle Net
concepts
Use Oracle Net Manager to
create and configure listeners
Use the listener control
utility to control the Oracle Net Listener
Use the Oracle Net
Manager to configure client and middle-tier connection
Use TNSPING to test
Oracle Net connectivity
12. Oracle Shared Server
Understand when to
use Oracle Shared Servers
Configure Oracle Shared
Servers
Monitoring Shared Servers
13. Performance Monitoring
Troubleshoot invalid
and unusable objects
Gather optimizer
statistics
View performance metrics
React to performance
issues
14. Proactive Maintenance: Objectives
Set warning and
critical alert thresholds
Collect and use baseline
metrics
Use tuning and diagnostic
advisors
Use the Automatic
Database Diagnostic Monitor (ADDM)
Manage the Automatic
Workload Repository
15. Undo Management
Monitor and
administer undo
Configure undo retention
Guarantee undo retention
Use the undo advisor
16. Monitoring and Resolving Lock Conflicts
Detect and resolve
lock conflicts
Manage deadlocks
17. Backup and Recovery
Describe the basics
of database backup, restore and recovery
List the types of failure
that may occur in an Oracle Database
Describe ways to tune
instance recovery
Identify the importance
of checkpoints, redo log files, and archived log file
Configure ARCHIVELOG mode
18. Database backups
Create consistent
database backups
Back your database up
without shutting it down
Create incremental
backups
Automate database backups
Monitor the flash
recovery area
19. Database Recovery
Recover from loss of
a control file
Recover from loss of a
redo log file
Recover from loss of a
data file
20. Using Globalization Support
Datetimes with
Timezones
Specifying
Language-Dependent Behavior
Locale Variants
Linguistic Sorting
Case and Accent
Insensitive Sorts
Linguistic Comparisons
Obtaining Information
about the Current NLS Configuration
21. Diagnostic Sources
The Alert Log
Viewing Alerts with EM
Alerts Notification
Editing Thresholds
Trace Files
22. Recovering from non-critical losses
Creating New
Temporary Tablespace
Recreating Redo Log Files
Recovering an Index
Tablespace
Read-Only Tablespace
Recovery
Loss of Password
Authentication File
23. Automatic Storage Management
ASM Concepts
ASM General Architecture
Creating an ASM instance
Creating tablespaces that
use ASM storage
Viewing ASM information
Migrating a tablespace to
use ASM storage.
24. Flashback database
When to Use Flashback
Technology
Configuring Flashback
Database
Monitoring Flashback
Database
Best Practices for the
Database and Flash Recovery Area
Flash Recovery Area Space
Usage
Flashback Database
Examples
25. Monitoring and Managing Memory
Oracle Memory
Structures
Automatic PGA Memory
Management
Using the Memory Advisor
Using Automatic Shared
Memory Management to avoid long running query issues
26. Automatic Database Management
Automatic Optimizer
Statistics Collection
Workload Repository
Database Control and
Advisors
Using the SQL Tuning
Advisor
Using the SQL Access
Advisor
Automatic Undo Retention
Tuning
27 Monitoring and Managing Storage
Redo Logfile Size
Advisor
Resumable Statements
Tablespace Space Usage
Monitoring
Accessing the Segment
Advisor
Shrinking Segments Using
SQL
Segment Resource
Estimation
Monitoring Index Space
Identifying Unused
Indexes
Click here for Oracle 10g DBA training course
Comments
Engr. Asad Khalid said:
| Thanks for offering such a course online, and for free. |
admin said:
| Thanks Henry ... Typo corrected. |
Ankit Swami said:
| tell me the palce where u give free training for that such course |
rojasmilein said:
| Thanks for offering such a course online, and for free. ;)[b][/b] |
Al raz said:
| ::) ur course content is excellent , it would hav been better if u cud include some contents on RAC. |
padma.g said:
|
It was so useful for me.thanks alot for your tarining which is very valuable and price less.this would be veryful for who wants learn oracle dba from home. once again thanks |
osita onwordi said:
| silent heroes, that what u are.u shure are not going to regret this. |
Samir Parekh said:
| It's unbeliveable to find such a course free online. .......... |
psunil_chowdary said:

| thanks for this offer |
tapia said:

|
i would like to thanks to u for teachin oracle its very easy n online n laungage is using by author is very simple too |
janeman said:
| thankz for giving this expensive course for free |
the_developer said:

| What a nice place, people, site and idea. many thanks for your work. it is exciting indeed. |
nandhasri said:

| HOw can i take this course? |
rashmi.raghavendra said:

| please tell how can i take this course , where is the link |
Monther A. Abu Salem said:
|
Its nice to know honest people offering their knowledge for free. Thanks alot and GO AHEAD. |
andrewli7 said:

|
Thanks for offering this free training. Is there any way to download the whole Oracle 10g free training in one file instead of copying and pasting page by page in a doc? |
Muhammad Azam said:

| Tks. if it is (really) for FREE |
Mir MD. Wazior Rahaman (Sumon) said:
| Thanks a lot .This Site is very helpful to IT people. |
T.Thiagarajan said:
|
Thanks for this free Oracle Free Dba training, Lot of Thanks |
SUJATHA G said:

| Thank u very much. Pl inform the commencing date so that we will be aware of following it regularly. |
umar_solanki said:

| what is the requirement for oracle dba in the market |
K.Sarangapani said:

|
Thanks a lot, it is very helpful to me & to my friends. please also provide complete information of Oracle(D2K Apps Technical forms & reports...which are very useful to ERP professionals).. Thanks & Regards, K.S.Pani |
babatunde.richard said:

|
it will highly be appreciated if we will be notifiy as soon as this course commence either by mailing or ..... Kind Regards Richard |
shuvo26 said:

| Really:I am really looking forward to this course.But how to join it?Any URL?Or download link?When will it start.Thanx in advance. |
Deepthi77 said:

| pl send a mail abt the training starting date so tht v can follow regularly online |
vetrivel veerakesavan said:
| I am really looking forward to this course.But how to join it?Any URL?Or download link?When will it start.Thanx in advance. |
vaidyaji said:

|
One thing for sure., *** ITS UNBELIVABLE *** Also i would like to know if this material is available in one pdf or doc format and is it downloadable. if so can you pl send me the link. |
Kush said:

|
Hi, We are Thankful to you. Such gave a great platform for IT Professionals. online Oracle 10g training and other IT skills tutorials as well. Regards... Kushendra Parashar (Software Developer) |
mhossain96 said:

| How do i get training? where i can get link? |
Deepak Kumar Singh said:
| hi I am Deepak and searching for Free oracle DBA 10g training. it is good news for me and all those students who want to learn oracle 10g. |
Fatima said:
|
Hi, i would like to know the exam code which i will be able to give after studying this course? Thanks & Regards |
lokeshm said:

|
You can access the tutorials for Oracle 10g DBA training course here http://www.exforsys.com/tutorials/oracle-10g.html |
Anujthegreat said:
| good to know u r serving for our DBA community |
MisraAmit said:
| What a great site....Three Cheers for u |
sandeep pande said:
|
this is a great portal for gaining oracle 10g knowledge |
shefu said:

| hello i would like to know whenever i install oracle 10g in netmanager listners database services it shows me oracle 8i database name and sid why? |
vikram(4cplus internet co. ) said:
|
this is a great portal for gaining oracles ............. knowledge |
Smitha Mariam Skaria said:
| Thankyou for providing such a wonderful material |
Khadija said:
| where to find the basics and the very first things to learn for being a DBA, thanks in advance |
Madhu Babu N said:

| beautiful material |
hashal said:
| its good document |
nasir mumtaz said:
| it has an excellent material. |
nagendar cherukuri said:
| Hi, this site is very useful for people who really wants to build a career in Data base admin, please can u let me know when the training starts?. |
doublepow said:

|
Hi, Very good resource, I am very thankful. But the topics don't seem to be in order. Can you correct their order please? Thanks. |
SatIsh Nawle said:
|
Than kyou for providing such a wonderful material. Thanks & Ragard Satish Nawle SQL STAR Pune |
Kotamsudhir said:
| Thankyou for such Good material provied online |
mercuryz said:
|
Can I get the link for this course? email: connect2deepak@gmail.com |
Joseph1 said:
|
Deepak, Here are the tutorials .... http://www.exforsys.com/tutorials/oracle-10g.html please scroll down to see complete list... http://www.exforsys.com/learn-oracle.html Thanks, |
mercuryz said:
| Thanks Joseph1.... |
tummie said:

|
i just joined this forum but i have enjoyed going thru the courses that u offering i am a newbie to oracle ,it has really simplified my understanding of so many things that i did not understand.keep u the good work guys.. |
SAKSHI Sekhar said:
|
Thankyou very much for provieding online material. |
bandar said:
|
thank you for your offer about oracle 10g training I plan to get the oracle certification but I need some courses before I am living in Toledo,Ohio can you provide if there is any company or school in toledo for oracle 10 g my email:b.abukarsh@gmail.com |
sherry said:
|
hey where is the rest of the topics after the Oracle Net Services please provided thankz |
ganesh said:
| hi sir i completed oracle10g coursewant to know more knowledge of this course plz provide some coding,simple queries&commends also |
shankar said:
| please provide the essential features of commands and all in oracle 10g |
Mumtaz Alam said:
| I am really excited to know this brilliant offer but still unblievable,pl email me once the course commences. |
Kinjal said:
|
Hi I am really interested in this training how do i get it. Thanks a lot for such a wonderful training. |
Fuad Hassan said:
|
I am really interested to do this training. How can I attend this training? |
kondalarao.kudali said:
| this site is very useful to every dba |
raviprakashredd said:

|
hi Iam very much interested in this training where can i get the details of this training can anyone pls suggest |
nila said:
|
Hi I am really interested in this training how do i get it. Thanks a lot for such a wonderful training. |
Muhammad Khan said:
|
Hi: I like to get training. Please inform me the procedure.Thanks |
Namit Bansal said:

|
Hello: it helps allot to every one to become a good dba |
Namit Bansal said:

|
i am ready to become a good dba |
senthil.thbs said:

|
It is great to hear this. Thanks to exforsys for providing this great apportunity !... Thanks Exforsys Team and all the best !.. Keep going !... |
siddhesh316 said:

|
I was surfing the net 2 days back and found this wonderful site. Thanks a lot for this amazing training...:) Keep up the good job guys... |
Sponsored Links
