Sybase Training In Chennai Adyar - Greens

20/11/2014 Language Classes

Price: Check with seller

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




 

More Details

Total Views:9
Reference Id:#512629
Phone Number:8939915577
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com