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.

• Training by Realtime Expert trainer
• Live Online Classes
• Free study material
• Online virtual Classes available in morning, evening and weekend

Prerequisties

• Familiarity with Object-Oriented and mobile device development and concepts
• Intermediate level SQL programming
• Fundamental level Java programming

Duration

Online

• The format is 40% theory, 60% Hands-on.
• It is a 20 days program and extends up to 2hrs each.

Corporate

• The format is 40% theory, 60% Hands-on.
• It is a 5 days program and extends up to 8hrs each.

Classroom

• Private Classroom arrenged 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