Mastering Transact-SQL Programming: Advanced Tips & Techniques

Sybase, Inc.
Ottawa, Toronto, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.
Course Objectives :
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
Course Topics:

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

Elements of this syllabus are subject to change.

Phone:(978) 287-1626

School Address:

Sybase, Inc.
Toronto Learning Center
175 Bloor Street East, Suite 800
Phase 1 - North Tower
Toronto, Canada M4W 3R8

Jobs & Resumes: Ottawa, Toronto
Houses & Roommates: Ottawa, Toronto
Travel Agencies: Ottawa, Toronto

Search other schools for Mastering Transact-SQL Programming: Advanced Tips & Techniques training resources.

SQL
Quick-Start for ASE Administrators of SAP/BusinessOne
High Availability: Adaptive Server Enterprise 12.0 Companion Server
Performance & Tuning using MDA Tables
Open Client Programming Using Client Library
Open Server Programming
Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
Implementing ASE Cluster Edition
M-Business Anywhere Fundamentals
SQL Anywhere 10.0 Fundamentals
Adaptive Server Anywhere 9.0 Fundamentals
Manage Anywhere Studio 5.0 Administration
Replicating Data using SQL Remote 9.0
MobiLink Synchronization with Adaptive Server Anywhere 9.0
MobiLink Synchronization with SQL Anywhere 10.0
Logical Database Design

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.