You gain the knowledge of how to create any technology in Stargate, including SG-1, Atlantis, and Universe. You have the combined technological knowledge of the Ancients (aka Alterans & Ori), Asguard, Nox, and the Furlings just to name a few of the races this includes.
From intergalactic stargates, to ZPMs, to city ships, you can make it all. You can synthesize any Stargate universe specific materials needed in the construction of technology from the setting (Naquadah, Naquadria, Trinium, etc.).