|
Provided by: Ahana Systems and Solutions (P) Ltd Sybase DBA Training Online |
 |
Training
Provided by Ahana Systems and Solutions (P) Ltd
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.
|
|
||||||||||
Sybase DBA Training Online
Sybase Database Administration
System and Database Administration: Adaptive Server Enterprise
Course Topics:
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
Module 20: Sybase Central
Sybase Central Defined
Using Sybase Central
Administration Tasks
Job Scheduler
Interactive SQL
Module 21: Monitoring the System
Monitoring Errors
Monitoring Processes
Monitoring Licenses
Monitoring System Performance
System and Database Administration: Adaptive Server Enterprise
Course Topics:
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
Module 20: Sybase Central
Sybase Central Defined
Using Sybase Central
Administration Tasks
Job Scheduler
Interactive SQL
Module 21: Monitoring the System
Monitoring Errors
Monitoring Processes
Monitoring Licenses
Monitoring System Performance
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
VMWare
Windows Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of...
