Loading…
Attending this event?
Sunday, September 8 • 1:00pm - 5:00pm
WORKSHOP: SQL Programming

Log in to save this to your schedule and see who's attending!

SQL is much more than a query language. Besides querying and manipulating data in database objects and generating those database objects, SQL also provides all kinds of commands and constructs, for writing and executing programs. With the SQL Programming Language, Stored Procedures, Triggers and User Defined (Table) Functions can be written, without knowing anything else than SQL commands! This session will give you an introduction into the SQL Programming Language. The procedure and function create options and controls are explained. You’ll learn how to structure the source code within the routine body, how to define variables and cursors, what control statements are available, how to read data row by row in a loop, how to receive and return parameter values and result sets and how to handle errors. Besides the pure coding you’ll get also a short introduction into the development tools.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Engineer, Toolmaker Advanced Efficiency GmbH
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Sunday September 8, 2019 1:00pm - 5:00pm
Hyatt Regency Indianapolis 109 South Capitol Avenue Indianapolis, IN 46204