Oracle 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