Sybase Training Courses and Workshops
School(s) providing training of Sybase System and Software

Mastering Transact-SQL Programming: Advanced Tips & Techniques
Course Format: Classroom
School/Trainer: Sybase USA [>>]
Training Center(s)/Venue(s): Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States

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 comp......

Course description>>

 

Designed as a core requirement for ASE SQL Developers who want to explore the Adaptive Server Enterprise 15.0 Query Optimizer so as to enable them to improve the performance of their queries. This course is also the core requirement in our ASE 15 Migration for Developers training program. Learn to measure the performance of T-SQL queries and tune your query development for the specific requi......

Course description>>

 

Learn to write flexible, customized Open Server Library 11 applications. Open Server allows you to develop middle tier server applications. Develop a Help Desk application that demonstrates the fundamental Open Server techniques including starting and stopping the server; getting information from the client; handling errors; and returning results to the client. . Course Objectives : Upon ......

Course description>>

 

Learn the new features and functionality in Open Client-Library 11. Client-Library enables you to write flexible, customized applications that communicate with Sybase SQL Server, Adaptive Server Enterprise or Open Server. Learn how to initialize the client/server environment, connect to a server, send static and dynamic requests to the server, and process the results - including normal and comp......

Course description>>

 

Learn how to use MDA Tables to monitor and analyze your ASE environment by querying Adaptive Server’s MDA tables for statistical & diagnostic information. You will configure MDA Tables and gain hands-on labs experience that will lead you through common scenarios of database performance and tuning, analysis and troubleshooting. At the conclusion of this course, you will take away scripts, p......

Course description>>

 

Gain an introduction to and familiarity with the implementation of Mode-2 high availability, a high availability architecture [also called distributed workloads] in which disjoint applications can run on each of the nodes of a cluster. When one node fails, the surviving node takes over its workload avoiding the "e-nightmare" of lost data access during planned or unplanned server downt......

Course description>>

 

A fast and comprehensive start for Authorized SAP/BusinessOne partners who need to learn the building blocks for a successful implementation of Adaptive Server Enterprise (ASE). Learn how to quickly install, configure, manage and monitor ASE 12.5.2 in a safe and controlled environment. You learn the fundamentals of user creation, access and security management, resource management (memory, disk......

Course description>>

 

An excellent refresher for entry-level programmers and database administrators. Gain practical, hands-on experience writing database queries that retrieve, organize, and summarize data managed by an Adaptive Server. Learn to construct simple and complex queries using both ANSI-89 standard SQL and Transact-SQL extensions. Course Objectives : Upon completion of this course, you will be able to......

Course description>>

 

Gain a deeper understanding of the data structures inside Sybase Adaptive Server Enterprise (ASE) 12.5.0.1 and how they are allocated and de-allocated. This expert-level course gets you “under the hood�and exposes you to in-depth technical detail. Use this knowledge to prevent potential problems from database corruption and to reduce time working with Sybase Technical Support. Troubleshoot, re......

Course description>>

 

Learn the extended skills of server administration: what to do when hardware fails, and how to implement special-use features of Adaptive Server Enterprise 15. Practical troubleshooting techniques and disaster prevention will make ASE highly available. Special features allow for greater flexibility in migration and automating administration, server monitoring, integrated data spaces, and resour......

Course description>>

 

Pages:- ...5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 ...

Argentina - Australia - Austria - Belgium - Canada - Colombia - Denmark - Egypt - France - Germany - Greece - Hong Kong - India - Indonesia - Ireland - Italy - Japan - Luxembourg - Malaysia - Mexico - New Zealand - Nigeria - Norway - Pakistan - Philippines - Singapore - South Africa - Spain - Sweden - Switzerland - The Netherlands - United Arab Emirates - United Kingdom - United States

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.