ORACLE DATABASE TRAINING
TSQL
- What is TSQL
- Data types
- Table structure and normalization
- Query analyzer
- Enterprise manager
- Cursors
- Views
- Stored procedures
- Triggers
- Functions
- Query optimization
INSTALLATION
- System requirements
- Choosing edition
- Placing scalability
- Installing instances
- User accounts and access
BACKUPS/RESTORE
- Planning backups
- Configuring backups
- Automating backups and restore
REPLICATION
- Planning replication scenarios
- Configuring publisher
- Configuring distributor
- Configuring subscriber
ADMINISTRATION
- Clustering
- Scalability
- Performance monitoring
- Health checks
BUSINESS INTELLIGENCE
- Analysis services
- Building cubes using OLAP
- Data marts/Roll up tables
- Generating reports in reporting services (SSRS)
- Designing, building and executing packages in SSIS
- Difference in DTS and SSIS
- Data migration using SSIS
Unit 1: Introduction to Oracle applications security
Unit 2: Managing Oracle applications security
Unit 3: Oracle user management
Unit 4: Auditing system resources
Unit 5: Managing concurrent programs and reports administration
Unit 6: Administering concurrent managers
Unit 7: Managing profile options
Unit 8: Introduction to printer management
Unit 9: Form personalization
Unit 10: Personalizing OA framework pages
Unit 11: Oracle workflow
Unit 12: Setting up Oracle workflow
Unit 13: Oracle Applications Manager (OAM)
Unit 14: Application DBA administration duties
Unit 15: Folders
Unit 16: Custom programs
Unit 17: Help files
Unit 18: Document sequences