5 Days course
Language: English
This course is only available on request!!
| Sybase Database Administration
5 Days course Language: English This course is only available on request!! |
|
|
DESCRIPTION |
WHAT YOU WILL LEARN |
|
WHO SHOULD ATTEND: |
ASSUMED KNOWLEDGE |
OUTLINES
CHAPTER 1: INTRODUCTION
1) Open Architecture
2) System Tables
3) Stored Procedures
CHAPTER 2: SERVER DEFINITION
1) Server Installation Steps
2) SQL access server
3) Starting the Server
4) Verifying the Server is running
5) Shutting down the server
CHAPTER 3: RESOURCE DEFINITION
1) Disk Initialization
2) Default Disks
3) Disk Mirroring
4) Software vs Hardware vs RAID
CHAPTER 4: DATABASES
1) Database Creation
2) Assigning database size and authority
3) Adding space for the log
4) Database System Tables and Options
5) Database space utilization
6) The Model database
7) Object Placement - segments and devices
8) Segment System Tables
CHAPTER 5: SECURITY
1) Special Users: sa, dbo, object, owner
2) The OS, server, and database security
3) Built in System functions
4) Command security - object permissions
5) Ownership chains
6) Role definitin and functions
CHAPTER 6: BACKUP and RESTORE
1) Backup Server, remote backup server, dump devices
2) Dump Database, load database, automatic backups
3) Dump transaction, load transaction
4) Monitoring the log, treshholds, free-space
5) Hysteresis in data threshold management
CHAPTER 7: PERIODIC MAINTENANCE
1) Server Maintainance
2) Activity monitoring
3) System errorlog
4) Resource verification
5) Software Maintenance
6) Database Maintenance - dbcc
7) Checktable, Checkalloc, memusagae
8) Database dumps, disaster recovery
9) Log management
10) Space management
11) Script maintenance
12) Verifying Loads
13) Table Maintenance
14) Update Statistics
CHAPTER 8: UTILITIES
1) Script Maintenance
2) defncopy
3) Bulk copy
CHAPTER 9: CONFIGURATION and TUNING
1) Memory Utilization
2) Configuration variables
3) Options
4) Procedure Cache
5) Performance Monitoring
CHAPTER 10: REMOTE SERVER MANAGEMENT
1) Remote Access
2) sp_addserver
3) remote logins
CHAPTER 11: BASICE APPLICATION PERFORMANCE AND TUNING
1) Sybase Optimizer
2) Querry Optimization
3) Limitations
4) Optimizer Tips
![[HOME]](../home.gif){kind=small}
![[dates]](../sched.gif){kind=small}
![[reserve]](../reserve.gif){kind=small}
![[seminars]](../seminars.gif){kind=small}
This course will provide the participant with the knowledge of the
fundamental concepts to perform system administration for a Sybase database.
Participants will also learn preventive maintenance and how to effectively
perform routine system administration tasks.
Install, Configure and Maintain a
Sybase SQL/Server database
This course is designed for those whose responsibilties will include the
maintances of a Sybase SQL/Server database. Anybody tasked with those
responsibilites should attend this course.
Students should have working knowledge of the SQL server and should have
previously attended an introductory Sybase course.