sybase - mastering advanced t-sql

sybase - mastering advanced t-sql

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

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

Pages:- 1
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>