Courses
SAP
- SAP ABAP
- SAP BASIS
- SAP SECURITY
- SAP NETWEAVER
- SAP XI
- SAP FICO
- SAP FSCM
- SAP MM
- SAP WM
- SAP PP
- SAP SRM
- SAP BW
- SAP BI
- SAP BPC
- SAP MDM
- SAP SD
- SAP CRM
- SAP BO
- SAP HR
- SAP HR-ABAP
- SAP GRC
- SAP HCM
- SAP APO
- SAP EP ADMIN
- SAP IS UTILITIES
- SAP PLM
- SAP SCM
- SAP PC
- SAP QM
- SAP IS RETAIL
- SAP EP JAVA WEBDYNPRO
- SAP HANA
- SAP PS
- SAP PI
- SAP IS OIL & GAS
- SAP CS
Oracle
- ORACLE 10 g
- ORACLE APPS DBA
- ORACLE APPS FINANCIALS
- ORACLE APPS TECHNICAL
- ORACLE BPEL
- ORACLE OAF
- ORACLE APPS FINANCE FUNCTIONAL R12
- OBIEE
- ORACLE 11G
- ORACLE DBA
- PL-SQL
- ORACLE HRMS
- ORACLE ADF
Other Technologies
- MS.NET
- SHARE POINT
- JAVA
- SAS
- SAS BI
- SAS OC
- QA TESTING
- SQL SERVER
- TIBCO
- SIEBEL CRM
- SIEBEL ANALYTICS
- UNIX SHELL
- BIZTALK SERVER
- CCNA
- SAS FINANCIAL MANAGEMENT
- AJAX
- LINUX
- SALES FORCE
- CCNP
- MCSE
- VMWARE
- PEOPLESOFT HRMS TECHNICAL
- CRYSTAL-REPORTS
- PMP
- TERA DATA
- WEBSPHERE
- ANDROID
- HADOOP
Data Warehousing
- INFORMATICA
- COGNOS
- DATA STAGE
- BUSINESS OBJECTS
- BUSINESS ANALYST
- COGNOS TM1
- AB INITIO
- MICROSTRATEGY
- COGNOS PLANNING AND BUDGETING
- HYPERION ESSBASE
- HYPERION DATA RELATIONSHIP MANAGEMENT
- HYPERION FINANCIAL MANAGEMENT
- HYPERION INTERACTIVE REPORT
- HYPERION FINANCIAL DATA QUALITY MANAGEMENT
- HYPERION PLANNING
- HYPERION FINANCIAL REPORT
Oracle DBA - Course Content
Introduction
- Identify the oracle product
- Describe the basic concept of a relational database
Installing oracle database 10g software
- System requirements
- Use Oracle Optimal Flexible Architecture (OFA)
- Install software with the Oracle Universal Installer
Create an oracle database
- Oracle Database Architecture
- Oracle instance architecture
- Use the Database Creation Assistant
Controlling the database
- Manually configure the Oracle 10g EM dbconsole
- Start and stop the agent
- Start and stop the enterprise manager database console
- Start and stop the listener
- Startup and shutdown the database
Storage Structures
- Defining the tablespaces and data files
- Create tablespaces
- Manage tablespaces
- Obtain tablespace information
- Create and manage tablespace using oracle enterprises manager
Administering users
- Create and manage database user accounts
- Create and manage roles
- Grant and revoke privileges
Oracle Database Security --- Only Theory
- Apply the principal of least privilege
- Manage default user accounts
- Implement standard password security features
Oracle Net Services
- Understand Oracle Net concepts
- Use Oracle Net Manager to create and configure listeners
- Use the Oracle Net Manager to configure client and middle-tier connection
- Use TNSPING to test Oracle Net connectivity
Performance Monitoring
- Gather optimizer statistics
- View performance metrics
Monitoring and Managing Memory
- Oracle Memory Structures
- Automatic PGA Memory Management
- Using the Memory Advisor
- Using Automatic Shared Memory Management to avoid long running query issues
Monitoring and Resolving Lock Conflicts
- Detect and resolve lock conflicts
- Manage deadlocks
Diagnostic Sources
- The Alert Log
- Viewing Alerts with EM
- Alerts Notification ----- Only Theory
- Editing Thresholds ----- Only Theory
- Trace Files
Proactive Maintenance: Objectives --- Only Theory
- Set warning and critical alert thresholds
- Collect and use baseline metrics
- Use tuning and diagnostic advisors
- Use the Automatic Database Diagnostic Monitor (ADDM)
Automatic Storage Management ---- Only Theory
- ASM Concepts
- ASM General Architecture
- Creating an ASM instance
- Creating tablespaces that use ASM storage
- Viewing ASM information
- Migrating a tablespace to use ASM storage.
Undo Management --- Only Theory
- Monitor and administer undo
- Configure undo retention
- Guarantee undo retention
- Use the undo advisor
Backup and Recovery --- Only Theory
- Describe the basics of database backup, restore and recovery
- List the types of failure that may occur in an Oracle Database
- Describe ways to tune instance recovery
- Identify the importance of checkpoints, redo log files, and archived log file
Managing Data
- Manipulating data through SQL
- Using Import
- Using Export
Database backups
- Configure ARCHIVELOG mode
- Create consistent database backups
- Back your database up without shutting it down
- Create incremental backups
- Automate database backups
- Monitor the flash recovery area
Managing schema objects
- Create and modify tables
- Define constraints
- View the attributes of a table
- View the contents of a table
- Create indexes and views
Database Recovery
- Recover from loss of a control file
- Recover from loss of a redo log file
- Recover from loss of a data file