La Crosse Management Systems 2006 Training Seminars

Spring 2006 Customer Conference
Session: SQL Script Writing Level 1
User Group: La Crosse Nextgen
Program Date: Thursday, April 20 and Friday, April 21, 2006 (repeat session)
Program Hours: 8:30 a.m.—12:00 p.m. (1:30—5:00 p.m. for Friday)
Location: LMS Training Center, Suite 240

This seminar is designed to help you understand the concepts of SQL script writing, as well as methods and techniques on how to create and use tables, views, stored procedures, and SQL jobs. Topics include:

Using Select, From, and Where commands
Getting familiar with Nextgen database tables, field names, and aliases
Using proper syntax to understand the differences between viewing and using data
The importance of using operators to restrict data on more than one field
Using Select statements to find records from one table versus multiple tables
How to link tables by using inner and outer join
The value of saving and recycling SQL scripts to make your work easier
The role of aliases when dealing with encrypted tables

Register Here for the Spring 2006 Customer Conference!

Contact Information

La Crosse Management Systems, Inc.
200 Main Street
Suite 220
La Crosse, Wisconsin 54601
Phone: 608-784-8400
Fax: 608-791-5660
Email: info@lacrossesoftware.com
Website: www.lacrossesoftware.com

CUSTOMER SERVICE AND SUPPORT: For questions or concerns regarding software or technical support issues, please send an email to LMS Support at support@lacrossesoftware.com.
TRAINING SEMINARS/ON-SITE TRAINING: For questions or concerns regarding seminars, conferences, product orders, or on-site training, please send an email to LMS Sales at sales@lacrossesoftware.com.
FACILITIES: For questions or concerns regarding a hotel or other facility, please see our Travel Tips page http://www.lacrossesoftware.com/traveltips.html.
GENERAL INFORMATION: For all other inquiries, please send an email to info@lacrossesoftware.com.
WEBMASTER: If you are experiencing difficulty viewing this page or accessing the La Crosse Management Systems website, please send an email to nickl@lacrossesoftware.com.