For Sale : Sybase Mastering advance T-SQL Online, Onsite Training
Posted on November 04, 2009 05:22 am - All Ads by this Poster - Email to friend
Safety Warning
Users are recommended to deal face-to-face and avoid distant users. eClassifieds4U does not offer any payment/transaction services.
Read more about Safety Tips.
Details:
- Price
- (Percentage of Order)
- Location
- Bangalore, M4B 1B3
View Map - Phone
- 44 20 7993 8018
Description:
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:
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 cursors 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 Cursors
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
