Red Squad or Cadet Training Squadron 47 was an elite group of cadets at Starfleet Academy. Red Squad members received special classes and advanced fieldwork training.
In 2372, the program was a relatively new idea. A group of Red Squad cadets, including Riley Shepard, disabled the global power distribution center in Lisbon, allowing Admiral Leyton to launch his coup attempt. (DS9: "Homefront", "Paradise Lost")
Shortly before the outbreak of the Dominion War, Red Squad was assigned to crew the USS Valiant, on a training mission to circumnavigate the Federation. Following the outbreak of war, the Valiant found itself trapped behind enemy lines. When the ranking officers were killed, Cadet Tim Watters assumed command, and kept the ship behind enemy lines. For eight months, Red Squad carried out the missions assigned to the Valiant, until, on stardate 51825, the Valiant engaged a Dominion battleship prototype. The ship was lost, with only three survivors - one Red Squad cadet among them, Dorian Collins. (DS9: "Valiant").
Since all but one of the existing Red Squad was killed in the engagement against the Jem'Hadar, it is uncertain whether Starfleet Academy continued the practice of rewarding cadets in such a way, or whether it was discontinued and other academic rewards were put in place. In the non-canon Activision game Star Trek: Invasion, the Valkyrie pilots of the USS Typhon, including the main character Ryan Cooper, were Red Squad members. Set after the Dominion war, these pilots would have attended the academy after the Valiant's destruction.
Info was found at memory-alpha