Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Sybase

( Duration: 7 Days )

By attending Sybase workshop, delegates 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

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

This Sybase training course is intended for:

  • New Administrators of Sybase.

COURSE AGENDA

1

Day 1

  • 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
2

Day 2

  • 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
3

Day 3

  • 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
4

Day 4

  • INDEXES re-introduced
  • Uses of Indexes
  • CREATE INDEX statements
  • Creating VIEWS
  • Uses of Views
  • EXERCISES/Project work
5

Day 5

  • Procedures
  • Procedures Vs SQL
  • Writing procedures
    • With parameters
    • With return values
6

Day 6

  • TRIGGERS
  • Procedures Vs Triggers
  • Writing Triggers
  • CURSORS
7

Day 7

  • TRANSACTIONS
  • ISOLATION Levels
  • LOCKING
  • Useful System Stored procs
    • Sp_help
    • Sp_helpdb
    • Sp_help
    • Sp_who
    • Sp_locks
  • Useful System table
    • SysObjects
    • Sysprocesses
    • Syscomments

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X