Database Administration MS SQL Server

ADM520 3 days

Classroom

Database Administration MS SQL Server

Delivery:
Classroom
Country:
Display Language:
Portuguese
Rating:
Insufficient data for accurate rating at this time.
EHP1 FOR NW 7.0

Goals

  • Increasing your knowledge of database administration by using CCMS database tools including DBA Cockpit in SAP systems and in Mircorsoft SQL Server tools
  • Developing suitable backup strategies
  • Detecting and solving performance bottlenecks

Audience

  • SAP system administrators
  • Database administrators
  • Project team members
  • Technology consultants

Prerequisites

Essential

  • SAPTEC Fundamentals of SAP Web AS
  • Fundamentals knowledge of the Microsoft SQL Server database system
  • and of Windows 2000/2003 operating system

Recommended

  • SAP system admin. should attend ADM100 SAP Web AS Administration I

Course based on software release

  • SAP NetWeaver 7.0 with DBA Cockpit

Content

  • SAP system architecture and MS SQL Server architecture
  • Fundamentals of Performance monitoring and SQL statement analysis
  • Backup concepts
  • Database restore
  • Database monitoring
  • Working with SQL Server monitors
  • Working with CCMS monitors
  • System maintenance and troubleshooting

Notes

  • The course materials are in English. However, the course is held in the language of the country where it takes place.
  • The course ADM520 (MS SQL Server Database Administration) is held using a Microsoft SQL Server 2005 system.

Popular tags

No tags submitted for this course yet

Share this course: Print