Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Sybase Fast Track to ASE Training

8 Reviews

Srinivasa Nagar, Bangalore

Course ID: 17823

Srinivasa Nagar, Bangalore

Students Interested 2 (Seats Left 0)

8 Reviews

About the Course

Sybase Fast Track to ASE (developer)

Topics Covered

Sybase ? Fast track to Adaptive Server Enterprise

Duration : 4 days

Course Description :

Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE),
and learn to create database objects expertly using ANSI-standard SQL and Transact-SQL
extensions. Study key features and functions of ASE including automatic recovery of transactions, writing Stored Procedures and triggers, and creating and using cursors. Course material also covers important concepts from Introduction to SQL (EDB100), new functions, increased number of arguments in IN statements, increased limits on object identifiers, and new datatypes.

Course Objectives :

Upon completion of this course, you will be able to:
Use the basic components of Adaptive Server Enterprise to connect to a server database, Create tables, populate the tables with data, and efficiently query data from those tables
Employ data integrity methods to ensure the validity of the data
Write code in Transact-SQL
Use and manage transactions effectively
Write stored procedures and triggers to help in database maintenance and upkeep

Course Topics:
Module 00: Course Introduction

Module 01: Introducing Relational Database Concepts and Transact-SQL
Relational Databases
ANSI SQL and Transact-SQL

Module 02: Introducing Client/Server Architecture
Adaptive Server
Interactive SQL
Database System Procedures

Module 03: Querying Data in Tables
Writing Queries 3-5
Reformatting the Result Set
Modifying the Result Set
Writing Qualified Queries

Module 04: Analyzing Data using Aggregate Functions
Grouping Clauses
Compute Clauses

Module 05: Querying Multiple Tables (Joins and Subqueries)

Module 06: Creating Tables
Column Properties and create table Syntax
default Clauses
Table Management

Module 07: Creating Temporary Tables and Querying System Tables
Temporary Tables
Creating copy tables
System Tables

Module 08: Modifying Data in Tables
Insert and Update Statements
Delete and Truncate Statements
The Case Statement
Transaction Log and DML

Module 09: Using Views and Indexes to Affect Query Performance

Module 10: Using Constraints to Enforce Data Integrity
Overview of Data Integrity
Check Constraints
Primary Key and Unique Constraints
References Constraints
Constraint Management

Module 11: Employing Reusable Database Objects (Defaults and Rules)
User-Defined Datatypes
Data Integrity Methods

Module 12: Manipulating Data using Transact-SQL Functions
Function Basics
Datatype Conversion
Function Categories

Module 13: Programming with Variables
Batches and Comments
Local Variables
Global Variables
Dynamic SQL

Module 14: Programming with Control-of-Flow Statements
if Statements
while Loops
Message Statements

Module 15: Using Transactions to Maintain Database Consistency
Defining Transactions
Transaction Statements
Transaction Modes
Error Processing

Module 16: Transaction Management: Isolating Data with Locks
Locking Basics
Locking Schemes
Isolation levels

Module 17: Writing Basic Stored Procedures
Benefits of Stored Procedures
Stored Procedure Syntax
Input Parameters
Return Parameters

Module 18: Refining Stored Procedures
Making Code Readable
Verifying Input Values
Tagging Transaction Modes
Capturing an Error Status
Avoiding Unintentional Rollbacks
Preventing Nesting-Level Errors
Recompiling Procedures

Module 19: Using Triggers to Enforce Referential Integrity
Defining Triggers
Special Trigger Tables
Triggers and Transactions
Trigger Production Practices
Comparing Referential Integrity Methods

Who should attend

Any Individual Interested in Sybase Developer


Basic SQL

What you need to bring

We will provide the required stuff

Key Takeaways

Sybase Fast Track to ASE Certificate

Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

15 Reviews

1 Students

10 Courses

C. K. Chidananda Murthy brings with him a rich experience of 14 years in the training field.
Associated with AHANA SYSTEMS AND SOLUTIONS since 2008 as a Technical Trainer.

Student Feedback


Average Rating




Santosh S Joshi

The training offered was of high quality and exceeded our expectations. The cost factor made the return on investment very high. The professionalism displayed by the resources was really appreciable. The training instructor was highly experienced and gave practical examples which helped a lot. We would be planning more training sessions with Ahana in the future.


Ganga Nagaiah

I am very proud to be trained at Ahana.I was not in a position to decide on my future career path. Ahana gave me lots exposure in Sybase. I am very grateful to all the staff at Ahana. They provided excellent training during the course duration and mentored me after finishing my course as well. Also we were able to utilize labs at all time.



I am delighted to attend the Sybase DBA training in Ahana Systems and Solutions.I never expected such a fulfilling training experience with unlimited Lab facility and very highly experienced faculty. All the doubts and confusions were cleared.The knowledge i gained cant be defined but i learned more than my specific course such as soft skills,tips to clear interviews, real-time exposure and mainly how to grow to next levels.


Prashanth Kumar

Now anybody looking out for Sybase training in India can blindly approach this place to cater to their technical needs, as this place is not only for money, unlike some other places, but its a place where people believe "KNOWLEDGE IS POWER".Also, This bunch of people at "AHANA" are truly enthusiastic towards their goal and they are working with a vision and have potential to reach their goal and I wish Mr.Umashankar and his team "Good Luck".


Sathiya Priya R.V

I am extremely pleased with the methodology of the training. The transition from the basic to the advanced level was taken care in a very diligent manner that befits a very good training organization.


Vivek Singh

My couple weeks training with Ahana was quite fruitful. The sybase training techniques paid a lot of emphasis on relating theory and lab to real life production scenarios in corporate world backed with Ahana's training faculty's superior knowledge of the sybase ASE product.


Sridhar N

Hats off to the team that has put together this programme!! The Ahana team has actually managed to build a priceless storehouse. As an Oracle9i and Sybase DBA student here, I have thoroughly enjoyed my learning. I also believe that the courses that I have done at Ahana makes me a better person in any Software Organization.


Gourav Kumar

It has been a great learning experience for me at Ahana. They make things look very easy and learning great fun. The classes are highly regressive with focus on practical requirements of the IT industry. They discuss each and every aspect of the subject in core and demonstrate it practically in the Labs. All in all it is a BETTER GOOD INSTITUTE and I express my best wishes in all their future endeavors.


Students Interested 2 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for IT Courses Post your requirement now


Submit your enquiry for Sybase Fast Track to ASE Training

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Ahana Systems

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more