Sybase DBA Online/Onsite Training.

No Reviews Yet

Hanumantha Nagar, Bangalore

Course ID: 3534

Hanumantha Nagar, Bangalore

Students Interested 3 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

About Chidananda Murthy

Good Experience
No reviews currently Be the First to Review

About the Course

The Course Objectives:

Our Sybase database training develops and delivers excellent learning solutions to support your personal and organizational learning goals. We developed our courses to provide real solutions for the challenges you face every day, these task-based courses get to the heart of Sybase technology and provide you with the technical know-how that you can apply to achieve effective results, the ability to address specific real-world issues that pertain to your company's unique environment. When it comes to delivering Sybase database administration and technology training, there is no one better equipped than real-world production Sybase DBA's. Our access to production DBA, technical support and database architects ensures that our programs incorporate the most recent tips, tools and best practices to bring you up to speed and help you get the most out of your Sybase training.

Topics Covered

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 Structure
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: Auto Expansion
Overview of Auto Database Expansion
Installing Auto Expansion
Managing Auto Expansion using sp_dbextend
Module 10: Managing tempdb
Review of System tempdb
Installing Multiple tempdbs
Binding to a tempdb
Managing tempdbs - Precedence
Troubleshooting and Recommendations
Module 11: Administering System Roles and Logins
Overview of Access
System Roles
Logins
Proxy Authorization
Module 12: Managing Database Access and Users
Database Owners
Database Users
Object Creation Permissions
Module 13: Implementing Object Permissions,
Groups, and Roles
Object Permissions
Groups
Overview of User-defined Roles
Implementing User-defined Roles
Module 14: Using Bulk Copy Utility
Copying Definitions
Bulk Copy Overview
Bulk Copy Syntax
Module 15: Overview of Automatic Recovery
Overview of Automatic Recovery
Recording Modifications
Recovering Modifications After a Shutdown
Checkpoints
Recovery Order
Module 16: Checking and Fixing Database
Consistency
Overview of the dbcc Commands
Checking Page Linkage
Checking Page Allocation
Setting Up the dbccdb Database
Using dbcc checkstorage
Module 17: Planning for Backups
Backup Basics
Backup Server
Truncating the Transaction Log
Developing a Backup Plan
Module 18: Performing a Backup
Making Backup Servers Known to Adaptive Server
Dumping Databases
Loading Databases
Dumping Transaction Logs
Loading Transaction Logs
Module 19: Practicing Advanced Backup Techniques
Thresholds
Transaction Log Recovery
Database Recovery
Rebuilding the master Database

Who should attend

Freshers Or Working Professionals

Pre-requisites

Basic knowledge on Linux.

What you need to bring

We provide training materials.

Key Takeaways

Syabse Certified DBA.

Reviews

No reviews currently Be the First to Review

Students Interested 3 (Seats Left 0)

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

Enquire

Submit your enquiry for Sybase DBA Online/Onsite 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 S.

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 the OTP sent to your registered mobile number.

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

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