Don`t worry too much, like with all things the first time you assemble, you are bound to come across a few problems when you build your first system.
People only gain such knowledge of how to fix the problems, through learning and experience after building many systems over a few years of Trial and error on what can go wrong.
The key thing is not to give up, keep a cool head, and not to panic.
But do everything in a set order of testing.
Let`s give you a bit of a help.
For power from the power supply.
1. Connect the main 24 pin Atx power block to your motherboard.
2. Looking at the board inside the case to the top left edge where the grey heat sink is at the top of it you will see a eight or four pin 12v Atx connector make sure from the Psu the eight or four pin 12v power block is connected to that connector of the board.
3. The 750 Ti version of Pci-e graphics card you have requires a six pin 12v Pci-e power connector from the Psu you have to be connected to the card.
You must make sure that all of the three power points above are connected from the PSU.
Memory.
A motherboard may not post, if you place the memory sticks in the wrong order of memory slots.
So you must consult the manual for the motherboard where it will tell you the exact places to place the memory modules
In the memory slots of the motherboard.
Cpu
There is a triangle symbol on the cpu it`s self and a triangle symbol on the cpu socket, make sure both triangles line up when seating the cpu into the cpu socket of the motherboard for the correct orientation.
Check all of the points above, with first time building the most common fault is missing a power connector because it is hidden or tucked away such as the eight or four pin 12v Atx connector like the Gigabyte GA-970A-DS3P board you have, and is often missed.
The eight or four pin 12v ATX block is important because if you do not have it connected.
Then what you get Lerp, is what you are seeing when trying to power the system up.
The fans spin, and led lights light up but you do not get a post or a screen image to the monitor if not connected from the psu to the motherboard.
Look at the picture of your board bellow to see the four pin 12v ATX power block on your motherboard and it`s location.
Black in colour four or eight pin to the top right next to the silver/ gray heat sink of the motherboard 12v ATX the main picture.
https://www.google.co.uk/search?q=Gigabyte+GA-970A-DS3P&source=lnms&tbm=isch&sa=X&ved=0ahUKEwiugIC43dHNAhVsCcAKHYIVDk4Q_AUICSgC&biw=2560&bih=1357#imgrc=iMdHhj1fo3dQaM%3A
Let me know if it works, if not then there are a few other things that may need looking at to get the system working ok Lerp15_2.