Advanced Internet Programming & Web Applications (CSTP 2107)

In this course students will learn about advanced web technologies which provide the possibility of building fully dynamic web-centric applications. This is an intensive, hands-on, project-based, team-oriented course in which students in a team of 2-4 become familiar with "full stack" web development. This course introduces new database models such as NoSQL or MongoDB in the context of developing an end-to-end web application development using MVC architecture. The technologies used focus on a current modern stack, such as MEAN ( MongoDB, Express.js, AngularJS), LAMP (Linux, Apache, MySQL, Python), and others. This course requires students to learn to program in Javascript in various environments. By the end of this course, students will be able to participate in the development of secure data-driven business web applications in various domains.

Course code: CSTP 2107

Credits: 4.0

Tuition: $0^*

Length: 80 hours

Course outline: https://www.vcc.ca/cfm-files/course-outline.cfm?subject=CSTP&number=2107

Prerequisites

CSTP 1206 Introduction to Internet Programming & Web Applications
CSTP 1304 User Interface Design

Schedule†

CSTP 2107 schedule for programs:

CSTP

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
73490		September 14, 2020 to December 15, 2020	Mon \| 5:30 p.m - 9:30 p.m

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	2020-03-01 17:30:00.0	Mon	14-Dec-2020	2020-03-01 21:30:00.0	[empty string]	73490	24	202070	N	0	CSTP211	1730	DTN	2020-12-14 00:00:00.0	2129	[empty string]	B	2020-09-14 00:00:00.0	14-Sep-2020	Lab
2	2020-03-01 17:30:00.0	Tue	15-Dec-2020	2020-03-01 21:30:00.0	[empty string]	73490	24	202070	N	0	CSTP211	1730	DTN	2020-12-15 00:00:00.0	2129	[empty string]	B	2020-11-03 00:00:00.0	03-Nov-2020	Lab

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 = 'CSTP' AND ssbsect.ssbsect_crse_numb = '2107' AND ssbsect.ssbsect_term_code >= 202040 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	73490
2	CSTP211

struct
1	73490
2	CSTP211

array

struct
1	CSTP CSTP
2	73490
3	CSTP211

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.

Advanced Internet Programming & Web Applications (CSTP 2107)

Prerequisites

Schedule†

CSTP 2107 schedule for programs:

Additional Information

Contact us