Sybase ASE 16 DBA Course

21 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 24 hours
In this Unit you will know about the basics of DBMS and RDBMS.
DBA B. Schema Normalization 24 hours
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

4.5

4.5
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • 30,000.00 29,500.00
  • 2160 Hours
  • Course Badge

Recent Posts

Featured Testimonial

I would like to mention a new feature "Interactive Video". You can't simply watch the video. You have to actually get involved. It will pause suddenly and ask question. If you are not able to answer the question you have to watch it all over again. Hence a real learning is guaranteed.Read more

Indiana Jones

Co-Founder Director

Certificate Code

Become an Instructor

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