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.