Modifing Units Stats

[CraigPicard]

question i want to make simple changes to the units in game and i know there is a way to do it by making a SQL or XML file that modifies said unit but i dont know how to do it. can anyone help me

Note: i am not looking for a exisiting mod i want to do it myself.