POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Monday, May 20 • 9:15am - 10:15am
22BM Intermediate SQL: Unleash the POWER

Log in to save this to your schedule, view media, leave feedback and see who's attending!

You've probably used basic SQL - so maybe it's time to expand your SQL skills! The session presents SQL techniques for both interactive and embedded use that are steps beyond the simple WHERE clause...techniques that, in a single statement, achieve what would take literally hundreds of lines of code. 


Learn how to use techniques like CTEs and self-joins to leverage your programming and analysis capabilities

Learn optimization techniques you can put to work  immediately for significant performance gains in both custom programs and globally across all database access!

Master the technique of "focused laziness" which leads to higher productivity with less work!

avatar for Drew Dekreon

Drew Dekreon

Drew is currently the Applications Manager for enterprise sytems with a major transportation company and an adjunct professor at the University of Alaska. Drew began working with the platform when he took over responsibility for a System/38 in 1987 and has been actively developing... Read More →

Monday May 20, 2019 9:15am - 10:15am PDT
Fantasy Tower Magic Kingdom 1
  • Focused Education Roadmap SQL Programming
  • Level Intermediate
  • AWARD Silver
  • Operating System IBM i, Not Related
  • Audience Basic understanding of SQL is necessary Programmers looking to move to a new level of expertise useful in both DB2 and non-i sql. Query users wanting to really be able to extract data from their systems