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.
Database and Software Architect - Fresche Solutions, Inc.
Birgitta is a database and software architect at Fresche Solutions.