Greenlink | Curriculam

Curriculam

Duration: 156 Hours (Six Months)

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
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
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
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
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
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
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
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
1. On the Premises Students Will Receive Hard Copies of the Written Exam Questions
2. Online Students Will Receive an Online Link Including Instructions
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
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
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
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
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
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
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
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
1.Database Upgrade: Manual vs. DBUA
2. Database Cloning
3. Duplicate Database
4. Interview Questions and Answers Discussion
5. Oral Presentation Quiz
6. Homework Will Be Provided
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
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
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
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
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
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
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
1. On the Premises Students Will Receive Hard Copies of the Written Exam Questions
2. Online Students Will Receive an Online Link Including Instructions
1. Oracle Database Certification Exam Guidelines
2. Job Placement Assistance: Resume Guidelines