Mastering Transact-SQL Programming: Advanced Tips & Techniques

Sybase USA
Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States

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:1-800-8-SYBASE

School Address:

Manhattan Learning Center
The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Irvine Learning Center
19800 MacArthur Blvd. Suite 855
Irvine, CA 92612


Jobs & Resumes: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Houses & Roommates: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Travel Agencies: Atlanta, Chicago, Dallas,

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

Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server Enterprise
Troubleshooting Adaptive Server Data Structures
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.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.