Overview

Organizations today require a stable and secure database for their business solutions. This program is targeted to individuals with basic operating system knowledge seeking to build their skill set in the areas of database design and development, support and testing, and troubleshooting. Students successfully completing this 5-course Recognition of Achievement program will have a solid foundation in the design and implementation of database applications on a variety of today's most commonly used platforms (e.g. MS SQL, Oracle, DB2).

Filter Classes: In Class     Online     Correspondence     Hybrid     Availability   

Due to COVID-19, all Part-time Studies courses are being offered online until further notice, in one of the following two formats: online virtual classroom and online self-directed. Click Availability below to see current offerings.

Curriculum

Required Courses

DBS211
Introduction to Database Systems
Availability
 

Prerequisite(s):

IPC144 or ULI101

This subject introduces students to data management concepts, database systems and database application programming. Students learn to represent information with a relational database model and manipulate data with an interactive query language. Students will model data using Entity Relationship Diagrams.

This course replaces DBS 201. Students that have previously taken DBS 201 are not required to take this course.




Loading availability...
If the availability does not load please click here.

DBS301
Database Design II and SQL Using Oracle
Availability
 

Prerequisite(s):

DBS211 or familiarity with database concepts

This course continues the study of database design and SQL begun in DBS201. Students will learn the entire set of SQL statements using Oracle's DBMS, and also learn Oracle's SQL*Plus commands.




Loading availability...
If the availability does not load please click here.

DBS501
Stored Procedures Using Oracles PL/SQL
Availability
 

Prerequisite(s):

DBS301

This course uses Oracle's PL/SQL language to code PL/SQL blocks, procedures, functions, packages, and database triggers for applications developed using Oracle relational databases.




Loading availability...
If the availability does not load please click here.

Elective (Select 2)

BDA400
Introduction to Big Data
Availability
 

The data warehousing and analytic marketplace continues to be one of the fastest growing areas of technology and applications. Much of this growth is fueled by applications starting to leverage new types of data to gain new insights into their industry, competition and customers. This course introduces students to big data concepts and explains key concepts such as the Hybrid Data Warehouse, logical Data Warehouse and Data Lakes. This course provides hands on experience with the following: Open Source capabilities such as Hadoop and Spark; How to work with non-traditional data such as semi-structured and unstructured data such as text, JSON and social data; Performing analytics using capabilities such as SQL over Hadoop and MapReduce.




Loading availability...
If the availability does not load please click here.

DBA625
Database Administration
Availability
 

Prerequisite(s):

DBS301

This course will review the purpose and responsibilities of the Database Administrator. The students will learn how the DBMS manages the data and controls such as recovery, locking, transaction logging and performance tuning. Through hands-on Database Administration students will practice much of the theory presented.




Loading availability...
If the availability does not load please click here.

DBM635
Database Administration using SQL Server
Availability
 

Prerequisite(s):

DBS301

This course reviews the role of the Database Administrator using Microsoft's SQL Server in a Windows environment. The features, utilities and operations of a Database Management System (DBMS) are examined. Through hands on Database Administration, students will learn how the DBMS manages the data and controls such as recovery, backup, and security for a SQL Server database.




Loading availability...
If the availability does not load please click here.

DBW624
Introduction to Datawarehousing
Availability
 

Prerequisite(s):

DBS301

Using Microsoft's Analysis Services, this course introduces students to DataWarehousing design and development. Star schema fact tables and dimension tables will be examined. Multidimensional databases are emphasized as the students build on their database knowledge. A datawarehouse will be developed and modified.




Loading availability...
If the availability does not load please click here.

Completion

Recognition of Achievement

Upon successful completion of the program requirements, please submit a Request for Recognition of Achievement Form to the Faculty of Continuing Education and Training. There is no cost for this and your Recognition of Achievement will be mailed to you.

Facilities

Students will use networked mid-range and PC computer platforms to access today's leading operating systems (Windows, .Net, UNIX and OS/400 on the AS/400). The College uses SFTP and SSH access modes for some courses to enable work to be done from home. Most programming and networking courses and labs are located at Seneca@York Campus. The programming course students are expected to log 20-30 hours of lab time in addition to classroom time. The lab hours are extensive. Please check with the learning commons or Open Lab for their hours of operation. During evening hours, Continuing Education students have priority over day students; until 7 p.m. on weekdays, full-time students have priority, but Continuing Education students may use facilities that are not occupied. On weekends, Continuing Education and full-time students have equal right to the use of the labs. Your registration receipt is your passport to the lab, although AS/400, UNIX and other users may also require account codes and passwords provided by their instructor. In some courses, students will be required to purchase removable hard drive kits or other hardware. In most courses students will require a USB Drive for storing programming assignments.

Program Changes

The Computer Studies credit program undergoes constant revision to ensure its relevance in today's changing job market. Some courses have been thoroughly revised to reflect technological change. Certain courses and codes may change without prior notice.

Help!

On scheduled Program Information evenings, or by special appointment, you can meet with a Computer Studies coordinator for help in choosing courses. To obtain waivers of prerequisites, and apply for transfer credits, please call 416-491-5050, ext 33025.

Program Contacts

Rasika De Silva
Program Assistant
Rasika.DeSilva@senecacollege.ca
416-491-5050 ext.77290


Glen Steins
Part-time Coordinator
Glen.Steins@senecacollege.ca
416-491-5050 ext.33025


For more information about this program, fill out the following form.