Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose
sap-training-courses

SAP NetWeaver AS - DB Operation (Oracle)

Course Details
Code: TADM51-v015
Tuition (USD): $3,350.00 • Classroom (5 days)
Course Details
GSA (USD): $3,037.78 • Classroom (5 days)

Skills Gained

  • This course will prepare you to:
       -Use your knowledge of database administration with reference to CCMS database tools in SAP systems and BR tools
       -Put effective data backup strategies into practice
       -Put to practical use SAP knowledge gained from previous courses and from this course in the role of junior consultant in a practical context

Who Can Benefit

  • Database Administrator
  • System Administrator
  • Technology Consultant

Prerequisites

  • Essential:
       -TADM10
       -TADM12
       -Sound knowledge of administering the Oracle database
  • Recommended:
       -none

Course Details

Course Content

  • Database Overview
       -Reviewing Database Architecture
       -Connecting to the Database
       -Using Database Administration Tools
       -Administrating Oracle Instances
  • Backup, Restore and Recovery
       -Reviewing a Backup Strategy
       -Reviewing Backup Tools
       -Performing Backups
       -Performing Restore and Recovery
       -Working with Advanced Backup Techniques
  • Monitors and Tools
       -Introducing Oracle Data Management
       -Managing Database System Check
       -Explaining CCMS Alert Monitor
  • Space Management
       -Administrating "Table Spaces"
       -Performing Reorganization of Tables
       -Housekeeping and Troubleshooting
  • Oracle Cache Management
       -Introducing Oracle System Global Area
       -Introducing Automatic Oracle Program Global Area (PGA)
  • Monitoring of the Database Instance
       - Using the DBA Cockpit to Monitor the Database
       -Understanding the DBA Cockpit support of Oracle database features
  • Application Design Analysis
       -Understanding the Impact of Expensive SQL Statements
       -Using SM50/SM66 to Find Expensive SQL Statements
       -Using ST03/STAD to Find Expensive SQL Statements
       -Using ST04 to Find Expensive SQL Statements
       -Using SQL Trace to Find Expensive SQL Statements
       -Monitoring Exclusive Lock Waits
  • Index Management and Optimization
       -Utilizing Indexes
       -Creating an Index
  • Cost-Based Optimizer
       -Updating Statistics
       -Detecting problems with Optimizer statistics
  • Analysis of Physical and Logical Layout
       -Defragmenting Indexes
       -Working with I/O Contention
  • Memory Configuration Analysis
       -Describing Data Buffer Utilization
       -Analyzing Efficiency of Shared Pool
       -Monitoring the Automatic Program Global Area (PGA)

Notes

  • To ensure that you retain the knowledge gained in this course and successfully complete the certification examination, we recommend that you consolidate the content in your own time after the course.

Course based on software release

  • SAP NetWeaver AS ABAP 7.40
  • Oracle 12c
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward