Hi
in generally a good starting point are these articles:
Especially Part 3 covers the most things you are asking for:
Also the “new” codex for web development contains a lot of good pointers and examples:
https://styleguide.cumulocity.com/apps/codex/#/getting-started/guides/data-access/overview