Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Sybase ASE Training" is no longer available

No Reviews Yet

Srinivasa Nagar, Bangalore

Course ID: 17819

Srinivasa Nagar, Bangalore

No Reviews Yet

About the Course

Sybase ASE DBA Training

Topics Covered

System and Database Administration:
Adaptive Server Enterprise

Module 1:Introducing Adaptive Server
Adaptive Server Enterprise 15.0
Adaptive Server Databases
System Administrator Responsibilities

Module 2:Installing Servers
Loading the ASE Software
Installing Adaptive Server
ASE Directory Structurea
Starting and Stopping Servers

Module 3:Establishing Connectivity
The interfaces File
The UNIX interfaces File
The Windows sql.ini File
Maintaining the interfaces File
Introduction to LDAP Directory Services

Module 4:Configuring Server Behavior
The Configuration File
Viewing Configuration Values
Modifying Configuration Values
Multiple Configuration Files

Module 5:Configuring Memory
Components of Memory
Allocation of Memory
Major Uses of Memory
Estimating Initial Configuration Values

Module 6:Initializing and Using Devices
Creating and Dropping Devices
Default Devices
Mirroring Devices

Module 7: Creating and Using Databases
Sizing and Creating Databases
Setting Ownership and Options
Expanding Databases

Module 8:Suggested Disk Resource Strategies
Resource Allocation for System Databases
Resource Allocation for User Databases
Monitoring Space Usage

Module 9: Managing tempdb
Review of System tempdb
Installing Multiple tempdbs
Binding to a tempdb
Managing tempdbs - Precedence
Troubleshooting and Recommendations

Module 10: Administering System Roles and Logins
Overview of Access
System Roles
Logins
Proxy Authorization

Module 11: Managing Database Access and Users
Database Owners
Database Users
Object Creation Permissions

Module 12: Implementing Object Permissions, Groups, and Roles
Object Permissions
Groups
Overview of User-defined Roles
Implementing User-defined Roles

Module 13: Using Bulk Copy Utility
Copying Definitions
Bulk Copy Overview
Bulk Copy Syntax

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


Module 15: Planning for Backups
Backup Basics
Backup Server
Truncating the Transaction Log
Developing a Backup Plan


Module 16: Performing a Backup
Making Backup Servers Known to Adaptive Server
Dumping Databases
Loading Databases
Dumping Transaction Logs
Loading Transaction Logs

Module 17: Practicing Advanced Backup Techniques
Thresholds
Transaction Log Recovery
Database Recovery
Rebuilding the master Database


Module 18: Monitoring the System
Monitoring Errors
Monitoring Processes
Monitoring Licenses
Monitoring System Performance

















Who should attend

Any one Interested in Sybase

Pre-requisites

Basic Linu

What you need to bring

We will provide the required stuff

Key Takeaways

Sybase ASE DBA Certificate

Date and Time

Not decided yet.

About the Trainer

Avg Rating

Reviews

Students

Courses

C. K. Chidananda Murthy brings with him a rich experience of 14 years in the training field.
Associated with AHANA SYSTEMS AND SOLUTIONS since 2008 as a Technical Trainer.

Reviews

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for IT Courses Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more