I have understood the foundation of CAML and there are some questions that are still unclear in my mind.
What context and when should a SP developer use CAML?
Why using CAML to retrieve data? what about stored procedure?
How common is it for a SP developer to use CAML?
Do you have a real based example when you used CAML?