Register for Demo Class

For Online Training

We are the No1 Leading Provider for Online Training

Video Reviews

Reviews

Besant Technologies
5 Star Rating: Recommended 4.9 out of 5 based on 3802 reviews.

Review Source:









Bangalore Support

E : traininginblr[at]gmail.com

BTM Layout :
+(91) 762 494 1772
+(91) 762 494 1774


Marathahalli :
+(91) 910 812 6341
+(91) 910 812 6342


Rajaji Nagar :
+(91) 734 915 0004
+(91) 734 916 0004
+(91) 755 011 2282 | +(91) 755 023 5062|traininginblr[at]gmail.com

Sybase Training in BTM Layout

Home/Sybase Training in BTM Layout
Sybase Training in BTM Layout 2018-04-26T17:31:48+00:00

Session : 1 – Introduction

  • DB Concepts
  • Transact – Structured Query Language (T-SQL)
  • Data Definition Language
  • Data Manipulation Language
  • Data Control Language
  • Identifiers
  • T-SQL Extensions

Session : 2 – 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

Session : 3 – 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

Session : 4 – 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

Session : 5 – 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

Session : 6 – 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

Session : 7 – 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

Session : 8 – Transactions

  • How transaction works
  • Consistency
  • Recovery
  • Transactions and its usage
  • Transactions mode
  • Using transaction with SP, cursors

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya

Quick Enquiry