system and database administration

system and database administration: adaptive server enterprise

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

course description :
it covers a discussion of the underlying nature of relational databases and sql
fundamental concepts like locking and query optimization that will impact your applications, set-
oriented and sequential processing of data, methods of manipulating data and formatting output,
best programming practices
course objectives :
upon completion of this course, you will be able to:
write queries that will use the query optimizer to access indexes
understand the many different types of joins and subqueries
use the case expression to write more powerful queries
understand how locking works in adaptive server
use h?s effectively
manipulate numeric and temporal data to solve everyday problems
course topics:
module
1: sql and transact-sql
module
2: understanding sql basics
module
3: indexes and search arguments
module
4: joins and subqueries
module
5: using case logic
module
6: transactions and locking
module
7: writing effective transactions
module
8: using h?s
module
9: manipulating data
module
10: formatting output data
module
11: writing effective transact-sql
module
12: writing effective stored procedures
module
13: assigning key values
module
14: creating hierarchies with sql

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

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

Pages:- 1 2
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>