There is no versus here - it's like apples versus the crab nebula. They're not technologies in competition.
Anyway, definitely learn SQL. If you get a nice corp job developing, expect the DBA to ensure you never ever get to use any of it, but you should know it anyway.
LINQ is new, and it's more or less a way to deal with data sets in .net languages more like you would in a proper database.