This course is on SAP Sybase ASE that covers the concepts related to database administration and classes will be taken online.
- Details of the product - SAP Sybase ASE
- Downloading product from SAP portal
- Way to check the details related to procurement for generating license for the product
- About client-server architecture, RAID, CPU scheduling, Memory(temporary,permanent)
- Architecture of the product
- Storage structure in the product
- Pre-requisites for setting up a lab for SAP Sybase ASE
- Installation and build
- Details about dataserver and backupserver
- Starting and stopping dataserver and backupserver
- About devices
- User database creation
- Optional database creation
- System tables and stored procedures
- User management
- Table creation and maintenance of them
- Dump/backup of database
- Load/refreshing database
- Error log(s) monitoring
- Configuration parameters
- Maintenance activities
- Monitoring perormance
- Ways to do tuning
After the training on the above concepts, you will be able to work on the tasks related to Sybase ASE database administration.
Separate classes will be taken if the candidate is in need of troubleshooting and advanced troubleshooting.