Contact | Privacy Policy
 
YOU CAN! Learn how at the next Summit
March 20-22, 2018 in Dallas
Sponsors & Special Offers
News Headlines
October 20, 2017
SAVE THE DATE! Join us in Dallas, March 20-22, 2018 for the next Summit!
October 20, 2017
Fun photos from the October 2017 RPG & DB2 Summit
August 30, 2017
CIO Summit Planned For IBM i Executives
June 12, 2017
Next RPG & DB2 Summit highlights DB2 for i, Watson's Web Services & Open Source
February 6, 2017
IBM honors Gantner, Paris & Tuohy as 2017 IBM Champions.
December 5, 2016
Summit attendees see tangible results of their education

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: Mike Cain

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: Hernando Bedoya

Db2 for i - Strategy, Enhancements and more

I own the Db2 for i development strategy, plan and team.

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 is delivering enhancements on a twice-per-year cadence.

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

This session end with an overview of the Db2 for i capabilities being added to IBM i 7.2 and IBM i 7.3 in 4Q/2017.

Details for these enhancements will be found on the IBM developerWorks Technology Updates wiki: (when announced)

  • 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

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

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: Hernando Bedoya

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

DB2 SQL OLAP Support in 7.3

In this session we will illuminate the new and enhanced SQL online analytical processing (OLAP) query specifications, including the specific syntax to get a powerful analytical query coded up correctly. Attending this presentation will give the data-centric developer a powerful set of tools that increase productivity and value. If you are curious about SQL OLAP Specs, get up and attend this session!

Speaker: Tom McKinley

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

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: Hernando Bedoya

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