Mastering Transact-SQL Programming: Advanced Tips & Techniques

Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

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
Who Should Attend: Database Administrators, SQL Developers

Prerequisites: Fast Track to Adaptive Server Enterprise (EDB111) or equivalent experience


...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

14800 Quorum
Suite 505
Dallas, Texas 75240
United States

8755 West Higgins Road
Suite 1100
Chicago, IL 60631

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

Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland

561 Virginia Rd.
Concord, MA 01742
(978) 287-1500

3820 Mansell Road
Suite 100
Alpharetta , GA 30022

19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612

Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.

Open Client Programming Using Client-Library
Open Server Programming
Understanding Indexes
Harness the Power with Configurable Parameters
Using SybMigrate
Powering Up to ASE Interim Releases
Introduction to SQL Expert
Behind the Scenes with DBCC Commands
Backup Server Unleashed
Securing Adaptive Server Enterprise Communications
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise 12.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server
Troubleshooting Adaptive Server Data Structures
Performance and Tuning: Adaptive Server Enterprise Query Optimizer
Logical Database Design
Physical Database Design
XML Certification Boot Camp

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.