MASTERING TRANSACT-SQL PROGRAMMING: ADVANCED TIPS & TECHNIQUES FOR ASE
Délka: 5 dní
Cíle:
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
Agenda:
1. Indexes and Search Arguments
2. Joins and Subqueries
3. Case Expression
4. Transactions and Locking
5. Cursors
6. Manipulating and Formatting Data