Attend a free Introductory class online every Sunday from 1:00-2:00 pm CST/11:00 am-12:00 pm PST/2:00-3:00 pm EST). To register send an email to support@globalinfomatics.com with subject line :Register for Introductory class
GI200 Oracle 10g Database Administration
New batch starting on March 13th 2010
| Course duration: 40 hrs | Trg Days: Saturday & Sunday |
| Timings: TBD | Cost:-email support@globalinfomatics.com for pricing |
|
List of currently scheduled courses click here
In ever evolving IT, one that always stays is a database. It is the mainstay of an application and critical to any organization. This course introduces Oracle 10g database, concepts, architecture, and administrative tasks. This course is designed and tailored for persons who are novice to Oracle database 10g.
Topics
- Session: Introduction
- Describe the basic concepts of a relational database
- Discuss core database administrator tasks
- Session: Installing Oracle Database 10g Software
- Identify system requirements
- Use optimal flexible architecture
- Install software with the Oracle Universal Installer
- Session: Create an Oracle Database
- Describe Oracle Database Architecture
- Understand the instance architecture
- Use the management framework, and the Database Creation Assistant
- Session: Controlling the database
- Start and stop the agent, the Enterprise Manager Database Console, and the listener
- Startup and shutdown the database
- Session: Storage Structures
- Define the purpose of tablespaces and data files
- Create and manage tablespaces
- Obtain tablespace information
- Session: Administering Users
- Create and manage database user accounts, and manage roles
- Grant and revoke privileges
- Control resource usage by users
- Session: Managing Schema Objects
- Create and modify tables, indexes and views, and Define constraints
- View the attributes and the contents of a table
- Session: Managing Data
- Manipulating data through SQL
- Use Import, Export, Data Pump and SQL Loader
- Session: Oracle Database Security
- Apply the principal of least privilege
- Manage default user accounts
- Implement standard password security features, and Audit database activity
- Session: Oracle Net Services
- Understand Oracle Net concepts
- Use Oracle Net Manager to create and configure listeners, and configure client and middle-tier connection
- Use the listener control utility to control the Oracle Net Listener
- Use TNSPING to test Oracle Net connectivity
- Session: Proactive Maintenance: Objectives
- Set warning and critical alert thresholds
- Collect and use baseline metrics
- Use tuning/diagnostic advisors/ADDM/ADR
- Session: Undo Management
- Monitor and administer undo
- Configure and Guarantee retention
- Session: Recovery Manager Configuration
- Parameters affecting RMAN
- Use of a Flashback Recovery Area
- The CONFIGURE Command
- Persistent Settings
- NOCATALOG / CATALOG mode
- Channel allocation
- Controlfile Autobackup
- Retention Policies
- Session: Recovery Manager Operations
- Using the BACKUP command
- Creating Backup Sets / Image Copies
- Compressed Backups
- Incremental Backups
- Block Change Tracking
- RMAN Backup Monitoring
- REPORT and LIST commands
- Session: Non-Critical Loss Recovery
- Password and network files
- Read-Only tablespaces
- Temporary tablespaces
- Index tablespaces
- Redo log members / Control files
- Session: Database Recovery
- Complete Recovery
- Incomplete Recovery
- Session: Flashback Database
- Configuration
- Monitoring Flashback Database
- Session: User Error Recovery
- Flashback Table
- Flashback Versions Query
- Flashback Transaction Query
- Session: Automatic Database Management
- Management and Advisory Framework
- Automatic Statistics Collection
- The Automated Workload Repository
- Database Advisors
- Automatic Statistics Collection
- Session: Scheduler
- Creating Jobs and Job Classes
- Creating Schedules and Windows
- Scheduler Programs
- Prioritizing Jobs
Audience
This course is geared towards training Oracle 10g Database Administrators.