Sybase Training In Chennai Adyar - Greens

Sponsored Ads

Price: Check with seller

Sybase Developer Training SyllabusIntroductionDB ConceptsTransact – Structured Query Language (T-SQL)Data Definiti...

  • Category: Language Classes
  • Published: 20/11/2014
  • Current Rating: /5 0 Vote

    Description


    Sybase Developer Training Syllabus


    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




     


    Phone Number : 8939915577

    Related Ads

    Leave your comment


    Copyright © 2016 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us: query[at]tuffclassified.com