sybase mastering advanced t-sql

ahana systems and solutions (p) ltd.
bangalore, karnataka, india

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

Course Description:

'' 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:08026675891

School Address/Venue(s):



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

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

sql server 2005 - performance tuning and optimisation
SQL Server 2005 Integration Services (SSIS)
SQL Server 2005: Analysis Services (SSAS)
sql server 2005: reporting services (ssrs)
sybase -fast track to adaptive server enterprise
sybase performance and tuning
sybase replication
Power Builder (Rapid Application Development System)
VMWARE ESX Administration
Linux 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: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.