+91 95057 44455 | +1 214 447 7927

SAP ASE (Adaptive Server Enterprise) or Sybase Training

A complete practice oriented hands-on training on

SAP ASE (Adaptive Server Enterprise) / Sybase

Learn high performance RDBMS for mission-critical projects!

Adaptive Server Enterprise (ASE) is a versatile, enterprise-class high performance relational database management system (RDBMS) most suitable for mission-critical, data-intensive environments. It ensures highest operational efficiency and throughput on a broad range of platforms. ASE is used intensively in the financial world (banks, stock exchanges, insurance companies), in E-commerce, as well as in virtually every other area.

Course is designed to cover all SAP Adaptive Server Administration / DBA activities and extensive training will be provided. Training is practical oriented with good amount of hands on.

 Complete hands-on effective training with individual focus
 Flexible schedules – weekend or weekday; classroom or online or corporate
 On Demand one-one and batch training at mutually convenient schedules
 Practices and Exercises during the workshop
 Interactive approach to understand concepts thoroughly
 Speak to our coach before workshop
 Continued support over mail and lot more…
 Customized topics training for corporate…

Audience Profile:

Project team members, leads, technical managers, supervisors, architects, technologists and anyone who is interested in learning SAP ASE or Sybase DBA.

Prerequisites:

Basic knowledge on unix and SQL required before attend this course.

Course Curriculum

Course outline for complete full length course. Outline varies for customized courses or less duration foundation courses.

 Adaptive Server Enterprise
Adaptive Server Databases
System Administrator Responsibilities

 Loading the ASE Software
Installing Adaptive Server
ASE Directory Structure
Starting and Stopping Servers

 The UNIX interfaces File
The Windows sql.ini File
Maintaining the interfaces File
Introduction to LDAP Directory Services

 The Configuration File
Viewing Configuration Values
Modifying Configuration Values
Multiple Configuration Files

 Components of Memory
Allocation of Memory
Major Uses of Memory
Estimating Initial Configuration Values

 Creating and Dropping Devices
Default Devices
Mirroring Devices

 Sizing and Creating Databases
Setting Ownership and Options
Expanding Databases

 Resource Allocation for System Databases
Resource Allocation for User Databases
Monitoring Space Usage

 Overview of Auto Database Expansion
Installing Auto Expansion
Managing Auto Expansion using sp_dbextend

 Review of System tempdb
Installing Multiple tempdbs
Binding to a tempdb
Managing tempdbs – Precedence
Troubleshooting and Recommendations

 Overview of Access
System Roles
Logins
Proxy Authorization

 Database Owners
Database Users
Object Creation Permissions

 Object Permissions
Groups
Overview of User-defined Roles
Implementing User-defined Roles

 Copying Definitions
Bulk Copy Overview
Bulk Copy Syntax

 Overview of Automatic Recovery
Recording Modifications
Recovering Modifications After a Shutdown
Checkpoints
Recovery Order

 Overview of the dbcc Commands
Checking Page Linkage
Checking Page Allocation
Setting Up the dbccdb Database
Using dbcc checkstorage

 Backup Basics
Backup Server
Truncating the Transaction Log
Developing a Backup Plan

 Making Backup Servers Known to Adaptive Server
Dumping Databases
Loading Databases
Dumping Transaction Logs
Loading Transaction Logs

 Thresholds
Transaction Log Recovery
Database Recovery
Rebuilding the master Database

 Sybase Central Defined
Using Sybase Central
Administration Tasks
Job Scheduler
Interactive SQL

 Monitoring Errors
Monitoring Processes
Monitoring Licenses
Monitoring System Performance

 Scheduling
Monitoring

Interested?







24x7Coach.com, an education brand of Mahtia Business Solutions Pvt. Ltd., offers Classroom, Online/Virtual and Corporate training on Project Management, Technology and Soft Skills

+91 95057 44455 / +1 214 447 7927

REP LOGO

24x7Coach.com © 2019. All rights reserved. 24x7Coach is an education brand of Mahtia Business Solutions Pvt. Ltd.

24x7Coach (Mahtia Business Solutions Pvt. Ltd.) is PMI® Registered Education Provider (R.E.P. Id 4619).

24x7Coach.com is an Authorized Training Partner of VMEdu, Inc.

PMI, the PMI Registered Education Provider logo, PMP, PgMP, CAPM, PMI-SP, PMI-RMP, PMI-ACP, PMI-PBA, and PMBOK are marks of the Project Management Institute, Inc..

Microsoft is a Registered Trade Mark of Microsoft Corporation in the United States and/or other countries.

SMC™ is a Registered Trade Mark of ScrumStudy.com / VMEdu, Inc.

PSM, and Professional Scrum Master are trademarks of scrum.org. Content on our site is not affiliated with nor endorsed by Scrum.org.

Images courtesy – pixabay.com.

Contact us to report any IP violation or plagiarism in our website. We will act promptly and accordingly.

top
24x7Coach.com © 2019.
X