Introduction to Database Management Systems (DBMS) (CSTP 1201)

In this course students will learn how to manage SQL database systems, including performing basic database administration. Students will learn how to configure a database to support different applications and to perform tasks such as creating users and database schema, applying constraints, setting up access control, assigning memory, defining storage structures and manipulating data. Since database administration does not end after the database is created, students will learn the importance of backup and recovery strategy. Students will become familiar with fundamental concepts in the field such as transnational operations, ACID property, backup and redundancy, data integrity, various database roles (database admin, database programmer, database designer), database normal forms, join operations, and how to perform queries.

Course code: CSTP 1201

Credits: 4.0

Tuition: $0^*

Length: 80 hours

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

Prerequisites

CSTP 1105 Introduction to Programming

Schedule†

CSTP 1201 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
45375	Nezami, Reza	January 6, 2020 to April 6, 2020	Mon \| 8:30 a.m - 3:45 p.m	Nezami, Reza
75620	Nezami, Reza	September 10, 2020 to December 17, 2020	Thu \| 7:30 a.m - 11:30 a.m	Nezami, Reza
46149		January 4, 2021 to April 12, 2021	Mon \| 7:30 a.m - 11:30 a.m
46149 VCC Downtown Campus			Mon \| 12:30 p.m - 4: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-04-01 08:30:00.0	Mon	06-Apr-2020	2020-04-01 15:45:00.0	50330975	45375	6	202040	N	0	CSTP121	0830	DTN	2020-04-06 00:00:00.0	1550	145	B	2020-01-06 00:00:00.0	06-Jan-2020	Lab
2	2020-04-01 07:30:00.0	Thu	17-Dec-2020	2020-04-01 11:30:00.0	50330975	75620	17	202070	N	0	CSTP121	0730	DTN	2020-12-17 00:00:00.0	1129	[empty string]	L	2020-09-10 00:00:00.0	10-Sep-2020	Lecture
3	2020-04-01 12:30:00.0	Thu	17-Dec-2020	2020-04-01 16:30:00.0	50330975	75620	17	202070	N	0	CSTP121	1230	DTN	2020-12-17 00:00:00.0	1629	[empty string]	L	2020-11-19 00:00:00.0	19-Nov-2020	Lecture
4	2020-04-01 07:30:00.0	Mon	12-Apr-2021	2020-04-01 11:30:00.0	[empty string]	46149	24	202140	N	0	CSTP121	0730	DTN	2021-04-12 00:00:00.0	1129	[empty string]	B	2021-01-04 00:00:00.0	04-Jan-2021	Lab
5	2020-04-01 12:30:00.0	Mon	01-Feb-2021	2020-04-01 16:30:00.0	[empty string]	46149	24	202140	N	0	CSTP121	1230	DTN	2021-02-01 00:00:00.0	1629	[empty string]	B	2021-01-04 00:00:00.0	04-Jan-2021	Lab
6	2020-04-01 07:30:00.0	Tue	23-Mar-2021	2020-04-01 11:30:00.0	[empty string]	46149	24	202140	N	0	CSTP121	0730	DTN	2021-03-23 00:00:00.0	1129	[empty string]	B	2021-03-16 00:00:00.0	16-Mar-2021	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 = '1201' 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	45375
2	CSTP121

struct
1	75620
2	CSTP121

struct
1	75620
2	CSTP121

struct
1	46149
2	CSTP121

struct
1	46149
2	CSTP121

struct
1	46149
2	CSTP121

array

struct
1	CSTP
2	45375 75620 46149
3	CSTP121

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.

Introduction to Database Management Systems (DBMS) (CSTP 1201)

Prerequisites

Schedule†

CSTP 1201 schedule for programs:

Additional Information

Contact us