Oracle 10g Administration

KeyStone Learning Systems LLC
Frederick, MD, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 1.0 Installing Software
1.1 Identify system requirements
1.2 Use Optimal Flexible Architecture
1.3 Install software with Oracle Universal Installer
1.4 Identify and configure commonly used environment variables

2.0 Create a Database
2.1 Oracle Database Architecture
2.2 Oracle Instance Architecture
2.3 Management framework
2.4 Create database with DBCA
2.5 Configure database with DBCA
2.6 Drop database with DBCA
2.7 Manage Templates with DBCA

3.0 Database Interfaces
3.1 Accessing 10g Database
3.2 Describing logical structures
3.3 Query and Manipulate data and structures
3.4 Common Database Interfaces
3.5 Describe a Transaction

4.0 Managing Objects
4.1 Create and modify tables
4.2 Define constraints
4.3 View attributes of a table
4.4 View contents of a table
4.5 Create indexes and views
4.6 Name database objects
4.7 Selecting appropriate database objects
4.8 Create and use sequences
4.9 Define the purpose of tablespaces and data files
4.10 Create tablespace
4.11 Manage tablespaces
4.12 Obtain tablespace information
4.13 Drop tablespaces
4.14 Describe default Tablespaces

5.0 Managing and Accessing Data
5.1 Manipulating data through SQL
5.2 Using data pump to export
5.3 Using data pump to import
5.4 SQL Loader
5.5 Create directory objects
5.6 Identify PL/SQL objects
5.7 Describe triggers and triggering events
5.8 Configuration options that effect PL/SQL performance

6.0 Undo Management
6.1 Monitor and administer undo
6.2 Configure undo retention
6.3 Guarantee undo retention
6.4 Undo advisor
6.5 Relationship between undo and transactions
6.6 Sizing the undo tablespace

7.0 Database Security
7.1 Principal of least privilege
7.2 Default user accounts
7.3 Implement standard passwordsecurity features
7.4 Audit database activity
7.5 Register for security updates

8.0 Oracle net services
8.1 TNSPING to test connectivity
8.2 Describe Oracle Net Services
8.3 Describe Oracle Net Names resolution methods
8.4 Use database control to create additional listeners
8.5 Use database control to create Oracle Net Service aliases
8.6 Use database control to configure connect time failover
8.7 Use listener features
8.8 Create and configure client and middle tier connections with Oracle Net Manager

9.0 Backup and Recovery
9.1 Describe basics of backup, restore and recovery
9.2 Describe types of failure that can occur in an Oracle Database
9.3 Tuning instance recovery
9.4 The importance of checkpoints, redo logs and archive log files
9.5 Configure archivelog mode
9.6 Configure the database for recoverability
9.7 Backing up
9.8 Consistent database backups
9.9 Hot Backups
9.10 Incremental backups
9.11 Automating backups
9.12 Monitoring flash recovery
9.13 Image copies and backup sets
9.14 Different types of backups
9.15 Backing up the controlfile
9.16 Manage recoveries
9.17 Recover from loss of a control file
9.18 Recover from loss of a redo log
9.19 Recover from loss of a system critical data file
9.20 Recover from loss of a non-system critical data file

10.0 Administering users
10.1 Create and manage user accounts
10.2 Create and manage roles
10.3 Grant and revoke privileges
10.4 Controlling resources

11.0 Oracle Shared Servers
11.1 When to use
11.2 Configure shared servers
11.3 Monitor shared servers
11.4 Shared server architecture

12.0 Performance monitoring
12.1 Invalid and unusable objects
12.2 Optimizer statistics
12.3 Performance metrics
12.4 React to performance issues
12.5 Setting warning and alert thresholds
12.6 Collect baseline metrics
12.7 Automatic Database Diagnostic Monitor
12.8 Tuning and diagnostic advisors
12.9 Automatic Workload Repository
12.10 Server generated alerts
12.11 Detect and resolve lock conflicts
12.12 Manage deadlocks
12.13 Transactions and locks
12.14 Lock Modes in 10g
...''

Phone:1-800-949-5590

School Address:

The companies are headquartered in Frederick, MD with offices in Lynchburg, VA.


Jobs & Resumes: Frederick
Houses & Roommates: Frederick

GroupWise 7
Mac OS X Tiger
Microsoft Office Outlook 2007
Microsoft Office PowerPoint 2007
Quicken 2000
Microsoft Office Word 2007
Cisco CCNP
CompTIA A+ 2005
CompTIA Network+ 2005
CompTIA Security+ 2005
Corel Draw 10
Microsoft Publisher 2003
Lean 6 Sigma
Computer Security Awareness Training (CSAT)

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.