Curriculam

Greenlink / Curriculam

Duration: 156 Hours (Six Months)

Oracle Database Introduction and Architecture – 2 Days (6 hours)

1. Oracle Database Introduction
2. Oracle Database Technical Architecture Overview
3. Benefits of Oracle Database
4. Data Warehousing (DW)
5. On-line Transaction Processing (OLTP)
6. Physical Network and Storage
7. Tasks of an Oracle Database Administrator
8. Interview Questions and Answers Discussion
9. Oral Presentation Quiz
10. Homework Will Be Provided

SQL and PL/SQL Tutorial – 2 Days (6 hours)

1. Introduction to RDBMS
2. Introduction to SQL and PL/SQL
3. Introduction to Data Model
4. DML, DDL, DCT & TCL
5. Database Objects: Table, View, Index, Sequences, Synonyms, Constraints, Joins, Unions, Stored, Procedures, Triggers
6. Functions: LPAD, RPAD, CHR, LTRIM, CONCAT, RTRIM, INITCAP, TRIM, REPLACE, LENGTH, LOWER, SUBSTR, UPPER
7. Date Timestamp: ROUND, CURRENT DATE, SESSIONTIMEZONE, CURRENT TIMESTAMP, SYSDATE, DBTIMEZONE, SYSTIMESTAMP, EXTRACT, TO_CHAR, LAST_DAY, TO_DATE, LOCALTIMESTAMP, TO_TIMESTAMP, MONTHS_BETWEEN
8. Interview Questions and Answers Discussion
9. Oral Presentation Quiz
10. Homework Will Be Provided

Oracle Software and Database Installation – 2 Days (6 hours)

1. Database Prerequisites and Installation Process
2. Oracle Universal Installer (OUI)
3. Installing Oracle Database Software/Binaries
4. Oracle Database Tools: DBCA, DBUA, RMAN, NETCA, NETMGR, EXPDP, IMPDP, EMCTL, SQLLDR
6. Planning/Designing a Database
7. Using DBCA for Database Creation
8. Interview Questions and Answers Discussion
9. Oral Presentation Quiz
10. Homework Will Be Provided

Managing Oracle Database Instance – 2 Days (6 hours)

1. Database Access using SQL*Plus
2. Background Processes Architecture
3. Memory Structures: SGA vs. PGA
4. Database Startup/Shutdown Options
5. Parameter Files/Control Files/Data Files
6. Access Dynamic Performance Views & Data-dictionaries
7. Interview Questions and Answers Discussion
8. Oral Presentation Quiz
9. Homework Will Be Provided

Oracle Database Storage Architecture – 2 Days (6 hours)

1. Integrated Technical Storage Architecture
2. Data Warehouse vs. Transactional Database Modeling
3. Managing Logical and Physical Storage Unit
4. Oracle Managed Files (OMF)
5. User Managed Files (UMF)
6. RAID System
7. Interview Questions and Answers Discussion
8. Oral Presentation Quiz
9. Homework Will Be Provided

Controlling User Access – 2 Days (6 hours)

1. Database User Accounts
2. User Grants, Roles and Profiles
3. System Privileges
4. Object Privileges
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7. Homework Will Be Provided

Oracle Database Network Configuration – 2 Days (6 hours)

1.NETCA (Network Configuration Assistance)
2. NETMGR (Network Manager)
3. LSNRCTL (Listener Control)
4. tnsnames.ora, lsnrctl.ora & sqlnet.ora files
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7. Homework Will Be Provided

Review/Summary – 1 Day (4 hours)

1. Review of All the Topics Above
2. Oral Presentation Quiz
3. Students on the Premises and Online Will Be Asked to Perform Database Activities

Exam # 1 – 1 Day (2 hours)

1. On the Premises Students Will Receive Hard Copies of the Written Exam Questions
2. Online Students Will Receive an Online Link Including Instructions

Managing Undo Data and Recycle Bin – 2 Days (6 hours)

1. Data Transactions and Undo Data
2. Undo Data vs. Redo Data
3. Undo Retention Configuration
4. Oracle Recycle Bin
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7. Homework Will Be Provided

Database Auditing – 2 Days (6 hours)

1. Enable Standard Database Auditing
2. Specify Audit Options
3. Review Audit Information
4. Maintain the Audit Trail
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7. Homework Will Be Provided

Database Performance Monitoring – 2 Days (6 hours)

