Loading…
POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Saturday, May 18 • 12:30pm - 4:00pm
A4CF WORKSHOP: SQL Programming

Log in to save this to your schedule, view media, leave feedback 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!

Learning Objectives:

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.

To register for a workshop, please visit Cosmo.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Saturday May 18, 2019 12:30pm - 4:00pm PDT
Fantasy Tower Monorail A-B
  Database
  • Focused Education Roadmap SQL Programming
  • Level Intermediate
  • Operating System IBM i
  • Audience Managers, programmers, database administrators and even (SQL) Query users who want to enhance their SQL knowledge.