Requested resource is not accessible

Sybase ASE 16 DBA Course

23 STUDENTS ENROLLED

Course Outlines

  • Introducing Adaptive Server
  • Installing Servers
  • Establishing Connectivity
  • Configuring Server Behavior
  • Configuring Memory
  • Initializing and Using Devices
  • Creating and Using Databases
  • Suggested Disk Resource Strategies
  • Auto Expansion
  • Managing tempdb
  • Administering System Roles and Logins
  • Managing Database Access and Users
  • Implementing Object Permissions, Groups and Roles
  • Using Bulk Copy Utility
  • Overview of Automatic Recovery
  • Checking and Fixing Database Consistency
  • Planning for Backups
  • Performing a Backup
  • Practicing Advanced Backup Techniques
  • Sybase Control Center
  • Monitoring the System
  • Introduction to Replication

Course Curriculum

Introduction and Getting Started
DBA A. Introduction to DBMS and RDBMS 02:00:00
In this Unit you will know about the basics of DBMS and RDBMS.
DBA B. Schema Normalization 02:00:00
Schema Normalization-The session is a walk through for the normalization of a sample database. You will learn how to apply 1NF, 2NF and 3NF to your own database.
SAP 1. Adaptive Server Database 00:20:00
This unit will make you familiar with sybase database.
SAP 2. Installing Server 00:20:00
This unit will make you familiar with Installing Server.
SAP Lab 1 Installation of Sybase 10, 00:00
SAP 3. Communication and Connectivity Tools in Sybase 00:20:00
This unit will make you familiar about Communication, Connectivity Tools, Utilities & System Administrator Responsibilities.
SAP Lab 2 Move and modify configuration files 10, 00:00
SAP 4. Configuration Parameters in Sybase 00:20:00
This unit will make you familiar about Configuration Parameters in Sybase.
SAP Lab 3 Backup Server 10, 00:00
SAP 5. Configuring Memory Parameters in Sybase 00:20:00
This unit will make you familiar Memory configuration in Sybase.
Devices and Database Management
SAP 6. Initializing and Using Devices 00:20:00
This unit will make you familiar about Initializing and Using Devices
SAP 7. Creating and Using Databases 00:16:00
This unit will make you familiar with Creating and Using Databases.
SAP Lab 4 Create Databases in Sybase 10, 00:00
SAP Lab 5 Creating and expanding Databases-Advanced 10, 00:00
SAP 8. Suggested Disk Resource Strategies 00:00:00
SAP 9. Database Auto Expansion 00:15:00
Learning about Auto Expansion
SAP Lab 6 Disk Mirroring 10, 00:00
SAP Lab 7 Auto Expand Database 10, 00:00
SAP 10. Working with Temporary Databases 00:15:00
Learn about Managing tempdb
SAP Lab 8 Creating and Using Temporary Databases 7, 00:00
Users, Groups, Roles and Permissions
SAP 11. Administering System Roles and Logins 00:20:00
Learn about Administering System Roles and Logins.
SAP Lab 9 Creating and Using Roles 10, 00:00
SAP 12. Managing Database Access and Users 00:20:00
This unit will make you familiar with Managing Database Access and Users in SAP.
SAP 13. Implementing Object Permissions, Groups and Roles 00:15:00
This unit will make you familiar with Implementing Object Permissions, Groups and Roles.
Recovery
SAP 14. Using BCP Utility 00:00:00
SAP Lab 10 Working with bcp Utility 10, 00:00
SAP 15. Automatic Recovery in Sybase-ASE 00:15:00
Learn about recovery in sybase-ase.
SAP Lab 11 Automatic Recovery Options 7, 00:00
Checking and Fixing Database Consistency
SAP 16. Checking and Fixing Database Consistency 00:15:00
Learn about Checking and Fixing Database Consistency.
SAP Lab 12 Working with dbcc 7, 00:00
Backup
SAP 17. Planning for Backups 00:00:00
SAP 18. Performing Backup in Sybase ASE 00:20:00
Learn about Performing Backup in Sybase ASE.
SAP Lab 13 Performing Backup and Recovery 7, 00:00
SAP 19. Advanced Backup Techniques 00:20:00
Learn about Advanced Backup Techniques.
SAP 20. SAP ASE Cockpit 00:20:00
Learn about Sybase Control Center.
SAP 21. Monitoring the System 00:15:00
Learn about Monitoring the System.
SAP Lab 14 System Monitoring with sp_sysmon 7, 00:00
SAP Replication Server
SAP 22. Introduction to SAP Replication Server 00:20:00
Learn about Introduction to SAP Replication Server.

Course Reviews

5

5
1 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Excellent Course for DBA

    5

    I found the course to be excellent in terms of every aspect. The lab assignments are quite comprehensive and Lecture recordings give a real life classroom experience.

TAKE THIS COURSE

Recent Posts

Designed by  © Alliance Softech Pvt Ltd. All rights reserved.
WhatsApp chat
X