sybase database administration

ahana systems and solutions pvt ltd
bangalore, india

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: umashankar

Course Description:

'' 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 a?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
...''

Elements of this syllabus are subject to change.

Phone:080-26675891

School Address/Venue(s):

ahana systems & solutions (p) ltd.

105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore ï¿?560050

Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

Search other schools for sybase database administration training resources.

oracle database administration
oracle 10g database administration
oracle 10g rac
fast track to adaptive server enterprise
sybase t-sql
sybase configuring adaptive server
mysql database administration
Perl Script
Shell Script
ClearCase Administration
Linux System Administration (Based on RedHat)
VMWARE ESX Administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.