Sybase

SYBASE ONLINE TRAINING IN HYDERABAD

SYBASE COURSE CONTENT

  • SYBASE OVERVIEW

    CLIENT/SERVER ARCHITECTURE

    SYSTEM DATABASES AND OBJECTS

    SYSTEM TABLES

    DATABASES

  • Creating
  • Accessing
  • Altering
  • Dropping
  • DATATYPES

  • 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