I want to know whether my data are trending, co-integrated, have unit roots, have autocorrelation, or have heteroskedasticity. I want to do all this using Stata, so please suggest material or direct me a book on these topics
You want to start with an introductory econometrics book. Stock and Watson's Introduction to Econometrics covers these topics with stata replication files.
Here is a link to the replication files