WW07
SQL Programming Tips
Sat, AM
Kirk Paul Lafler
Software Intelligence Corporation
Email: KirkLafler@cs.com
Abstract:
Structured Query Language (SQL) is a universal language that allows you to access data stored in relational databases or tables. By learning how SQL can be used in accomplishing simple tasks, you’ll be able to define, manipulate, and control data from one
or more tables quickly and easily. This class presents numerous tips on how to construct simple and complex queries, subset data, produce reports, use summary functions, create tables and views, join two or more tables of data, and conduct performance tuni
ng to optimize queries.
Biography:
Kirk Paul Lafler is a SAS Alliance Partner(R) and consultant with 25 years of SAS programming experience. He provides IT consulting services and training to Fortune 1000 companies and government agencies around the world. Kirk has written three books and m
ore than one hundred articles and is a frequent speaker at International, Regional, and Local SAS User Groups. He also writes a “SAS Tips” column that appears regularly in the SANDS and SESUG Newsletters.