Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 26-07-2017
Search Course Here

Live Chat
Sybase  Online Training



Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms.
  • Familiarity with Object-Oriented and mobile device development and concepts
  • Intermediate level SQL programming
  • Fundamental level Java programming
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Track I: DBA
    • Adaptive Server Enterprise Overview
      • Understand Adaptive Server Enterprise architecture
      • Understand the purpose of each system database
      • Describe the use of each system table
      • Understand Sybase utilities
    • Adaptive Server Enterprise 15.0 New Features
      • Understand the use of the new features in Adaptive Server Enterprise 15.0
      • Understand the new Query Optimization feature
      • Understand changes to Dump and Load
      • Describe any new utility features
      • Describe significant SQL changes
      • Understand how to create computed columns, indexes on computed columns and describe function based Indexes
      • Understand scrollable cursors such as cursor sensitivity, scrolling the worktable, and global variable usage
      • Describe the performance monitoring, diagnosis, and statistics such as query processing metrics, streamlined trace flags, XML format trace output, GUI Plan Viewer, changes to update statistics, and changes to sp_sysmon
      • Understand extensible new limits for new Adaptive Server Enterprise 15.0 data types such as bigint, unsigned int, smallint, unitext, unsigned bigint
    • Configuration, Upgrade and Installation
      • Understand how to manage Adaptive Server Enterprise 15.0 configuration parameters
      • Understand how to install and upgrade Adaptive Server Enterprise 15.0 from a previous version
      • Understand the environment variables used by Adaptive Server Enterprise 15.0
      • Understand server page sizes
    • Resource Allocation
      • Understand the use of file systems, raw partitions, and the dsync clause
      • Describe the partitioning of tables and indexes
      • Be familiar with how to plan, create and manage devices and databases
      • Have knowledge of capacity planning and system limits: for example, devices, databases, segments and transaction logs
      • Understand the system tables related to capacity planning
      • Understand how to manage tables and the details of the alter table subcommands
      • Understand the purposes of the Last Chance Threshold and Free space Threshold, such as how do you make use of them
      • Be acquainted with how to recreate the DDL from reading the storage-related system tables
      • Understand storage space requirements
      • Have knowledge of table creation and structure
    • Database and Logs
      • Describe how to manage databases and transaction logs
      • Understand how to perform logical database rebuilds
      • Understand how to use segments for performance and capacity planning
      • Understand the purposes and uses of system- and user-defined segments
      • Understand Relaxed Size Limitations
      • Understand Large Identifiers
      • Understand Version Migration
      • Understand the standard Adaptive Server Enterprise data types that are not included in 2
    • Backup and Recovery
      • Experience with how to manage the database and transaction log dumps
      • Understand how dumps are processed and what types of dump and load functionality is available in Adaptive Server Enterprise 15.0
      • Understand Cross-Platform Dump and Load
      • Understand dump compression
      • Understand how to perform dumps and loads for standby access
      • Understand how to enable up to the minute recovery
      • Understand all of the following: backup production databases, truncate the transaction log, recover from disasters, protect the master database, and use Sybase mirroring
    • Cache Management
      • Understand how Adaptive Server Enterprise 15.0 manages memory, such as data cache(s), procedure cache sizing, and when are pages written to disk
      • Understand how to configure data caches and buffer pools
      • Describe the Statement Cache
    • Security
      • Be familiar with Adaptive Server Enterprise's password security features
      • Understand how to manage passwords
      • Describe how to grant and revoke privileges in a granular fashion
      • Understand the use of system roles and user-defined roles and their precedence
      • Understand the difference and precedence between groups and user-defined roles
      • Understand the use of proxy authorization
      • Understand the use of access rules
    • Transaction Management
      • Understand transaction Management in Adaptive Server Enterprise, such as commits, rollbacks, locks, and deadlocks
      • Understand how isolation levels are implemented and when to use each one of them
      • Understand implicit and explicit transactions and transaction modes
      • Understand the difference between transactions and checkpoints
      • Understand the transaction log and minimally logged operations
      • Understand how Adaptive Server Enterprise manages pages in memory
      • Describe the use of the BCP utility
    • Dynamic Reconfiguration
      • Understand dynamic (re)configuration
      • Have knowledge of which configuration parameters are static or dynamic
      • Understand how dynamic (re)configuration uses memory
    • Parallel Performance Optimization
      • Have knowledge of how to keep partition statistics up-to-date
      • Understand how to read and interpret columns statistics and how to keep them up to date
      • Understand how to defragment tables efficiently
      • Be familiar with the various table-based and index-based access methods
      • Understand how to enable and utilize parallel processing
    • Locking and Concurrency
      • Understand the different lock types and their use by T-SQL commands
      • Understand how different locking schemes work and how to use them
      • Understand how to diagnose lock contention
      • Understand the effect of different lock types, as well as lock schemes on application concurrency
      • Understand lock promotion
    • Object Resource Management
      • Describe how to use table partitioning and the criteria for table partitioning
      • Describe the steps involved in creating partitions
      • Understand partition skew and how to rebalance a partitioned table
      • Understand how to keep partition statistics up-to-date
  • Track II: IQ
    • Introduction to Sybase IQ 15
    • Installing Sybase IQ 15
    • New Features
    • Sybase Central New Features
    • Behavioral Changes
    • Improved Server Performance
    • Partitioning and dbspace Management
    • Query Performance
    • Operational Management
    • Migrating Data with Simplex Database
    • Migrating Data with Multiplex Databases
    • Concepts and Architecture of Sybase IQ ETL
    • ETL Components, Projects, and Jobs
    • The ETL Development Interface
    • Sybase ETL Server
    • The ETL Project Component Store
    • The ETL Query Designer and Content Explorer
    • Customizing SQL And Transformation Rules in ETL
    • The ETL Runtime Manager
Sybase videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Start From 14th JULY & 15th JULY.

Hadoop Dev New Batch Start From 15th JULY & 16th JULY.

IBM COGNOS TM New Batch Start From 16th JULY & 17th JULY.

Informatica Dev New Batch Start From 17th JULY & 18th JULY.

Mean Stack New Batch Start 18th JULY & 19th JULY.

SAP BODS new Batch Starting From 19th JULY & 20th JULY.

SAP S/4 HANA New Batch Start From 20th JULY & 21st JULY

Tableau New Batch Start From 21st JULY & 22nd JULY


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th JULY & 07:00A.M IST on 14th JULY

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :