I am a student who has completed master's but couldn't take admission to a PhD program due to some unfortunate reasons.
I have done 1 course in Commutative Algebra where I followed the book " Mostly Commutative Algebra" from Chambert-Loir.
I have not studied Homological Algebra but I know that Rotman's book is an excellent reference (Introduction to Homological Algebra).
I have decided to self study from a textbook topics equivalent to a 2nd course in Commutative Algebra in line with the current research lines. ( But I am more interested in commutative algebra than algebraic geometry as of now but I have no one in real life to whom I can ask how different is Algebraic Geometry from Commutative Algebra? There are certainly non-trivial links between them and the methods of Commutative Algebra are very much used in Algebraic Geometry.) I think Algebraic geometry is finding solutions to polynomial equations using algebraic methods but Commutative Algebra is not much concerned with geometric questions but with algebraic questions.
Can you please suggest some reference books?