SQL Easy as MAGIC! - Steve Wolk

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 will have the skills and tools to: Use SQL to perform both simple and sophisticated ad-hoc queries Create and modify database files using SQL Modify your data quickly and easily without writing any RPG code Set up your own PC to pull data from your IBM i to Excel using SQL

Steven Wolk

CTO, PC Richard & Son

Steven Wolk is the CTO for PC Richard & Son, a 110 year old family owned and operated chain of 66 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college, and he's applied those lessons learned to many roles in IT throughout his 33 year career with PC Richard. As CTO, Steve feels fortunate to lead teams of very talented and dedicated people who are collectively responsible for all phases of technology development, acquisition, deployment, and support throughout the company. Always looking to the future, Steve enjoys speaking about the future of retail at conferences and events, along with subjects ranging from leadership and personal success to a wide variety of technical topics. Steve is passionate about applying technology to create business value, along with a world-class customer experience for PC Richard's customers. He's driven to teach and finds it very rewarding to help his teams reach their full potential. Steve and his wife live in Commack, NY, and enjoy traveling as a family with their two daughters who are attending college. If you’d like to strike up a conversation with Steve, mention anything related to Disney or Star Trek, and you’ll have his undivided attention!

Key:

Complete
Failed
Available
Locked
Video
Open to view video.
Open to view video.
You must register to access.