POWERcast: 5 SQL Tips Everyone Should Know

POWERcast: 5 SQL Tips Everyone Should Know
Speakers: Birgitta Hauser & Steve Spieler
Price: Free courtesy of HelpSystems
Time: 11 AM (CT)

SQL has become the standard for accessing data located within relational databases, like IBM Db2, Microsoft SQL Server, Oracle Database, or MySQL. In fact, the annual IBM i Marketplace Survey Results show that SQL is the #2 language for new development on IBM i, coming in just behind RPG.

Many organizations use IBM i as a database server and rely on SQL to build new tables and provide faster access to the data. There is so much that you can do with SQL, but the devil is in the details and it can be helpful to have a few tricks up your sleeve.

Join this live webinar where Birgitta Hauser, world-renowned database expert, joins the business intelligence experts from HelpSystems to share several tips and tricks that can help when working with SQL, including:

  • Searching for % or _ characters in Strings
  • Removing (only) leading and trailing characters from a string
  • Calculating with SQL
  • Editing numeric Values
  • Converting numeric Dates/Time Values into SQL Date and Time Data Types and vice versa

You’ll also discover a tool that can help you move beyond rows and columns to turn data into actionable insight.

We look forward to you joining us on August 6!

Birgitta Hauser
Birgitta Hauser is an experienced RPG programmer as well as a database and software engineer, focusing on IBM i application and database modernization. Today, she works as a consultant on application and database modernization on IBM i and Db2 for i, most recently teaming up with Fresche Solutions Inc. as a contractor. Birgitta also works in education as a trainer for RPG and SQL developers. Since 2002, she has been a frequent speaker at COMMON user groups meetings and other IBM i and Power conferences.

Steve Spieler
Steve Spieler is a Training and Services Consultant for HelpSystems. He has over 25 years of experience working with information and reporting systems on IBM Power Systems servers. Steve has worked with companies in a wide variety of industries throughout Europe and North America as an educator and consultant. Since joining HelpSystems in 2006, his focus has been on helping companies get the most out of Sequel and Showcase.

8/6/2020 11:00 AM - 12:00 PM
Registration not available.
My registration status: Not registered

Sign In