Signup as a Tutor

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

Sybase ASE Training

No Reviews Yet

Srinivasa Nagar, Bangalore

Course ID: 17819

Srinivasa Nagar, Bangalore

Students Interested 1 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

About Chidanada Murthy

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.
No reviews currently Be the First to Review

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

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 1 (Seats Left 0)

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

Enquire

Submit your enquiry for Sybase ASE Training

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Ahana Systems & Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer