Description

• This certification path will validate your capability as a well-trained technologist prepared to help your client or partner manage SAP Sybase Adaptive Server Enterprise database. Armed with an understanding of database administration, you can implement this knowledge for your projects as a technology consultant

Topic Areas

Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

Backup > 12%

Plan and perform backups. Explain the advanced backup techniques.

• EDB358 (ASE 16)
• ED358r

Database Server Configuration > 12%

Configure Server behaviour and memory

• EDB358 (ASE 16)
• ED358r

Tuning 8% – 12%

Explain how make parallel tunning. Describe tuning with the Logical Process Manager.

• EDB553 (ASE )

Transactions 8% – 12%

Manipulate data using Transact-SQL functions. Use Transactions to maintain data consistency. Explain how to isolate Data with Locks.

• EDB116 (ASE 16)
• ED116r

Architecture and Installation 8% – 12%

Introduce ASE and explainhow servers are installed.

• EDB358 (ASE 16)
• ED358r

Maintenance 8% – 12%

Use extraction utilities. Explain the automatic recovery. Check and fix database consistency.

• EDB358 (ASE 16)
• ED358r

Security 8% – 12%

Administer system roles and loings.  Manage database access and users. Implement Object Permissions, groups and roles.

• EDB358 (ASE 16)
• ED358r

Tables Management 8% – 12%

Create Tables, Temporary Tables. Explain how to query Multiple Tables and System Tables. Modify Data in Tables.

• EDB116 (ASE 16)
• ED116r

Database Administration 8% – 12%

Initialize and use devices. Create and manage databases and suggest different disk ressource strategies. 

• EDB358 (ASE 16)
• ED358r

Data Analysis < 8%

Analyze data using Aggregate functions.

• EDB116 (ASE 16)
• ED116r