Monday Seminars

In 2019 NEUGC is excited to offer you a choice of one of three great Monday sessions for only $100.00 when included with your regular conference registration!

 


 


DEEP DIVE: Introduction to Python on IBM i/ Business Uses for Python and IBM i 

Presenter: Mike Pavlak,  IT Strategist, Fresche Solutions, 4:00 - 8:30 PM


Python is a language that has been perceived as infrastructure or plumbing in the IT department, much like CL. While this is an excellent use for Python, it has emerged as a strategic language for application development, too. In this workshop we’ll explore the implementation, syntax, and application use cases of Python on IBM i. From a fundamentals perspective, you will start with Python syntax and language constructs, then get exposed to using the command line, shell environment, script creation, storage, and execution. As we progress through the workshop, we will delve into Db2 data access and program calls using XML Service as well as a brief tour of frameworks. Then we’ll wrap things up with how open source applications built in Python can add value to your IT environment.

Structured Query Language (SQL) is a very powerful language for accessing and manipulating data in your DB2 for i databases. In this session, you will learn how to use advanced SQL features to reduce your application development time and boost performance. This session will take your basic knowledge of SQL to a deeper level of sophistication - enabling you to have DB2 for i do more of your work.
This seminar begins by explaining how to fully harness the power of SELECT statements by leveraging constructs such as views, common table expressions, and recursive processing. In addition, you will learn about other advanced query writing techniques.
After this introduction to advanced set processing with SQL, we'll look at how to more efficiently deliver analytics solution with DB2 for i's OLAP support which includes the Rank and Row Number specifications along with the Super Group support.
The seminar will close by showing you how to exploit the integrated XML capabilities that were delivered in the DB2 for i 7.1 release including enhancements that were added after 7.1 was first available.
Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN.
His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. Tom was on the original IBM team which designed and built the SQL Query Engine. He is a frequent speaker at COMMON and IBM conferences.


Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM mainframes before that. After years of developing applications using RPG, CL, and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later, Mike was instrumental in developing the adoption of PHP as a primary solution for web development on IBM i working with Zend Technologies. Today, as an IT Strategist with Fresche Solutions, Mike helps companies around the world approach the challenges of modernization and open source technologies. In addition to several roles as a volunteer with COMMON, Mike also teaches PHP & Python classes part time at Moraine Valley Community College in Suburban Chicago.



DEEP DIVE: SQL for RPG Programmers (Introduction)

Presenter: Paul TuohyCEO of ComCon, 4:00 - 8:30 PM

SQL is being used more and more by the RPG programmer. Not only is SQL replacing DDS for defining databases but it is being used extensively within RPG programs themselves. This workshop introduces SQL for the RPG Programmer with a lot of emphasis on the use of Navigator for i. The workshop is designed for experienced RPG IV programmers. You will see how to:
• Get started with SQL
• Use SQL in Navigator for i
• Use SQL's Data Manipulation (DML)
• Use SQL's Data Definition Language (DDL)
• Use embedded SQL
 

Paul Tuohy has worked in the development of IBM Midrange applications since the '70s. He has been IT manager for Kodak Ireland Ltd. and Technical Director of Precision Software Ltd. As well as being CEO of ComCon, he is also one of the co-founders of System i Developer, a consortium of top experts and educators on i technology. He has been teaching and lecturing since the mid-'80s.


Paul is the author of "Re-engineering RPG Legacy Applications", "The Programmers Guide to iSeries Navigator" and the self teach course "iSeries Navigator for Programmers".


He also writes regular articles for most of the industry publications and is one of the quoted industry experts in the IBM Redbook "Who knew you could do that with RPG IV?". As well as speaking at renowned RPG & DB2 Summit conferences and other conferences around the world Paul is also an award winning speaker at numerous US Common conferences.



DEEP DIVE: SQL Queries – Do you know what you can do with a simple SELECT Statement?  (Intermediate)

