system and database administration: adaptive server enterprise

ahana systems & solutions (p) ltd.
hanumanth nagar, karnataka, india

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

Course Description:

'' 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: hanumanth nagar
Houses & Roommates: hanumanth nagar

Search other schools for system and database administration: adaptive server enterprise training resources.

Oracle 11i Application DBA
performaernce and tuning: configuring adaptive server enterprise
Fast Track to Replication Server Administration
MySQL for DBA’,s
SQL Server 2005
sql server 2005 - performance tuning and optimisation

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.