IICT provides 100% real-time, practical and placement focused Sybase training in west mambalam. Our Sybase course concentrates from basic level training to advanced level training. Our Sybase training in completely focused to get placement in MNC in west mambalam and certification on Sybase after completion of our course. Our team of Sybase trainers are Sybase certified professionals with more real-time experience in live projects. Our Sybase Course syllabus is enough for anyone who wants to get Sybase certification which meets industry expectations. In our course plan, you will learn Introduction, Data Definition Language (DDL), Data Manipulation Language, Joins and Sub-queries, SQL Derived tables and views, Indexes, Stored Procedures, Cursors and Triggers, Transactions with practical exercises and live examples.
DB Concepts
Transact – Structured Query Language (T-SQL)
Data Definition Language
Data Manipulation Language
Data Control Language
Identifiers
T-SQL Extensions
CREATE
ALTER
DROP
SQL Constraints
Primary key
Foreign key
Unique
Not null
Check
Default
identity
Data types
Implicit conversions
Explicit conversions
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
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
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
How indexes works
Types of indexes
Clustered index
Non-clustered index
Differences
Creating indexes
Using clustered and non-clustered indexes
Index options
Defaults
Rules
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
How transaction works
Consistency
Recovery
Transactions and its usage
Transactions mode
Using transaction with SP, cursors