Three top SQL queries you need to get Table metadata. Metadata means Table structure. That means to know indexes and columns of a Table in question.
How to write SQL procedure in DB2 explained with coding guidelines.
I have explained how to implement Cache memory in AWS. It also explained in-memory data store Redis and its benefits.
Simple ideas and quickly what you need to find to write a query for joining of two tables explained.