Regarding Chessbase softwares I have bought Houdini 6 pro ( ChessBase version ), for the primary purpose of practising by playing games against Houdini 6 pro (and other engines I own)
I cannot figure out how to play a game against it (Not friendly game with dumbed down engine) . I want to play games with the engines full capacity (using ChessBase GUI)
Is this possible or is ChessBase just a database program.
Thanks in advance.
Chessbase is indeed just a database program, albeit a very powerful one. If Houdini doesn't already provide it then you will need some kind of front end to play games against it.

One of the best free ones is Scid vs PC. This is available for download on Sourceforge and if you need more help getting started with it then there is much useful information on the Watford Chess Club website. There it explains in great detail what you need to do to get Scid to use other engines like Houdini.