system and database administration

ahana systems and solutions (p) 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:+91 80 26675891

School Address/Venue(s):

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 system and database administration training resources.

sybase replication
SQL Server 2005: Integration Services
sql server 2005: reporting services
Perl
Shell Scripting
VMWARE ESX Administration
Linux System Administration (Based on RedHat)
sybase database administration
sybase - mastering advanced t-sql

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: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.