David Moyes has been named as the new coach of Spanish side Real Sociedad - seven months after he was sacked as Manchester United manager.