ASE Training Courses and Workshops
School(s) providing training of HP Accredited Sytems Engineer

System and Database Administration: Adaptive Server Enterprise 12.5
Course Format: Classroom
School/Trainer: Sybase, Inc. [>>]
Training Centers: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

Learn how to identify the major tasks of Sybase system and database administration and practice these tasks using your own Adaptive Server Enterprise (ASE) 12.5.0.1 in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and CPU) with a goal of creating a reliable Adaptive Server environment. Examine fundamental monitoring and troubleshooting methods, backu......

Course description>>

 

Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE), and learn to create database objects expertly using ANSI-standard SQL and Transact-SQL extensions. Study key features and functions of ASE including automatic recovery of transactions, writing Stored Procedures and triggers, and creating and using cursors. Course material also covers important concepts from I......

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

Course description>>

 

Securing data while moving from client to server or from server to server is a major issue in a database environment for administrators and system security officers. Learn about network security issues in general and how Sybase Adaptive Server Enterprise (ASE) database software is configured to provide secure client/server and server/server communications. ASE 12.5 supports two mechanisms for c......

Course description>>

 

The Backup Server is a critical element in the management of data; but it is often overlooked from a Disaster Recovery standpoint. Learn how to configure this new "no limits" Backup Server to dump and load any size database faster and on more devices, than ever before. A practical knowledge of the Adaptive Server Enterprise 12.5 Backup Server will also enable you to design appropriate......

Course description>>

 

Corruption of a production database can be a serious problem. This could mean lost data and/or extensive down time. Either one resulting in huge financial losses. Behind the Scenes with DBCC Commands looks at a variety of DBCC commands that are available to assist in identifying database corruption before it becomes a problem. You’ll learn about the available commands, how they work and wh......

Course description>>

 

Gain an introduction to the new Sybase utility, SQL Expert. Focus is on core features of SQL Expert including: Database Explorer, SQL Editor, SQL Formatter, Syntactical SQL Optimizer and SQL Comparer. These features along with the SQL Monitor and the SQL Scanner make up the SQL Expert utility. Learn to use SQL Expert to enter code, benchmark performance and compare source SQL code with the alte......

Course description>>

 

Course will include how to download and install the current interim release version 0.1 for Adaptive Server Enterprise (ASE) 12.5. We will cover the new features associated with 0.1, including disk resize, grantable dbcc’s, the new ASE migration tool, performance enhancements to JAVA and XML, and introduce the new ASE lightweight replication feature. We will also introduce available featur......

Course description>>

 

This lecture covers an understanding of the architecture and functionality of the new SybMigrate Utility. This will prepare you to use and fully employ the utility when migrating a database from an existing server to a server with a larger page size. Topics covered include the Architecture and features of the Utility as well as the requirements for using the utility. A walk through the migratio......

Course description>>

 

Take full advantage of the power and capabilities of Sybase Adaptive Server Enterprise database software. The lecture reviews and explains parameters that can be modified to improve server performance. Other parameters are discussed providing you with a complete understanding of possible modifications through configurable parameters. Become familiar with options to a server, identify parameters......

Course description>>

 

Pages:- ...40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 ...

Algeria - Argentina - Australia - Austria - Belgium - Brazil - Canada - Chile - Denmark - Egypt - Finland - France - Germany - Greece - India - Indonesia - Ireland - Italy - Japan - Luxembourg - Malaysia - Netherlands - New Zealand - Nigeria - Norway - Pakistan - Peru - Philippines - Russia - Singapore - South Africa - Spain - Sweden - Switzerland - United Arab Emirates - United Kingdom - United States