WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
Hi, how can I help?

Oracle DBA

Training Curriculum:

ENTERPRISE EDITION INSTALLATION
 • IDENTIFY SYSTEM REQUIREMENTS
 • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
 • ORACLE_BASE
 • ORACLE_HOME
 • CONFIGURE THE INSTALLATION ENVIRONMENT
 • ENTERPRISE EDITION INSTALLATION • DBCA

  • THE ADMINISTRATOR INTERFACE
     • ENTERPRISE MANAGER TOUR
     • USING EM SQL WORKSHEET
     • DUTIES OF A DATABASE ADMINISTRATOR
     • EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL
  • THE ORACLE ENTERPRISE ARCHITECTURE
  • EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
     • WHAT IS AN ORACLE DATABASE INSTANCE?
     • MORE ABOUT THE SYSTEM GLOBAL AREA (SGA)
     • ABOUT THE PGA • MANAGING MEMORY
  • EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
     • INSTANCE BACKGROUND PROCESSES
     • SQL EXECUTION PROCESSES
  • CREATING AN ORACLE DATABASE
     • CREATE A NEW DATABASE
     • CONFIGURE AN EXISTING DATABASE
     • DROP A DATABASE
     • MANAGE DBCA TEMPLATES
     • MANUALLY CREATE A DATABASE
  • MANAGING THE DATABASE INSTANCE
     • CONFIGURING A LINUX ENVIRONMENT
     • STARTING & STOPPING DATABASE CONTROL
     • STARTING & STOPPING THE DATABASE LISTENER
     • STARTING & STOPPING THE DATABASE INSTANCE
     • MORE ABOUT THE DATABASE FILES  
  • MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
     • ABOUT TABLESPACES
     • TABLESPACE MANAGEMENT
     • DROP TABLESPACE
     • ALTER TABLESPACE
  • MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
     • MORE ABOUT TEMPORARY TABLESPACES
     • ABOUT TEMPORARY TABLESPACE GROUPS
     • MORE ABOUT PERMANENT TABLESPACES
     • MORE ABOUT BIGFILE TABLESPACES
     • MORE ABOUT THE SYSAUX TABLESPACE
  • MANAGE DATABASE STORAGE STRUCTURES
     • DATA FILES & TEMP FILES
     • MANAGING DATA FILES
     • MANAGING TEMP FILES
     • ENABLE ORACLE-MANAGED FILES (OMF)
  • MANAGING UNDO DATA
     • ABOUT UNDO SPACE MANAGEMENT
     • CONFIGURE AUTOMATIC UNDO MANAGEMENT
     • UNDO_MANAGEMENT
     • UNDO_TABLESPACE
     • UNDO_RETENTION
     • GUARANTEE UNDO RETENTION
     • MONITOR UNDO SPACE
     • USE THE UNDO ADVISOR
  • NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
     • SHARED SERVERS ARCHITECTURE
     • CONFIGURE SHARED SERVERS
     • MONITOR SHARED SERVERS
     • V$SHARED_SERVER
     • V$SHARED_SERVER_MONITOR
     • V$SESSION
     • V$CIRCUIT
     • V$DISPATCHER & V$DISPATCHER_CONFIG
     • V$QUEUE
  • SECURITY: IMPLEMENTING DATABASE SECURITY
     • DATABASE SYSTEM PRIVILEGES
     • DATABASE OBJECT PRIVILEGES
     • ADMINISTRATOR AUDITING OF DATABASE ACTIVITY
     • ENHANCED DEFAULT SECURITY SETTINGS
  • SECURITY: ADMINISTERING USER SECURITY
     • CREATE & MANAGE DATABASE ACCOUNTS
     • GRANT & REVOKE DATABASE PRIVILEGES
     • RESOURCE LIMITS VIA PROFILES
     • ALTER PROFILE
     • DROP PROFILE
     • PASSWORD MANAGEMENT VIA PROFILES
     • ABOUT ROLE-BASED SECURITY
     • WITH ADMIN OPTION
     • ALTER USER…DEFAULT ROLE
     • SET ROLE
     • ENHANCED DEFAULT SECURITY SETTINGS
  • MOVING DATA: SQL LOADER
     • LOADER CONCEPTS
     • CONTROL FILE OPTIONS
     • LOAD METHODS
     • USING THE EM INTERFACE
  • MOVING DATA: EXPORT & IMPORT
     • MANAGE DIRECTORY OBJECTS
     • ABOUT THE DATA PUMP ARCHITECTURE
     • DATA PUMP EXPORT
     • DATA PUMP IMPORT
     • DATA PUMP DATA DICTIONARY VIEWS
     • USING THE EM INTERFACE
  • DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT
     • THE MANAGEMENT & ADVISORY FRAMEWORK
     • MANAGE THE AUTOMATIC WORKLOAD REPOSITORY
     • AUTOMATIC DATABASE DIAGNOSTIC MONITOR
     • USE METRICS & ALERT THRESHOLDS
     • AUTOMATIC MAINTENANCE TASKS
  • MANAGING CONCURRENCY & LOCKS
     • ABOUT LATCHES & LOCKS
     • MANAGE & MONITOR LATCHES
     • MANAGE & MONITOR LOCKS
     • V$LOCK
     • V$LOCKED_OBJECT
     • V$SESSION
     • V$SESSION_WAIT
     • DBA_BLOCKERS & DBA_WAITERS
     • DBA_DML_LOCKS & DBA_DDL_LOCKS
     • DML_LOCKS
  • BACKUP & RECOVERY CONCEPTS & CONFIGURATION
     • ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
     • MANAGING REDO DATA
     • MANAGING ARCHIVAL DATA
     • AUTOMATIC CRASH RECOVERY
     • CREATING A BASIC BACKUP STRATEGY

 

Credit Hours: 120 Hours for Foundation Level l 140 Hours for Intermediate Level l 160 Hours for Management Level.

Eligibility: Graduation l Masters in Computer |Science

Training Methods: Online l Instructor Led Training

Certification: Oracle Certification l Sapience Consulting (Pvt) Ltd.

Work Experience: One Year for Intermediate Level l 3 Years for Management Level. Fresh for Foundation Level.

Level of Training: Foundation l Intermediate l Management

Research: Decided and given by Company:

Case Studies: Decided and given by Company:

Industries: our training curriculum has designed in such a way which covers following Industries type, which is easier for students to understand workflow structure of all departments and get good practical work experience.

 

Manufacturing (Textile l Food l Beverage l Non-Food l Vehicles l Chemicals l Pharma) l Trading l Financial l Sales l Warehouse l Transportation l IT l Services l Banking.

Job level: Entry l Mid l Management Level.

Professional Skills: Communication l MS-Office l SAP l Oracle l Dynamics l Advance Excel l Presentation Skills l Good Confidence Level.

Standards: IAS l GAAP l GAAS I FAM I INTOSAI

Trainers/Instructors: Senior Oracle SCM Consultants (Siemens) l Senior Officials from Multinational Companies, who deliver outstanding Professional Training according to their massive level of International Knowledge which leads students to highest level of success.

Examiner: Senior Oracle Consultants l Official of Multinational Companies.