SAP NetWeaver AS - DB Operation (Oracle)

  • Tuition USD $3,350 GSA  $3,037.78
  • Reviews star_rate star_rate star_rate star_rate star_half 1076 Ratings
  • Course Code TADM51-v015
  • Duration 5 days
  • Available Formats Classroom

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great Class that will help as the state moves forward with the Cloud solution.

Thank you for training on AWS development. Course was good and encouraging but labs need to be improved and provide more information and ask students to more work than provide solutions.

The course was very thorough and the instructor ensured that all the students were on the same page.

AZ-300 course experience was good . Eylem Uysal was very good, the best instructor and i had really good experience attending course and classes with Eylem.

I had a good experience with ExitCertified. I got a deeper understanding of AWS and should be able to put it to practice immediately.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward