5 SQL Tips Everyone Should Know - Birgitta Hauser and Steve Spieler

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.

 

Birgitta Hauser

Independent Consultant

Birgitta Hauser graduated with a business economics diploma and started programming on the AS/400 in 1992. She is an experienced RPG programmer as well as a database and software engineer, focusing on IBM i application and database modernization. Today, she is an independent consultant on application and database modernization on IBM i and Db2 for i. 

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 in Germany, other European countries, the United States, and Canada. In addition, she is co-author of two IBM Redbooks and has also authored several articles and papers focusing on RPG and SQL for the ITP Verlag (a German publisher), IT Jungle Guru, and IBM DeveloperWorks. 

She received the John Earl Speaker Scholarship Award in 2015, the Al Barsa Memorial Scholarship Award in 2018, and was named an IBM Champion in 2021.


Key:

Complete
Failed
Available
Locked
Video
Open to view video.
Open to view video.