POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Tuesday, May 21 • 4:00pm - 5:00pm
37BP SQL Easy as MAGIC!

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

Do you use SQL? Do you use it to its full capabilities? SQL is an amazingly powerful tool, but can seem overwhelming at first. In fact, it can sometimes seem like magic! Come join us for a session on SQL that begins with the basics and builds into very useful techniques you can use every day. Using magic to help explain some key concepts will make this session entertaining as well as educational. Discover how to use SQL not only for data definition and data manipulation, but also as a wonderful ad-hoc query tool. Save time writing reports and get the answers your business needs in seconds. Learn how to easily execute an SQL statement on your PC that will pull data from your IBM i into an Excel spreadsheet! We will cover other practical examples, such as easily processing a job log for the information you need.

Learning Objectives:

After participating in this session, attendees should have the skills and tools to: 
  1. Use SQL to perform both simple and sophisticated ad-hoc queries 
  2. Create and modify database files using SQL
  3. Modify your data quickly and easily without writing any RPG code 
  4. Set up your own PC to pull data from your IBM i to Excel using SQL

avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

Tuesday May 21, 2019 4:00pm - 5:00pm PDT
Fantasy Tower Magic Kingdom 4
  • Focused Education Roadmap SQL Programming
  • Level All
  • AWARD Silver
  • Operating System IBM i
  • Audience Anyone who would like to make the most of SQL would benefit from this session. If you've ever felt that writing one-time-use RPG programs to manipulate or analyze data wasn't a productive use of your time & and if you enjoy magic - then please join us!