Training Services

Effective Code Design

1 day course / Services Rate * Hours
1 Day Course / $2,500 per Day (On-site)*
*Training at your facility for up to 10 students

 

Overview

This workshop has been developed to increase awareness of good coding practices that will maximize performance of the Verticent applications. The usage of tools that are available to achieve this goal will be covered in the course.

Prerequisites

Fast Track to PowerBuilder course completed or equivalent experience Experience with stored procedures and SQL coding practices Recommended Power Builder experience of at least six months Knowledge of the Verticent applications

Who should attend?

This course is intended for PowerBuilder developers. At least one Senior Developer or Manager from each development site should attend this class. This course will provide adequate in house expertise in the coding of the Verticent applications.

Objectives

Upon completion of this course you should be able to:

• Understand the coding practices that will provide optimum performance
• Know and utilize the tools that are available for tracing
• Test the code that you have created

---

Unit 1 - Tracing on msSQL and Sybase

Objectives:
After completing this unit, you will be able to:

• See what's being sent to the DB server
• Debug procedures by pinpointing performance or coding problems

Unit 2 - Transaction Design

• What is a transaction?
• Transaction Pitfalls
• Deadlocks
• Autocommit
• Temp tables and transactions
• Constraints
• AIS transactions

Objectives:
After completing this unit, you will be able to:

• Avoid open ended transactions
• Code concise transactions.
• Avoid Looooonnnnnggg transactions
• Understand what a deadlock is
• Avoid deadlocks

 

Unit 3 - System Tables

Objects
sysdepends.sysobjects
syscolumns
object_id()
object_name()
sp_lock
sp_who
Dependancies

Objectives:
After you have completed this unit, you will be able to:

• Find all objects that use a table
• Find trigger names on a table
• Check locks to see who is locking a DB
• Find all tables that use a particular column

 

Unit 4 - Verticent Utilities

To understand the use of Verticent provided utility programs

Objectives:
After you have completed this unit, you will be able to:

• Use the 'procs' to aid in development:
• List procs here
• Find proc/trigger source info
• Find all objects what contain a string
• Check the version of a proc/trigger
• Inquire on table attributes
• Create an insert column list
• List all objects where look like a variable string etc

 

Unit 5 - Stored Procedure Usage

Use of indeces
Update statistics
Show Plan
Statistics IO
Coding Standards

Objectives:
After you have completed this unit, you will be able to:

• Avoid coding performance problems
• Understand coding where clauses that are covered by and index
• Avoid serial reads
• Reading a query plan
• Logical reads?? What are they?

 

Unit 6 - Coding Stored Procedures

Do's and Don'ts of coding Stored procedures
Do's and Don'ts of coding triggers
Performance Issues

Objectives:
After you have completed this unit, you will be able to:

• Write 'tighter' sql code

 

Unit 7 - Testing

Small controlled dB
Large production dB

Objectives:
After you have completed this unit, you will be able to:

• Test for production size DB

 

For Information about attending Verticent training, please contact us today.