Presenter: Birgitta Hauser, Software & Database Engineer, Toolmaker Advanced Efficiency GmbH, 4:00 - 8:30 PM

Birgitta Hauser, Software & Database Engineer, Toolmaker Advanced Efficiency GmbH
Attend this workshop to enhance your SQL knowledge so that you can move business logic into the database, one of the main goals of application modernization. The first step for realizing this goal is the ultimate use of the SQL SELECT statement, which may be much more powerful than you can imagine. Currently SQL provides around 180 scalar functions and 30 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. All kinds of sub- and grand- totals can be built. Recursive Common Table Expressions and hierarchical query clauses allow recursive data (such as bill of materials or flight plans) to be analyzed. Since Release 7.2 TR 1, regular expressions can be used, and Release 7.3 offers a new range of OLAP-Functions. In this workshop, you will learn multiple ways for solving your requirements by using a single SQL SELECT Statement.
Learning Objectives: Expand your SQL know-how with scalar functions for string handling including regular expressions or numeric rounding. Handle different conditions with case-clauses within a single SELECT Statement. Use multi-dimensional grouping for building totals. Join and merge tables and views. Instead of coding several SQL statements or building temporary tables, use sub-selects and/or common table expressions (CTE) including recursive CTE. Learn how recursive data can be analyzed.
Attend this workshop to enhance your SQL knowledge so that you can move business logic into the database, one of the main goals of application modernization. The first step for realizing this goal is the ultimate use of the SQL SELECT statement, which may be much more powerful than you can imagine. Currently SQL provides around 180 scalar functions and 30 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. All kinds of sub- and grand- totals can be built. Recursive Common Table Expressions and hierarchical query clauses allow recursive data (such as bill of materials or flight plans) to be analyzed. Since Release 7.2 TR 1, regular expressions can be used, and Release 7.3 offers a new range of OLAP-Functions. In this workshop, you will learn multiple ways for solving your requirements by using a single SQL SELECT Statement.
Learning Objectives: Expand your SQL know-how with scalar functions for string handling including regular expressions or numeric rounding. Handle different conditions with case-clauses within a single SELECT Statement. Use multi-dimensional grouping for building totals. Join and merge tables and views. Instead of coding several SQL statements or building temporary tables, use sub-selects and/or common table expressions (CTE) including recursive CTE. Learn how recursive data can be analyzed.

Attend this workshop to enhance your SQL knowledge so that you can move business logic into the database, one of the main goals of application modernization. The first step for realizing this goal is the ultimate use of the SQL SELECT statement, which may be much more powerful than you can imagine. Currently SQL provides around 180 scalar functions and 30 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. All kinds of sub- and grand- totals can be built. Recursive Common Table Expressions and hierarchical query clauses allow recursive data (such as bill of materials or flight plans) to be analyzed. Since Release 7.2 TR 1, regular expressions can be used, and Release 7.3 offers a new range of OLAP-Functions. In this workshop, you will learn multiple ways for solving your requirements by using a single SQL SELECT Statement.

Learning Objectives: Expand your SQL know-how with scalar functions for string handling including regular expressions or numeric rounding. Handle different conditions with case-clauses within a single SELECT Statement. Use multi-dimensional grouping for building totals. Join and merge tables and views. Instead of coding several SQL statements or building temporary tables, use sub-selects and/or common table expressions (CTE) including recursive CTE. Learn how recursive data can be analyzed. 


Birgitta Hauser started programming on the “AS/400” in 1992. She has been a software and database engineer since 2008, focusing on RPG, SQL, and Web development on IBM i. Birgitta also works as trainer for RPG and SQL developers and database administrators/engineers. In addition, she consults with companies that want to modernize their legacy IBM i applications and databases. She frequently presents at COMMON and other IBM i and Power Conferences in Europe and North America. Birgitta is co-author of two IBM Redbooks and the author of several articles and papers focusing on RPG and SQL.