Re: SQL Stored Procedure Education

On 10/3/2024 10:20 AM, MidrangeL wrote:

Niels Lliisberg providing his command-for-SQL to open source, leads to a desire to learn SQL stored procedures in a more robust way.  For those of us that are not highly skilled in SQL where do we find the education to learn how to use this powerful tool?  I'm particularly impressed with the example code provided to get the exchange rate, as that example opens up a plethora of opportunity, for instance verifying an address, getting shipping rates etc.  Yes all things we do in RPG today, but consider the options that putting a simple command in place to do the same thing.

So where is the education at?

I like Birgitta :-) COMMON Europe recorded one of her talks, and I highly recommend it:
https://www.youtube.com/watch?v=VeMAmMYCHI0&ab_channel=Torbj%C3%B6rnAppehl


Serge Rielau did some amazing SQL presentations when he was with IBM.
While not specific to IBM i, I learnt a lot. Here are two:
https://www.slideserve.com/Gabriel/sql
https://www.slideserve.com/jorn/sql-on-fire-part-2

Graeme Birchall's Db2 SQL Cookbook is interesting. Again, not i-specific, yet very useful:
http://db2-sql-cookbook.org/
The Github version is more current...

Speaking of which, Rodney links to W3Schools. I myself haven't used their material, but he wouldn't suggest it if it was useless...
https://www.w3schools.com/sql/default.asp