Navigation


30 SQL Tips in 60 Minutes

5-04-2016, Meetings, Directors

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.

Biography

Ted Holt is a prolific author on the topics of IBM i, RPG and COBOL development, and is an editor on IT Jungle's Four Hundred Guru newsletter.

Download


Past Meetings

2011-10-01, Meetings, Director of Technology

Click here to see a list of all past MMSA Meetings.


COMMON's Archived Webcasts

2011-08-02, Education, Michael Daly

Webcasts are exclusively free for COMMON members, and offer a great option to stay up-to-date on the latest in Power Systems-related education. They are delivered by recognized speakers, and offer members the flexibility to participate in the hour-long Webcasts from anywhere they have Internet access.

The monthly Webcasts are also archived, creating a great knowledgebase of Power Systems-related education that you can access at your own leisure and review them at your own pace. COMMON Webcasts have immeasurable ROI on your membership dollars, giving you access to leading-edge education that can immediately impact your work, without any additional cost. Below are some of the recent COMMON Webcasts that have taken place...all available free to COMMON members, and delivered by industry experts on the latest topics.

  • Mobile and Cloud Computing with the IBM i
    Speaker: Eamon Musallam, looksoftware
  • Everything You Need to Know to Get Started with the New Systems Director Navigator Console
    Speaker: Pete Massiello, iTech Solutions Group
  • Enhancing Your Existing RPG Applications with PHP
    Speaker: Brian May, Garan Incorporated
  • AIX Business Resiliency and Disaster Recovery
    Speaker: Ferenc Gyurcsan, Vision Solutions
  • IBM i Performance Data Collectors and Investigator
    Speaker: Dawn May, IBM
  • Best Practices for IBM i Performance Management
    Speaker: Dawn May, IBM
  • What You Need to Know and Understand to do Successful IBM i Upgrades 6.1.1 & 7.1
    Speaker: Pete Massiello, iTech Solutions Group, LLC
  • Open Source Report Writing Tools for IBM i
    Speaker: Pete Helgren, Value Added Software, Inc.
  • IBM i 7.1 Overview
    Speaker: Steve Will, IBM

View the complete list of archived Webcasts and access them at http://www.common.org/index.php/webcasts/archived-webcasts.html

Learn more about upcoming Webcasts and register online at http://www.common.org/index.php/webcasts.html