Mastering Transact-SQL Programming: Advanced Tips & Techniques for ASE (ASE7)

This course teaches practical techniques and tips to write efficient SQL for Sybase Adaptive Server Enterprise 15.0, focusing on query optimization, indexes and search arguments, joins and subqueries and reliable data manipulation patterns.

Through lectures and hands-on labs you will learn proper coding habits for data calculations, date and formatting functions, using CASE and cursors, and building and debugging stored procedures to solve real-world ASE problems.

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Indexes and Search Arguments
  • Joins and Subqueries
  • Case Expression
  • Transactions and Locking
  • Cursors
  • Manipulating and Formatting Data
  • Indexes and Search Arguments
  • Joins and Subqueries
  • Case Expression
  • Transactions and Locking
  • Cursors
  • Manipulating and Formatting Data
Assumed knowledge:
Completion of the Fast Track to Adaptive Server Enterprise course or equivalent SQL and database experience.
Schedule:
4 days (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: