Database Option Full-time/Cooperative Education Diploma 550kdiplt

Overview

Note: The September 2014 and January 2015 intakes are now closed for new applications.

Applications for advanced placement and readmission may still be submitted.

The September 2015 intake will begin accepting applications on November 1st, 2014 (or next business day).

Please check our list of programs that may have space available or access our program database for a complete list of BCIT programs.

The Computer Systems Technology (CST) Diploma program is an established and widely recognized credential that prepares graduates for software development and computer-related careers. The Computer Systems Technology program was developed with extensive industry consultation and continues to be updated with industry input.

The program combines the foundation and theory of computing systems with hands-on training using the same teamwork approaches practised in industry. Students are actively involved in industry-based projects gaining valuable experience in real user environments. Strong communication skills and the ability to analyze, design and develop software solutions are hallmarks of our graduates.

In the second year of the program, in addition to the common academic core, CST students choose from specialty options to learn more about specific computing areas in depth. The options currently offered are:

The Database option specializes in the design and development of database-driven transaction processing and business intelligence applications, covering both database concepts and practical implementation. Include topics on advanced queries, logical and physical database design, access methods and query optimization, transaction and concurrency control, database administration, trigger, function and stored procedure programming, dimensional modelling and analytical processing, and web-based application development with C# and Java. Practical platforms include database systems, tools and technologies from Microsoft and Oracle.

Diploma graduates may pursue a two-year BCIT Bachelor of Technology in Computer Systems on a part-time or full-time basis.

Program Entry

Entrance requirements

This program is open to applications beginning:

  • November 1st* for the Fall (September) intake
  • June 1st* for the Winter (January) intake

*or next business day

Applicants must meet all entrance requirements and will be accepted on a first qualified basis as long as space remains.

  • Two years of education in English in an English-speaking country with one of the following:
    • English 12 (67%) or
    • Three credits of post-secondary English, Humanities or Social Sciences (67%) from a recognized institution

    What if I don’t meet these English requirements?

  • Math: one of the following:
    • Principles of Mathematics 12 (67%) or
    • Applications of Mathematics 12 (73%) or
    • Pre-Calculus 12 (67%)

Advanced Placement

If you have completed a degree, a diploma or a substantial amount of course work in a specific discipline, you may qualify for advanced placement into a full-time program. If approved, you would be awarded credit for an entire level of a program and would begin your studies at the second or third level. When applying for advanced placement, you must submit the Course-by-Course Self-Assessment form [PDF] with your online application.

Apply early. Assessment of applications containing overseas documents may take up to three or four months.

Apply to program

The September 2014 and January 2015 intakes are now closed for new applications.

Applications for advanced placement and readmission may still be submitted.

The September 2015 intake will begin accepting applications on November 1st, 2014 (or next business day).

Apply directly to the Computer Systems Technology Diploma program. This program shares a common first year of core subjects. In the second year, students choose a specialization.

Note: Do not specify an option/specialization at the time of application.

BCIT accepts only complete applications. In order to apply:

  • Include proof of meeting all entrance requirements prior to submission
  • Convert all transcripts and supporting documents to PDF files
  • Have a credit card ready to pay the application fee
Apply Now

You can check the status of your application online at any time using the Student Information System.

Scheduled intakes

September and January each year.

Technology entry

The Technology Entry (TE) program is a full-time, day school program which provides academic upgrading to students wishing to enrol in Computing, Engineering, Electronic and Health Sciences programs at BCIT.

The TE program provides courses in chemistry, communication, mathematics and physics that meet program prerequisites for selected programs at BCIT. The program also includes an introductory course in computer applications and a learning skills course. The program is supportive to those who require English-language training.

myCommunication

Within 3 weeks of applying to a program, you will be sent a letter in the mail confirming receipt of your application. The letter will identify your student number, BCIT e-mail address and instructions on how to login to your myBCIT account.

All official BCIT correspondence will be sent to your myBCIT account. Check myCommunication often during the application process and throughout your studies at BCIT.

You can expect to receive communication concerning the status of your application within 4 weeks.

Costs & Supplies

Tuition fees

Please see the Fees, Payments and Refunds section of the website for more information on full-time tuition fees.

Books and supplies

Books are expected to cost $500 to $800 per term.
(General estimated cost, and subject to change)

In addition, it is strongly recommended that all students in the program should own a computer suitable to run software used in their courses. Costs for such a computer will vary depending on configuration chosen but will likely range from approximately $1000 to $2000.

Financial assistance

Financial assistance may be available for this program. For more information, please contact Student Financial Aid and Awards.

Courses

Program matrix

Level 1 Credits
  BUSA 2720 Business in a Networked Economy 4.0
  COMM 1116 Business Communications 1 4.0
  COMP 1100 CST Program Fundamentals 1.0
  COMP 1111 Essential Skills for Computing 4.0
  COMP 1113 Applied Mathematics 4.0
  COMP 1510 Programming Methods 7.0
  COMP 1536 Introduction to Web Development 4.0
 
Level 2 Credits
  COMM 2216 Business Communications 2 4.0
  COMP 2121 Discrete Mathematics 4.0
  COMP 2510 Procedural Programming in C 5.0
  COMP 2526 Object-Oriented Programming with Java 4.0
  COMP 2714 Relational Database Systems 5.0
  COMP 2721 Computer Organization/Architecture 4.0
  COMP 2910 Projects** 6.0
 
Level 3 Credits
  COMP 3512 Object Oriented Programming in C++ 6.0
  COMP 3711 Object Oriented Analysis and Design 4.0
  COMP 3721 Introduction to Data Communications 4.0
  COMP 3760 Algorithm Analysis and Design 4.0
  COMP 3900 Computer Projects Practicum 1 5.0
  COMP 3920 Database Systems 1 5.0
  COMP 4925 Selected Topics in Database Systems 5.0
 
Level 4 Credits
  BLAW 3600 Computers and the Law 4.0
  COMP 3717 Mobile Application Development with Android 4.0
  COMP 4100 Career Preparation* ** 2.0
  COMP 4560 Computer Graphics for Computer Systems Technology 4.0
  COMP 4711 Introduction to Internet Software Development 3.0
  COMP 4735 Operating Systems 5.0
  COMP 4900 Computer Projects Practicum 2* 5.0
  COMP 4921 Database Systems 2 5.0
 
Co-op Work Term Courses (Optional)
to be completed after Level 2 and prior to Level 4
Credits
  COMP 2990 Cooperative Education Workterm 1 16.0
  COMP 3990 Cooperative Education Workterm 2 16.0

All courses are 15 weeks in duration except where otherwise noted.

* denotes a five-week course, delivered from late April through to the end of May.

** COMP 2910 and COMP 4100 are optional for students who successfully complete one term of co-op education.

 
Total Credits: 125.0

Transfer credit

Do you have credits from another BC/Yukon post-secondary school? Do you want to know if they transfer to courses here at BCIT? Check out BCIT's Transfer Equivalency Database to find out.

Program Details

The CST Diploma is two-year full-time program. After completing a common first year (levels 1 and 2), second-year CST students choose from one of six specialty diploma options to learn more about specific computing areas in depth.

The Database option specializes in the design and development of database-driven transaction processing and business intelligence applications, covering both database concepts and practical implementation. Include topics on advanced queries, logical and physical database design, access methods and query optimization, transaction and concurrency control, database administration, trigger, function and stored procedure programming, dimensional modelling and analytical processing, and web-based application development with C# and Java. Practical platforms include database systems, tools and technologies from Microsoft and Oracle.

Industry Sponsored Student Projects

The Industry Sponsored Student Projects program (ISSP) provides students with real-life experience by working on IT or software projects directly from industry. Students work in teams or individually with an industry sponsor, proceeding through the development life-cycle to develop a complete IT or software solution.

Program length

Two years, full-time beginning in September and January of each year. The September term is 15 weeks in length. The January term is also 15 weeks in length, followed by a five week projects term.

In order to be eligible for graduation, students must complete the diploma program requirements within three years of entering the program.

Accreditation

The Computer Systems Technology two-year diploma program has been accredited by the Canadian Information Processing Society (CIPS). Subsequently, a CST graduate may receive an ISP (Information Systems Professional) designation after five years of relevant work experience.

Continue your education

Degree Completion

Graduates of the Computer Systems Technology Diploma program may pursue a BCIT Bachelor of Technology in Computer Systems degree. The degree program is an extension of the diploma program, providing the competitive advantage for students to learn advanced technological and management skills to help graduates be better positioned in the IT workplace.

Co-operative education

The optional co-op education component of the CST program provides students with substantial benefits in their IT career preparation, given that employers are more eager to hire graduates who have had some co-op experience. Students opting for co-op education are required to meet year one performance qualification criteria. Students will require a minimum of two four-month co-op terms to graduate with a co-op designation on their CST diploma. These two co-op terms could be back to back, or in two separate terms, but they must happen before the final term of the program.

Graduating & Jobs

Job opportunities

Computer Systems Technology Diploma graduates have a wide variety of career options in the IT industry. Many start their careers as entry level programmers and administrators, and then progress to positions such as programmer analysts, systems analysts, and IT project managers. Some students take the IT entrepreneurial path doing consulting, marketing or sales of computing hardware and software products.

Typical job titles for our graduates include software developers, application programmers, systems programmers, systems analysts, web developers, network (LAN/WAN) administrators, database administrators, software quality assurance personnel. After several years of working in the industry, students are employed as senior analysts, project managers, team leads, software architects, and senior consultants.

Graduate employment outcomes

The following link takes you to graduate outcome survey results containing mostly labour market results from the 2011-2013 BCIT Outcomes Surveys of 2010-2012 Graduates.
Note: The survey results will be displayed in a separate browser window. To view these results, you need to have the Adobe Acrobat Reader installed in your Web browser.

Faculty, Advisors & Staff

All general inquiries

Email: cst_enquiries@bcit.ca

Administration

Maureen Bell
Program Assistant
email: Maureen_Bell@bcit.ca
phone: 604-412-7489

Rob Neilson
Program Head, CST Diploma
email: Rob_Neilson@bcit.ca
phone: 604-432-8852

Bethany Edmunds
Program Head, CIT Diploma
email: Bethany_Edmunds@bcit.ca
phone: 604-432-8373

Steve Eccles
Dean
email: Steve_Eccles@bcit.ca
phone: 604-432-8920

Dean Hildebrand
Associate Dean
email: Dean_Hildebrand@bcit.ca
phone: 604-451-6867

Christen Yee
Operations Manager
email: Christen_Yee@bcit.ca
phone: 604-451-7190

Cynthia van Ginkel
Business Development Manager
email: Cynthia_van_Ginkel@bcit.ca
phone: 604-451-6834

Shebia Leung
Marketing Coordinator/Industry Liaison
email: Shebia_Leung@bcit.ca
phone: 604-453-4021

Full-time faculty

Abdulla, Aman, Option Head - Data Communications
Chau, Richard, Instructor
Elmasry, Medhat, Instructor
Fabiszewski, Steve, Instructor
Ferguson, Arron, Assistant Instructor (On Leave)
Gutica, Mirela, Option Head - Technical Programming
Harrison, Jason, Assistant Instructor (Partial Leave)
Hart, Richard, Instructor
Huang, ChiEn, Assistant Instructor
Hunter, Aaron, Instructor
Kult, Andrew, Instructor
Link, Bruce, Option Head - Information Systems
Lord, Trevor, Instructor
Noureddin, Borna, Instructor
McClain, Steven, Assistant Instructor
Wong-Orr, Carly, Instructor
Parry, Jim, Instructor
Randhawa, Tejinder, Option Head - Client/Server
Richards, Dennis, Option Head - Digital Processing
Smith, D'Arcy, Assistant Instructor (On-Leave)
Tang, Keith, Option Head - Database
Wei, Albert, Instructor
Yu, Benjamin, Instructor

Advisory committee

Ed Capko, (Chair), Microsoft Canada Co.
John Bean, IT Consultant
Beier Cai, HootSuite
Andre Brisson, Whitenoise Laboratories Inc.
Martin DesRosiers, Softlanding
Nelson Gillette, Telus, Vancouver
Jose Gonzales, WorkSafe BC
Tom Handley, Fujitsu Consulting
Al-Karim Kara, Land Title and Survey Authority of British Columbia
Ritzwan Kheraj, National Research Council - IRAP Pacific
Lawell Kiing, SAP
Gord Locke, Quartech Systems Ltd.
Derek Manky, Fortinet
Peter John McFarlane, Habanero Consulting Group
Tanya Miller, HootSuite
Noel Pullen, HootSuite
Donabel Santos, QueryWorks Solutions
Ted. S. Singh, Embedded Automation Inc.
Sarah Spratley, SAP Labs Canada
John Tolkamp, Ainsworth Engineering Canada LP
Dr. Carson Woo, Sauder School of Business

Contact Us

Questions or comments?

Please ensure you have reviewed the detailed information on this site, using the navigation to the right, before submitting the form below.

As well, if you meet any of the following criteria, please follow the links for more information, instead of sending the form:

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Freedom of Information and Protection of Privacy.

Subscribe

Sign up to receive updates, invitations to events, and information about BCIT and your program.

We promise not to spam you, we won’t share your personal information, and you can unsubscribe at any time.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Freedom of Information and Protection of Privacy.

How To Apply

Subscribe

Contact Us

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Search Programs

Info Session Video

View the latest Info Session on our Full-time Programs and hear the CST program head introduces the IT industry and the CST program. Students and graduates share their experience and success stories.