Mastering Transact-SQL Programming: Advanced Tips & Techniques
Beschrijving
Goals
- Describe ASE Access Methods
- Explain how the Query Optimizer uses Search Arguments
- Use different types of Joins and Subqueries
- Write more effective Queries using the Case Expression
- Describe how Locking works to write more effective transactions
- Write programs that handle Errors correctly
- Understand the proper use of Cursors
- Solve complex problems with Numeric and Temporal Data
Audience
- Database Administrators, SQL Developers
Prerequisites
Essential- Fast Track to Adaptive Server Enterprise (EDB115) or equivalent experience
Content
- Indexes and Search Arguments
- Joins and Subqueries
- Case Expression
- Transactions and Locking
- Cursors
- Manipulating and Formatting Data
Notes
- Learn an …
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Goals
- Describe ASE Access Methods
- Explain how the Query Optimizer uses Search Arguments
- Use different types of Joins and Subqueries
- Write more effective Queries using the Case Expression
- Describe how Locking works to write more effective transactions
- Write programs that handle Errors correctly
- Understand the proper use of Cursors
- Solve complex problems with Numeric and Temporal Data
Audience
- Database Administrators, SQL Developers
Prerequisites
Essential- Fast Track to Adaptive Server Enterprise (EDB115) or equivalent experience
Content
- Indexes and Search Arguments
- Joins and Subqueries
- Case Expression
- Transactions and Locking
- Cursors
- Manipulating and Formatting Data
Notes
- Learn an array of valuable tips, techniques, and advanced topics to implement cleaner and more efficient code. Lecture and lab emphasis is on good coding practices, manipulating numbers and dates, joins and subqueries, applied case logic, cursors, and proper Stored Procedure development and debugging, as well as generalized methods for solving specific problems.
Popular tags
No tags submitted for this course yet
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.