Mastering Transact-SQL Programming: Advanced Tips & Techniques

Product type
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

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 …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, Programming (general), PL/SQL, IT Security, and Web Accessibility.

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.