| Oracle 9i/10g Training
Who should take this course?
Students who like to become Oracle DBA for enterprises and get certified as a Oracle certified DBA, in this course you’ll learn the foundation in basic database administration, how to install and maintain Oracle databases, gain a complete understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including creating (new tables, columns, keys, views, indexes) database security, user management,
Replication, backup/recovery and performance monitoring techniques. You will also learn SQL from basic to mid level to query data, joins, creating views, creating indexes, creating store procedures.
As a bonus you will get the introduction to Oracle 10g and its enhanced features.
Course Description:
Introduction (Database Architecture)
Describe course objectives
Explore the Oracle database architecture
Installing the Oracle Database Software
Explain core DBA tasks and tools
Plan an Oracle installation
Install multiple instances
Creating an Oracle Database
Create a database with the Oracle Enterprise Manager
Create a database design template with Oracel Enterprise Manager
Managing the Oracle Instance
Start and stop the Oracle database and components
Use Oracle Enterprise Manager (OEM)
Access a database with OEM and SQL Plus
Modify database initialization parameters
Understand the stages of database startup
View the Alert log
| Managing Data and Concurrency
Manage data through SQL
Identify and administer PL-SQL Objects
Describe triggers and triggering events
Monitor and resolve locking conflicts
Administering User Security
Create and manage database user accounts
Create Logins
Create Roles
Grant and revoke privileges
Implementing Oracle Database Security
Describe DBA responsibilities for security
Apply the principal of least privilege
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail
Backup and Recovery Concepts
Identify the types of failure that may occur in an Oracle Database
Learn Recovery Methods
Cold backup and Hot backup
Configure Archive logs
Performing Database Backups
Create consistent database backups
Back your database up without shutting it down
Create Cold and Archive log backups
Automate database backups
Monitor the backups
Performing Database Recovery
Recover databases
Recover from last full backup and transaction logs
Performance and Tuning
Learn to troubleshoot slow running queries
Usage of TKPROF
Using SQL Plus to troubleshoot
Replication Implementation
Learn different kind of replication concepts
Implementing replication
Setting up replication agents
Monitoring replication
|
Creating Jobs and Alerts
Create Multiple step jobs
Creating alerts and operators associated with jobs
Monitor the alerts
Learn PL-SQL
Learn PL-SQL and Query analyzer usage
Create queries to retrieve data
Create queries to manipulate data
From basics SELECT to JOINS
Learn to create views, indexes and store procedures
Lean Oracle 10g enhanced features
Learn new enhanced management studio
Learn new High availability tools like Database Mirroring
Learn new Enhanced security features
|
