Contact | Privacy Policy
 
YOU CAN! Learn how at the next Summit
March 26-28, 2019 in Charlotte
Sponsors & Special Offers
News Headlines
June 5, 2018
Next Summit highlights SQL, Db2 for i, Open Source
March 30, 2018
SAVE THE DATE! The next Summit is October 2-4, 2018 in Chicago!
February 6, 2018
New RPG & DB2 Summit Sessions Help IBM i Developers Achieve Big Goals
January 31, 2018
2018 IBM Champions Named! Congrats to Scott Klement, Alan Seiden, Mike Pavlak, Liam Allan, Susan Gantner, Jon Paris, Paul Tuohy!
October 20, 2017
Fun photos from the October 2017 RPG & DB2 Summit

DB2-Oriented Sessions

SQL Writing Tips and Techniques

The SQL language provides a myriad of ways to write queries and procedures. There are many ways to write an SQL statement to get a desired result. However, not all queries are created equal from a performance and maintenance perspective.

This session will compare and contrast different ways to approach a problem from an SQL perspective, based on experience and knowledge of the internal workings of SQL. Whether it is writing queries or procedures, taking the right approach for writing SQL can help the database help you.

Speaker: Robert Bestgen

Advanced SQL Coding

This session will focus on advanced SQL topics that reinforce set-at-a-time concepts of SQL DML. Potential topics include: Grouping Sets, Recursive Common Table Expressions, Lateral, join types, OLAP Extensions, and more.

Speaker: Rob Bestgen & Jim Denton

Advanced SQL Procedure Language Elements

This session will review the SQL procedure language and provide insight into data centric programming via advanced SQL language elements and concepts. The presentation covers coding and implementation of the SQL routines: procedures, functions and triggers. These routines are a key foundation for the Application Data Interface.

Speaker: Jim Denton

Db2 for i - Strategy, Enhancements and more

I own the Db2 for i development strategy, plan and team. It's always a sunny day in the database, even if it is frigid outdoors.

In this session, I will explain how and why Db2 for i has changed in recent years.

Beyond delivering major feature enhancements in IBM i operating system releases, the database team typically delivers enhancements on a twice-per-year cadence via DB2 PTF Groups.

Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more.

This session ends with an overview of the Db2 for i capabilities recently added to IBM i 7.2 and IBM i 7.3 including:

  • JSON publishing and scalar functions
  • Full Limit and Offset support
  • New IBM i Services, always a fan favorite because of the easy adoption of something valuable
  • And more

Reference the IBM developerWorks Technology Updates wiki:

http://www.ibm.com/developerworks/ibmi/techupdates/i72-TR7
and
http://www.ibm.com/developerworks/ibmi/techupdates/i73-TR3

Speaker: Scott Forstie

Hidden Gems in Db2 for i

The IBM i team has been delivering new function two times per year since 2010. New releases and technology refreshes deliver a broad range of function and sometimes the smallest line items can be easily missed.

In this session, Scott has assembled some of his favorite hidden gems; things that you might have missed but should know.

Better yet, Scott includes the working examples and rationale for incorporating this technology.

Speaker: Scott Forstie

Advanced Data Analysis Using Db2 Web Query

Db2 Web Query for i is well known, though likely under utilized, in the IBM i world. Web Query provides many perspectives to consolidate and visualize information from data.

This session delves into several ways to combine the power of Web Query with Db2 for i to improve your reporting and analytics experience.

Speaker: Robert Bestgen

SQL Performance

In this session we utilize over 60 years of experience in Db2 for i to look at a variety of DB performance issues. We describe these 'red flags' and also give you tips on how to identify them using Db2 for i tooling. Finally for each of these we give advice on how to solve them and avoid them in the first place.

Speaker: Jim Denton

Expanding the World of Data

Expanding business value from data is nothing new in IT. Access to outside data sources and expanded ways to store and analyze that data are rapidly growing.

Modern applications, or modified version of traditional apps, can more easily take advantage of other data sources than ever before. The value of in-house data can be greatly enhanced by complementing that data with additional information.

This session surveys other types of data stores and discusses what types of information those data stores can be used for. Integrating these outside sources and data stores into your Application Data Interface will also be discussed.

Speaker: Jim Denton

Opening Up Your Db2 for i Data

Whether due to competitive pressures or a need to modernize and streamline processes, companies are faced with the challenge of providing remote SQL based access to data stored in DDS defined databases which are traditionally maintained by high level language programs using record level access. This session focuses on IBM's best practices for providing new access to legacy databases with little or no impact to the high level language programs. It will also cover techniques for enhancing the database including stateless pagination for mobile devices, optimistic locking, and improved security/auditing.

Speaker: Jim Denton

DB Security - NOT Diving into the (Data) Breach

Data has value and is a critical asset to a business. When a business is "hacked", it means data is stolen or destroyed and a company's reputation is tainted, possibly permanently. Plus, with new compliance laws, there can be legal consequences for not properly securing and managing data.

This session discusses the importance of data, distinguishes different types of data, identifies the many ways data can be breached, and what to do protect your data. Topics covered include: Personal Information, Security administrative roles, Object level Security, Row and column access control, PowerSC, and more.

Speaker: Robert Bestgen

Accessing Data Outside of Db2 for i

There's a world of data out there that can improve and integrate with your own business data. Come to this session to see how the Web and other databases can be available to you via Db2 for i and SQL.

Speaker: Robert Bestgen

30 SQL Tips in 60 Minutes

SQL is THE data access language. It runs interactively from green screens and System i Navigator. It's in RPG and COBOL programs, in ODBC and JDBC. It's ubiquitous, and it's everywhere, too! You can't know too much about SQL. In this session, Ted Holt presents an assortment of powerful, effective, and easily implemented SQL tips and techniques.

These tips and techniques are based on DB2 for i, but many of them apply equally to other platforms. There's something for everyone, from the SQL novice to the advanced user. Come learn some new techniques and reacquaint yourself with some you may have forgotten.

Speaker: Ted Holt

An Introduction to Database Design and Modeling

This session will focus on the idea, concepts and best practices for database design and physical modeling. While arguably one of the most important factors in building a successful data centric application, database modeling is often overlooked or performed sub optimally. The presentation will set the stage for meeting business requirements.

Speaker: Jim Denton

Transactional vs. Analytical SQL

Understanding and spotting it. What should an appropriate data model should look like? What are the red flags that your data model is not best for your usage? This session will discussion these topics along with strategies for doing more analytical processing of your transactional data.

Additional topics will be covered such as:
  • Virtual vs. ETL mapping
  • using dimension tables for dates, VINs customer name, zip code, etc..
  • Operational Data stores,
  • Dimensional Data Model and why they are best for analytical analysis

Speaker: Robert Bestgen

Home | Conferences | About Us | System i Community | Privacy Policy | Legal Notices | Email Webmaster | Contact
System i Developer,LLC © 2014