Magnetic Ordering Phenomena and Dynamic Fluctuations in Cuprate Superconductors and Insulating Nickelates