Oracle Database Training

/Oracle Database Training
Oracle Database Training2016-12-15T13:47:49+00:00

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