MASTERING TRANSACT-SQL PROGRAMMING: ADVANCED TIPS & TECHNIQUES FOR ASE
Duration: 5 days
Goals:
1. Describe ASE Access Methods
2. Explain how the Query Optimizer uses Search Arguments
3.Use different types of Joins and Subqueries
4. Write more effective Queries using the Case Expression
5. Describe how Locking works to write more effective transactions
6. Write programs that handle Errors correctly
7. Understand the proper use of Cursors
8. Solve complex problems with Numeric and Temporal Data
Content:
1. Indexes and Search Arguments
2. Joins and Subqueries
3. Case Expression
4. Transactions and Locking
5. Cursors
6. Manipulating and Formatting Data