1. Analyzing Database Size Growth
2. Invalid and Unusable Objects
3. SQL Execution Using EXPLAIN PLAN
4. Oracle STATSPACK Reporting
5. Automatic Database Diagnostic Monitor (ADDM)
6. Automatic Workload Repository (AWR)
7. Interview Questions and Answers Discussion
8. Oral Presentation Quiz
9. Homework Will Be Provided

Oracle Database Rollback and Flashback Technology – 2 Days (6 hours)

1. Database Rollback Usages
2. Flashback Introduction
3. Flash Recovery Area Usages
4. Flashback Using TIMESTAMP or SCN
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7. Homework Will Be Provided

Database Backups – 2 Days (6 hours)

1. Backup Methods and Solutions
2. Oracle Managed Backup: RMAN
3. User-Managed Backup: Manual
4. Configuring Backup Settings
5. Performing Full, Log and Differential Backups
6. RMAN Recovery Catalog
7. Interview Questions and Answers Discussion
8. Oral Presentation Quiz
9. Homework Will Be Provided

Database Restore and Recovery – 2 Days 6 hours)

1. Database File Loss
2. Amount of Data Loss
3. Choosing a Recovery Model
4. Full Database Restore and Recover
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7. Homework Will Be Provided

Moving Data – 2 Days (6 hours)

1. Describe Ways to Move Data
2. Create and Use Directory Objects
3. Use SQL*Loader to Move Data
4. Use External Tables to Move Data
5. Use Data Pump Export and Import to Move Data
6. Interview Questions and Answers Discussion
7. Oral Presentation Quiz
8. Homework Will Be Provided

Oracle Support – 2 Days (6 hours)

1. Work With Oracle Support
2. Service Requests (SR)
3. Quarterly Patch Apply
4. Interview Questions and Answers Discussion
5. Oral Presentation Quiz
6. Homework Will Be Provided

Oracle Database Available Features – 2 Days (6 hours)

Introduction to Oracle Data Guard – 2 Days (6 hours)

1. Data Loss Concept
2. Oracle Data Guard Architecture
3. Standby Databases Types
4. Data Guard Broker vs. Manual Method
5. Data Protection Modes
6. Switchover and Failover
7. Interview Questions and Answers Discussion
8. Oral Presentation Quiz
9. Homework Will Be Provided

Creating Physical Standby Database – 2 Days (6 hours)

1. Preparing the Primary Database
2. Creating the Physical Standby Database
3. Interview Questions and Answers Discussion
4. Oral Presentation Quiz
5. Homework Will Be Provided

Oracle Data Guard Broker Overview – 2 Days (6 hours)

1. Data Guard Broker Features and Benefits
2. Data Guard Broker Configurations
3. Data Guard Monitor Process
4. Using DGMGRL
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7. Homework Will Be Provided

Oracle ASM Overview – 2 Days (6 hours)

1. Prerequisites for ASM File System
2. ASM Features and Benefits
3. ASM System Privileges and OS Groups
4. ASM Disk Group Creation
5. Accessing ASM Instances
6. Interview Questions and Answers Discussion
7. Oral Presentation Quiz
8. Homework Will Be Provided

Administering ASM Disk Group – 2 Days (6 hours)

1. Using ASMCA and ASMCMD
2. Starting/Stopping ASM Instances
3. ASM Initialization Parameters
4. ASM File System From Standalone and Real Application Cluster Database
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7.Homework Will Be Provided

Oracle RAC Concepts – 2 Days (6 hours)

1. Real Application Cluster (RAC) Overview
2. Benefits of Using RAC
3. Oracle Cluster File System
4. Clusters and Scalability
5. Interview Questions and Answers Discussion
6. Oral Presentation Quiz
7.Homework Will Be Provided

Installing and Configuring Oracle RAC – 2 Days (6 hours)

1. Installing Oracle Database Grid Infrastructure, Software Installation, and Creating a Cluster Database
2. Starting and Stopping RAC Instances
3. RAC Initialization Parameter Files
4. Quarterly Patch Application
5. Database Type Selection, Database Identification
6. Cluster Database Management Options
7. Database File Locations, Recovery Configuration, Database Content
8. Database Configuration
9. Interview Questions and Answers Discussion
10. Oral Presentation Quiz
11. Homework Will Be Provided

Exam # 2 – 1 Day (2 hours)

1. On the Premises Students Will Receive Hard Copies of the Written Exam Questions
2. Online Students Will Receive an Online Link Including Instructions

Student Support – 2 Days (6 hours)

1. Oracle Database Certification Exam Guidelines
2. Job Placement Assistance: Resume Guidelines

No Comments

Sorry, the comment form is closed at this time.