sybase

  • Understanding of database concepts and database fundamentals
  • 2-4 years of any Database DBA experience

By attending Sybase workshop, Participants will learn to:

  • Effectively administer a Sybase IQ single server and Multiplex configuration
  • Choose the correct Sybase IQ index types
  • Create Sybase IQ databases, dbspaces, dbfiles, tables, views and indexes
  • Extract and load data into Sybase IQ from a variety of sources
  • Backup and restore a Sybase IQ database

  • New Administrators of Sybase.

COURSE AGENDA

  • Insert data into Table
    • INSERT
    • SELECT INTO
  • Display data from single Table
    • SELECTION Process
    • Projection Process
  • Display data from multiple tables
    • Inner Joins
    • Outer Joins
    • SubQueries
    • Correlated SubQueries
    • Self Joins
    • Joins Vs SubQueries
    • Improving Query Functionality and Performance Tuning
  • Aggregate FUNCTIONS
    • AVG
    • SUM
    • MIN
    • MAX
  • String Functions
  • Date Functions
  • Integer Functions
  • Local and Global Variables
  • Introduction to Databases and Relational Databases
  • Client/Server Architecture
  • Dr. E F Codd’s Rules
  • Entity Relationship Model
  • Database Normalization – Different Normal forms
  • Sybase Database Architecture
    • Devices and Segments
  • Default Databases in Sybase
    • Master, Model, TempDB, SybSystemProcs and SybSystemDB
  • Database Creation
  • Find out user name, DB Name and current date and time
  • Objects in Database
    • Tables
    • Views
    • Defaults
    • Rules
    • Index
    • Procedures
    • Triggers
  • Datatypes in Sybase
  • ISQL and TSQL
  • Table Creation in Sybase
  • Rules, Defaults and Constraints
  • Keys
    • Primary
    • Foreign
    • Unique
    • Candidate
  • Indexes
    • Clustered
    • Non Clustered
  • Introduction of Transaction Logs
  • UPDATE data in tables
  • DELETE data from tables
  • TRUNCATE Table command
    • DELETE Vs TRUNCATE
  • Using Temp tables and System tables
  • DDL, DML and DCL statements
  • DROP TABLEs and DATABASES
  • INDEXES re-introduced
  • Uses of Indexes
  • CREATE INDEX statements
  • Creating VIEWS
  • Uses of Views
  • EXERCISES/Project work
  • Procedures
  • Procedures Vs SQL
  • Writing procedures
    • With parameters
    • With return values
  • TRIGGERS
  • Procedures Vs Triggers
  • Writing Triggers
  • CURSORS
  • TRANSACTIONS
  • ISOLATION Levels
  • LOCKING
  • Useful System Stored procs
    • Sp_help
    • Sp_helpdb
    • Sp_help
    • Sp_who
    • Sp_locks
  • Useful System table
    • SysObjects
    • Sysprocesses
    • Syscomments