About Sybase

Introduction

DB Concepts

Transact – Structured Query Language (T-SQL)

Data Definition Language

Data Manipulation Language

Data Control Language

Identifiers

T-SQL Extensions

Data Definition Language (DDL)

CREATE

ALTER

DROP

SQL Constraints

Primary key

Foreign key

Unique

Not null

Check

Default

identity

Data types

Implicit conversions

Explicit conversions

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