If I (or anyone) would give an overview, there would a 100 page argument over it. Nonetheless I will try giving one example: When you take a curve in your car, and a book or cd on your dash goes sliding out to the outer edge of the windshield....there is no real force on it...but you can describe it's motion as if there was. A viewer standing by the edge of the road, btw, does not see a book sliding left to right (perhaps one could say he sees the car diverging/turning away from the book's initial straight path). So we have differing frames of reference, the viewer on the side of the road, and a viewer inside the car. To make the situation even worse, we are on a rotating globe which is orbiting around a sun in a galaxy spinning and moving through the comos, etc.
On the web there are many confusing texts and examples (and some inexact definitions)
Here's one page for the tape on the dashboard (and, lol, says there is no such thing as centrifugal force, but then they are ignoring that it can be used for an analysis inside the frame of reference):
Graphic:
No such thing as centrifugal force (Flame Licker)
Btw, I am not trying to speak authoritatively on this and my understanding of non-inertial frames of reference may be wrong or incomplete, etc. I do see mention at wikipedia in the article on rotating reference frames that "All non-inertial reference frames exhibit fictitious forces."