Contact | Privacy Policy
 
YOU CAN! Learn how at the next Summit
October 17-19, 2017 in Minneapolis
Sponsors & Special Offers
News Headlines
March 27, 2017
SAVE THE DATE! Join us in Minneapolis October 17-19, 2017 for the next RPG & DB2 Summit!
December 5, 2016
RPG & DB2 Summit attendees see tangible results of their education
December 5, 2016
Summiteer Ake Olsson describes modernization journey
May 17, 2016
20th RPG & DB2 Summit Teaches Latest OLAP, Temporal Capabilities in DB2 for i
February 10, 2016
Gantner, Paris & Tuohy each earn 2016 IBM Champion honor.
January 12, 2016
New IBM i DB2 Track Debuts at March 2016 Summit

DB2-Oriented Sessions

Update on DB2 for i

This session will focus on what's new in DB2 for i, covering the latest features, functions and benefits in 7.2, 7.1 and the database technology refreshes.

Speaker: Tom McKinley

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

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

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: Doug Mack

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

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

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

What's New in DB2 Data Migrator and ETL

This session will focus on what's new in DB2 Data Migrator, covering the latest features, functions and benefits of this robust and powerful tool set. The presentation will also take a look at business intelligence architectures, including data extract / transform / load concepts.

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

Speaker: Doug Mack

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

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