- Sybase Introduction: Overview
- Sybase Architecture & Versions12.5 & 15.x,
- System and optional Databases,
- Sybase: Basic Concepts
- Database Objects
- Sybase server - Storage Units
- Security and User Administration
- Transact-SQL.
- Views
- Triggers
- Stored Procedures
- Defaults and Rules
- Cursors
- Transactions
- Performance Tuning (Indexes)
- Locking Scheme.
- Different clients for ASE,
- Directory Structure,
- Config file and configuration parameters,
- Run server file,
- Connectivity,
- Basic Memory Architecture.
- Database Devices,
- dsync, direction, disk resource issues, initialization of devices
- Creation of databases,
- setting ownership,
- segments,
- Database options.
- Space management in system tables.
- User Management,
- alias,
- login creation and user creations object permissions,
- Database refreshes, and roles.
- System tables for the user mgmt. Issues with login and users.
- Backup policy,
- different backup technique,
- compression and stripe backup,
- Full database and Tran backup including all options.
- Load of databases with full backup and tran backups, possible issues.
- Automatic recovery,
- startup and shutdown of Sybase ASE,
- bulk copy,
- Database consistency checks (DBCC).
- Possible issue during startup,
- Checkpoint, house keeper task.
- Dbcc installation,
- Dbcc check storage and tasks verification,
- auditing installation,
- Monitoring and maintenance tasks.
- Installation (in Windows and Unix) and upgrade (full version upgrade and ESD)
|
No comments:
Post a Comment