Because I am a newbie, is there anyone who can address me how to achieve my end goal?

it depends on what you you want to do with all that. you may be better off installing a decent wallet and use that. wallets usually show your transaction history with all the additional info such as fees.
other wise you have to read the documentation and learn how to use the command line or JSON RPC. i suppose you can do it both with your bitcoin core full node and also with using remote Electrum nodes.
core:
https://bitcoin.org/en/developer-reference#bitcoin-core-apiselectrum:
https://electrumx.readthedocs.io/en/latest/in bitcoin core listaddressgroupings and listtransactions commands return list of addresses and transactions.
in electrum blockchain.scripthash.get_balance and blockchain.scripthash.get_history return address balance and transaction history (only hashes you have to get the tx separately).