연세대 IT 강의실

진로강좌

SELECT a.lid, a.lecName, a.lecName2, a.image, a.costs, a.lectureMent, b1.courseName as course1Name, b2.courseName as course2Name, c.codeName as themeName FROM ssVOD_lecture a INNER JOIN ssVOD_course b ON b.cid = a.cid INNER JOIN ssVOD_course b1 ON b1.cid = b.c1id LEFT OUTER JOIN ssVOD_course b2 ON b2.cid = b.c2id LEFT OUTER JOIN ssCodes c ON c.category = 'theme' AND c.code = a.theme WHERE a.onPublic = 'Y' AND a.lid IN (SELECT lid FROM ssVOD_lecture_shop WHERE shopId = 'yonsei') AND b.c1id = 2 ORDER BY b1.serial ASC, b2.serial ASC, a.serial ASC, a.lid DESC

진로

진로설계1
진로 인식의 중요성

진로

진로설계2
자기탐색 및 자기분석 방법론