Get some of the "Lick Library " DVDs (or video lessons) for some bands you like or the type of music you want to play.
They take you through songs a note at a time, showing the exact fingering & techniques.
It's up to you to keep practicing pieces and get your playing speed up to what it needs to be.
http://www.licklibrary.com/
This is an example of one of the lessons, showing how they take you through songs:
http://www.licklibrary.com/lessons/1175/diamond-head/am-i-evil-featuring-brian-tatler
And one of their instructors playing the full-speed demo of a piece from a lesson DVD:
https://www.youtube.com/watch?v=go4fNp6f9M4
(Skip in to about 2:30 in that for an idea of some of the slightly less common techniques they teach).
.