Contact | Privacy Policy
 
YOU CAN! Learn how at the next Summit
October 2-4, 2018 in Chicago
Sponsors & Special Offers
News Headlines
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!
December 12, 2017
RPG & DB2 Summit Opens Up Schedule for Several New Sessions in March
October 20, 2017
Fun photos from the October 2017 RPG & DB2 Summit

DB2-Oriented Sessions

The DB2 for i Database Engineer

This session will focus on the role and responsibilities of the DB2 for i "database engineer". It will compare and contrast the tasks involved in database "administration" and "engineering", as well as cover the critical success factors from an organizational, philosophical and technical point of view.

This session relates to the Design, Build, Secure and Tune portions of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Tom McKinley

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.

This session relates to the Design portion of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Tom McKinley

Advanced SQL Data Definition Language Elements

This session will review SQL DDL and provide insight into data centric programming via advanced SQL language elements and concepts. The presentation covers the coding and implementation of the fundamental database physical model attributes.

This session relates to the Build portion of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Tom McKinley

Advanced SQL Data Manipulation Language Elements

This session will review SQL DML and provide insight into data centric programming via advanced SQL "set at a time" elements and concepts. The presentation covers the coding and implementation of queries that identify, construct and retrieve interesting "sets" of information.

This session relates to the Build portion of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Tom McKinley

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

Analyze your Data Using DB2 SQL OLAP Support

Db2 SQL provides the capability to construct very powerful queries using "OLAP specifications" and aggregate functions.

In this session, we will review the concepts of grouping and aggregation, introduce the OLAP specification components, and highlight some clever ways in which to enlist the new Db2 for i 7.3 OLAP functionality to analyze data sets.

Speaker: Robert Bestgen

Deep Dive into DB2 Temporal

This session will focus on the ideas and concepts behind creating and querying a temporal database. The presentation will take a deep dive into the new (7.3) DB2 for i Temporal feature, function and benefits.

This session relates to the Design and Build portion of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Robert Bestgen

What's New in DB2 Web Query and Query Modernization

This session will focus on what's new in DB2 Web Query, covering the latest features, functions and benefits of this robust and popular tool set. The presentation will also take a look at query modernization strategies, including going mobile with business information.

This session relates to the Design and Build portions of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Robert Bestgen

Advanced SQL Procedure Language Elements

This session will review SQL procedures and provide insight into data centric programming via advanced SQL language elements and concepts. The presentation covers the coding and implementation of the SQL procedures, including the consumption of result sets.

This session relates to the Build portion of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Tom McKinley

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

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

A Deep Dive into DB2 Row and Column Access Control

This session will focus on the ideas and concepts behind data governance and control based on user roles and responsibilities. The presentation will take a deep dive into the new (7.2) DB2 for i Row and Column Access Control (RCAC) feature, function and benefits.

This session relates to the Secure portion of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Robert Bestgen

Design It / Build It / Secure It / Tune It

This session will pull everything together, illustrating the use of modern methods to show a simple, but realistic data centric solution start to finish. The comprehensive presentation will include an introduction to the business requirement and demonstrate all phases of the solution process: design, build, secure and tune.

Speaker: Robert Bestgen

An Introduction to DB2 SQL Performance Tools and Methods

This session will provide an overview of the DB2 SQL performance tools and methods included in IBM i. The presentation will provide particular focus on obtaining value from the index advisor and SQL plan cache - both fully autonomic monitoring and analysis mechanisms available to the database engineer.

This session relates to the Tune portion of the Design It, Build It, Secure It, Tune It roadmap.

Speaker: Tom McKinley

Gather & Prepare Data for Analysis... the Automated Way

Anyone who has tried to glean accurate, high level information or 'business intelligence' from anything but the simplest data knows it can be a real challenge. Data is often messy and is frequently spread across many sources. This session will focus on preparing data for analysis. It introduces data gathering, business intelligence architectures, data extract / transform / load concepts, and data abstractions through concepts like metadata. The presentation will also cover what's new with DB2 DataMigrator, IBM's ETL tool for IBM i, and will cover the functions and benefits of this robust and powerful tool.

Speaker: Robert Bestgen

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