Re: Developer learning tools

Hi Birgitta!
Yes, we discussed this at CEC24, nonetheless, I am looking for a B plan in
case a group of people for a group session won't be available soon.
Anyway, I will soon contact you privately.
Thank you
Lucia

Il giorno gio 20 giu 2024 alle ore 08:55 Birgitta Hauser <
Hauser@xxxxxxxxxxxxxxx> ha scritto:

Hi Maria Lucia,

All of those I found relate to DB2 environments, though specifically

for

z/OS, Linux, UNIX, and Windows. None of them was for IBM i, and

especially

when speaking of performance it can't be this way.

Finally, my second question: do you know of any course of this kind? I

can
easily attend it in English.

We already talked about this (2 weeks ago in Milan): I can offer classes
that cover everything about Db2 for i, SQL (on Db2 for i). I even can put
them together individually.
In Germany we offer "open" classes, i.e. for multiple attendees from
different companies, unfortunately in German. Sometimes it is not easy to
hold those advanced classes, because of the different basic knowhow of

the

attendees.
That's why I prefer to hold those classes for companies (and in other
countries I do it only for Companies)
For a single person ordering an individual training is too expensive ...
but
if you could find at least 2 other who are interested, we can organize a
class (in person or remotely).
Please speak again with the Common guys Roberto, Pascal etc. if they

could

help to organize something.
Coming to Italy would be no problem.

... unfortunately, from my experience, these advanced classes are not
booked
well.
No interest, to highsophisticated?! No idea.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training

them

and keeping them!"
"Train people well enough so they can leave, treat them well enough so

they

don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert
Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Maria
Lucia Stoppa
Sent: Thursday, 20 June 2024 00:00
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx

Subject: Developer learning tools

Hi all,
It's been a while since I last posted a question, and it's not properly
technical this time.

I have been working hard to improve on my technical knowledge of a few
subjects, SQL and Code4i extension for local development to name a

couple,

and now to go on with my learning I need a couple of things that I

haven't

been able to find yet.

Firstly, a reliable system to set up my environment and do my test.

Because

of my consultancy work, I don't have a personal space as I usually work

on

the Customer's system. PUB400 is a <<<great!>>> resource though it has
limitations (of course given its public use!) and sometimes it's down

when

I
have spare time. RZHK, where PUB400 is hosted, offers a developer's

account

(meaning: a shared IBM i 7.4 or 7.5 environment with current PTF levels
and
IBM software maintenance, the possibility to create your libraries, and

5GB

of storage) at a convenient fee (about 50 euros/month), anyway, I have
unsuccessfully tried for months to reach them.
Here comes my first question: do you know of any other cloud platform
providing such a kind of offer, again at a reasonable fee given that I am
doing it on my own?

Secondly, SQL advanced knowledge. I have found many companies offering

SQL

advanced courses whose syllabi include topics such as:

- Identify the impact of Summary Tables, Materialized Query Tables,

and

temporary tables
- Use complex subqueries
- Use a greater number of scalar SQL functions
- Use advanced SQL constructs, such as recursive SQL and table
expressions
- Define User-Defined Distinct Types and User-Defined Functions
- Avoid several of the most common causes for poorly-performing SQL

All of those I found relate to DB2 environments, though specifically for
z/OS, Linux, UNIX, and Windows. None of them was for IBM i, and

especially

when speaking of performance it can't be this way.
Finally, my second question: do you know of any course of this kind? I

can

easily attend it in English.

I have written a lot, I know, but I wanted to be clear about what I am
looking for.

Thank you very much for any hint or suggestion.

Meanwhile, I keep on learning from the online discussions.

Lucia

--

Maria Lucia Stoppa
mlstoppa@xxxxxxxxx
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--

Maria Lucia Stoppa
mlstoppa@xxxxxxxxx
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.