Homepage | Courses | Database  
Who we are…what do we do…how we do it  
and more...  
 
 



 
 

Courses

 

Database

Sybase - Adaptive Server Enterprise
 

Course Description
Sybase Database Trainingwill teach youhow to superintendent the ASE Database Servers. From this training you will learn how to install, implement, Troubleshoot and maintain the database servers. You will learn the most important topics like Backup Techniques, Automatic Recovery, System Roles and Logins, Database Access and Logins as well as Performance Tuning etc.

Goals
 You will be able to address the real time issues on production servers. Through this course we will accomplish your personal and organizational learning goals. We will make you understand the Sybase DBA job responsibilities include establishing business rules for the database, maintaining data and reporting protocols. You will become a master on Sybase Database from this training. You can effortlessly and successfully complete the certification examination.

Prerequisites

  1. Operating System Functions - Windows and Linux machine
  2. Functions of T-SQL Scripts and SQL (Structured Query Language) concepts
  3. Should be able to construct DML and DDL statements of SQL
  4. Basic Knowledge of Relational Databases concepts and Objects

Duration6 Weeks Course

Contents

  • Module 1: Introducing Adaptive ServerAdaptive Server Enterprise 15.0
  • Adaptive Server Databases
  • System Administrator Responsibilities

Module 2: Installing Servers

  • Loading the ASE Software
  • Installing Adaptive Server
  • ASE Directory Structure
  • Starting and Stopping Servers

Module 3: Establishing Connectivity

  • The interfaces File
  • The UNIX interfaces File
  • The Windows sql.ini File
  • Maintaining the interfaces File
  • Introduction to LDAP Directory Services

Module 4: Configuring Server Behavior

  • The Configuration File
  • Viewing Configuration Values
  • Modifying Configuration Values
  • Multiple Configuration Files

Module 5: Configuring Memory

  • Components of Memory
  • Allocation of Memory
  • Major Uses of Memory
  • Estimating Initial Configuration Values

Module 6: Initializing and Using Devices

  • Creating and Dropping Devices
  • Default Devices
  • Mirroring Devices

Module 7: Creating and Using Databases

  • Sizing and Creating Databases
  • Setting Ownership and Options
  • Expanding Databases

Module 8: Suggested Disk Resource Strategies

  • Resource Allocation for System Databases
  • Resource Allocation for User Databases
  • Monitoring Space Usage

Module 9: Auto Expansion

  • Overview of Auto Database Expansion
  • Installing Auto Expansion
  • Managing Auto Expansion using sp_dbexten

Module 10: Managing tempdb

  • Review of System tempdb
  • Installing Multipletempdbs
  • Binding to a tempdb
  • Managing tempdbs - Precedence
  • Troubleshooting and Recommendations

Module 11: Administering System Roles and Logins

  • Overview of Access
  • System Roles
  • Logins
  • Proxy Authorization

Module 12: Managing Database Access and Users

  • Database Owners
  • Database Users
  • Object Creation Permissions

Module 13: Implementing Object Permissions,Groups and Roles

  • Object Permissions
  • Groups
  • Overview of User-defined Roles
  • Implementing User-defined Roles

Module 14: Using Bulk Copy Utility

  • Copying Definitions
  • Bulk Copy Overview
  • Bulk Copy Syntax

Module 15: Overview of Automatic Recovery

  • Overview of Automatic Recovery
  • Recording Modifications
  • Recovering Modifications after a Shutdown
  • Checkpoints
  • Recovery Order

Module 16: Planning for Backups

Backup Basics
Backup Server
Truncating the Transaction Log
Developing a Backup Plan

Module 17: Performing a Backup

Making Backup Servers Known to Adaptive Server
Dumping Databases
Loading Databases
Dumping Transaction Logs
Loading Transaction Logs

Module 18: Practicing Advanced Backup Techniques

Thresholds
Transaction Log Recovery
Database Recovery
Rebuilding the master Database

Module 19: Sybase Central

Sybase Central Defined
Using Sybase Central
Administration Tasks
Job Scheduler
Interactive SQL

Module 20: Monitoring the System

Monitoring Errors
Monitoring Processes
Monitoring Licenses
Monitoring System Performance

 

 
 
HOME    COMPANY    SERVICES    CAREERS     CONTACT US
Copyright © 2006-2012 Transform IT. All Rights Reserved.
Terms of Use | Designed by Transform IT User Experience Practice
Connect With Us