Foot and Nail Treatment (ESTH 1120)

This course introduces students to foot and nail treatments, diseases and disorders, nail shapes, the use of specific products, nail polish application, massage technique, utilizing lymphatic drainage and reflexology movements. This course also includes product knowledge and prescription home care. This course is part of the full-time Skin & Body Treatment Program.

Course code: ESTH 1120

Credits: 3.0

Tuition: $0^*

Length: 90 hours

Course outline: https://www.vcc.ca/deptUploads/course-outlines/ESTH-1120.pdf

Schedule†

ESTH 1120 schedule for programs:

ESTH

Course dates and times may vary throughout the term. Select the CRN number below to see a full schedule.

CRN #	Instructor	Dates	Day/Time	Instructor
75673	Crump, Tyra	06-Feb-2020 to 22-Feb-2020	Thu, Fri, Sat \| 9:00 a.m - 6:00 p.m	Crump, Tyra
43449	Hogan, Paula	09-Mar-2020 to 25-Mar-2020	Mon, Tue, Wed \| 9:00 a.m - 6:00 p.m	Hogan, Paula
43458	McDonald, Pamela	12-Mar-2020 to 28-Mar-2020	Thu, Fri, Sat \| 9:00 a.m - 6:00 p.m	McDonald, Pamela
43458 VCC Downtown Campus

query

RESULTSET

query
	BEGIN_TIME_ROUND	DAY_OF_WEEK	END_DATE	END_TIME_ROUND	SIRASGN_PIDM	SSBSECT_CRN	SSBSECT_SEATS_AVAIL	SSBSECT_TERM_CODE	SSBSECT_VOICE_AVAIL	SSBSECT_WAIT_COUNT	SSRBLCK_BLCK_CODE	SSRMEET_BEGIN_TIME	SSRMEET_BLDG_CODE	SSRMEET_END_DATE	SSRMEET_END_TIME	SSRMEET_ROOM_CODE	SSRMEET_SCHD_CODE	SSRMEET_START_DATE	START_DATE	STVSCHD_DESC
1	2019-12-01 09:00:00.0	Thu Fri Sat	22-Feb-2020	2019-12-01 18:00:00.0	50266411	75673	1	201970	N	0	ESTH11111	0900	DTN	2020-02-22 00:00:00.0	1759	201	L	2020-02-06 00:00:00.0	06-Feb-2020	Lecture
2	2019-12-01 09:00:00.0	Mon Tue Wed	25-Mar-2020	2019-12-01 18:00:00.0	50170718	43449	0	202040	N	0	ESTH111	0900	DTN	2020-03-25 00:00:00.0	1759	201	L	2020-03-09 00:00:00.0	09-Mar-2020	Lecture
3	2019-12-01 09:00:00.0	Thu Fri Sat	28-Mar-2020	2019-12-01 18:00:00.0	50282568	43458	0	202040	N	0	ESTH112	0900	DTN	2020-03-28 00:00:00.0	1759	201	L	2020-03-12 00:00:00.0	12-Mar-2020	Lecture
4	2019-12-01 09:00:00.0	Thu Fri Sat	28-Mar-2020	2019-12-01 18:00:00.0	50282568	43458	0	202040	N	0	ESTH112	0900	DTN	2020-03-28 00:00:00.0	1759	205B	L	2020-03-12 00:00:00.0	12-Mar-2020	Lecture

CACHED

false

EXECUTIONTIME

SQL

SELECT ssbsect_crn, ssbsect_term_code, ssrblck_blck_code, ssrmeet_start_date, ssrmeet_end_date, TO_CHAR(ssrmeet_start_date, 'DD-Mon-YYYY') AS start_date, TO_CHAR(ssrmeet_end_date, 'DD-Mon-YYYY') AS end_date, ssrmeet_begin_time, ssrmeet_end_time, TRUNC( TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_begin_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as begin_time_round, TRUNC( TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) + ( ROUND( (TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS') - TRUNC(TO_DATE(CONCAT(ssrmeet_end_time,'00'),'HH24:MI:SS')) ) * 96 ) / 96) as end_time_round, DECODE(ssrmeet_sun_day, 'U', 'Sun ', '') || DECODE(ssrmeet_mon_day, 'M', 'Mon ', '') || DECODE(ssrmeet_tue_day, 'T', 'Tue ', '') || DECODE(ssrmeet_wed_day, 'W', 'Wed ', '') || DECODE(ssrmeet_thu_day, 'R', 'Thu ', '') || DECODE(ssrmeet_fri_day, 'F', 'Fri ', '') || DECODE(ssrmeet_sat_day, 'S', 'Sat ','') AS day_of_week, ssrmeet_bldg_code, ssrmeet_room_code, sirasgn_pidm, ssbsect_seats_avail, ssbsect_wait_count, ssbsect_voice_avail, ssrmeet_schd_code, stvschd_desc FROM ssbsect INNER JOIN stvschd ON ssbsect_schd_code = stvschd_code AND ssbsect_schd_code NOT IN ('PLA', 'CL', 'CB', 'CI', 'T') LEFT OUTER JOIN ssrblck ON ssrblck_term_code = ssbsect_term_code AND ssrblck_crn = ssbsect_crn LEFT OUTER JOIN ssrmeet ON ssrmeet_term_code = ssbsect_term_code AND ssrmeet_crn = ssbsect_crn LEFT OUTER JOIN sirasgn ON sirasgn_crn = ssbsect_crn AND sirasgn_term_code = ssbsect_term_code WHERE ssbsect.ssbsect_subj_code = 'ESTH' AND ssbsect.ssbsect_crse_numb = '1120' AND ssbsect.ssbsect_term_code >= 201970 AND ssbsect.ssbsect_ssts_code = 'A' AND ssbsect.ssbsect_ptrm_end_date > sysdate-1 ORDER BY ssrmeet_start_date, ssrmeet_begin_time, ssbsect_crn

array

struct
1	75673
2	ESTH11111

struct
1	43449
2	ESTH111

struct
1	43458
2	ESTH112

struct
1	43458
2	ESTH112

array

struct
1	ESTH
2	75673 43449 43458
3	ESTH11111

Contact us

Frequently asked questions

Ask a question

Book an appointment with an advisor

fill out an online form
Call 604.871.7000, option 2

INTERNATIONAL STUDENTS

Visit VCC International for contact information.

* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

Foot and Nail Treatment (ESTH 1120)

Schedule†

ESTH 1120 schedule for programs:

Additional Information

Contact us