SYBASE ONLINE TRAINING BY ''MENTORSINN'' IN HYDERABAD, INDIA

SYBASE ONLINE TRAINING IN HYDERABAD
SYBASE COURSE CONTENT
SYBASE OVERVIEW
CLIENT/SERVER ARCHITECTURE
SYSTEM DATABASES AND OBJECTS
SYSTEM TABLES
DATABASES
Creating
Accessing
Altering
Dropping
DATATY
PES
System-defined
User-defined
QUERIES
Select
Choosing columns
Character strings in Column /Query
Eliminating Duplicate Query Results
Selecting Specific Rows
Relational operators
Restriction based on a range
Restriction based on list
Searcing for null
SORING
GROUPING & SUMMARIZING
BUILT-IN FUNCTIONS
JOINS
Equijoin
Natural Join
Self Join
Cross Join
UNION OPERATOR
TABLES
Creating Tables
Dropping tables
Altering Tables
DATABASE INTEGRITY
Indexes
Clustered Indexes
Non-clustered Indexes
Unique Indexes
Creating an Index
Dropping an Index
CONSTRAINTS
Unique
Primary Key
Default
Check
DATA MANIPULATION LANGUAGE
Adding
Deleting
Updating
CREATING A TABLE USING SELECT INTO
SUBQUERIES
Types of Subqueries
Using in,any,all
Correlated subqueries
Restrictions on subqueries
Nested subqueires
VIEWS
BATCHES AND STORED PROCEDURES
Paramterized procedures
TRANSACTION
LOCKING
TRIGGERS
ENROLL NOW