sybase - mastering advanced t-sql

ahana systems and solutions (p) ltd
bangalore, india

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: umashankar

Course Description:

'' sybase database administration

mastering advanced t-sql
course description :
it covers a discussion of the underlying nature of relational databases and sql fundamental concepts like locking and query optimization that will impact your applications, set-oriented and sequential processing of data, methods of manipulating data and formatting output, best programming practices

course objectives :
upon completion of this course, you will be able to: i

write queries that will use the query optimizer to access indexes
understand the many different types of joins and subqueries
use the case expression to write more powerful queries
understand how locking works in adaptive server
use h?s effectively
manipulate numeric and temporal data to solve everyday problems
course topics:

module 1: sql and transact-sql
module 2: understanding sql basics
module 3: indexes and search arguments
module 4: joins and subqueries
module 5: using case logic
module 6: transactions and locking
module 7: writing effective transactions
module 8: using h?s
module 9: manipulating data
module 10: formatting output data
module 11: writing effective transact-sql
module 12: writing effective stored procedures
module 13: assigning key values
module 14: creating hierarchies with sql
...''

Elements of this syllabus are subject to change.

Phone:+91 80 26675891

School Address/Venue(s):

105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore ��?560050



Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

Search other schools for sybase - mastering advanced t-sql training resources.

SQL Server 2005: Integration Services
sql server 2005: reporting services
Perl
Shell Scripting
VMWARE ESX Administration
Linux System Administration (Based on RedHat)
sybase database administration
system and database administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.