Sybase Training

Sybase Training Syllabus

 

Dhaksha technology is giving the best  sybase training in chennai, Medavakkam. We are providing placement focused and real-time training.

Eligibility for the sybase training – Freshers, 2013 – 2016 passed out and Corporate Employees was working in other technologies

Free Demo Session is available on wednesday’s

Course Fees : 10,000 (with easy installments)

 

SyBase Training Syllabus

Introduction

  • DB Concepts

  • Transact – Structured Query Language

  • Data Definition Language

  • Data Manipulation Language

  • Data Control Language

  • Identifiers

DDL-Data Definition Language 

  • CREATE

  • ALTER

  • DROP

  • SQL Constraints

  • Primary key

  • Foreign key

  • Unique

  • Not null

  • Check

  • Default

  • identity

  • Data types

  • Implicit conversions

  • Explicit conversions

DML-Data Manipulation Language

  • Selecting data from table

  • Eliminating duplicates

  • Operators used

  • Comparison operators

  • Ranges

  • Lists

  • Where clause

  • Matching patterns

  • Aggregate functions

  • Organizing query results into groups

  • group by clause

  • having clause

  • null values and group by

  • aggregates with and without group by

  • Sorting query results

  • order by clause

  • Summarizing group of data (compute clause)

  • Combining queries

  • Union operator

Joins and Sub-queries

  • Joins

  • How joins works

  • How joins are processed

  • Types of Joins

  • Equi-joins and natural joins

  • Self joins

  • Inner and Outer joins

  • Inner joins

  • Left outer joins

  • Right outer joins

  • How null values affect joins

  • Which columns to join

  • Sub-queries

  • How sub-queries works

  • Restrictions

  • Sub-queries in update/insert/delete statement

  • Types of sub-queries

  • Correlated sub-queries

SQL Derived tables and views

  • What is a derived table

  • How SQL derived table works

  • Partitions

  • Views

  • How view works

  • Creating views

  • Retrieve and modify data through views

  • Dropping views

Indexes

  • How indexes works

  • Types of indexes

  • Clustered index

  • Non-clustered index

  • Differences

  • Creating indexes

  • Using clustered and non-clustered indexes

  • Index options

  • Defaults

  • Rules

Stored Procedures, Cursors and Triggers

  • Control flow Language

  • Local and Global variables

  • How SP works

  • Create and execute procedures

  • Return values from SP

  • System Stored procedures

  • Cursors

  • Triggers

  • Using triggers to maintain referential integrity

Transactions

  • How transaction works

  • Consistency

  • Recovery

  • Transactions and its usage

  • Transactions mode

  • Using transaction with SP, cursors

 

 sybase training in chennai