+91 8142000093 info@tanviinfo.com

Sybase

TIS_Sybase

Sybase

Course Duration : 40 Hours
Course Delivery : Classroom, Online, Weekends

Course Content

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