Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
         
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
 
 

Adaptive Server Enterprise: Transact-SQL Advanced tips and techniques

Course Code: EDB559      Days: 4
Show all Sybase Courses
Call for Latest Dates
Call for availability.

Expected Availability: Within 30 Days
Expected Price: £ 2000

Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Audience

  • Database Administrators
  • SQL Developers

Skills Gained

Upon completion of this course, you will be able to:

  • 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

Prerequisites

  • Fast Track to Adaptive Server Enterprise (EDB115) or equivalent experience.

Course Outline

  • Indexes and Search Arguments
  • Joins and Subqueries
  • Case Expression
  • Transactions and Locking
  • Cursors
  • Manipulating and Formatting Data


How to make a booking for the EDB559 course

 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership