Learn more about the academic programs we are delivering in Summer 2024. If you have any questions about part-time studies, please contact us.

 

 

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   

Part-time Studies courses are being offered in either of the following four formats: Online, Flexible, In-person, Hybrid. 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.

DBS311
Advanced Database Services
Availability
 

Prerequisite(s):

DBS211

This course builds on knowledge gained in previous courses and introduces the student to advanced data management concepts and advanced database application programming. Students will explore non-traditional databases, including non-relational types.




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 and AI
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 as well as through AI techniques and approaches. This course introduces students to big data and AI concepts. Key concepts covered in this course include the Hybrid Data Warehouse, Logical Data Warehouse, Data Lakehouse and Quantum Computing. This course provides hands on experience with Open Source capabilities such as Spark; an introduction to programming languages such as Python and R as well as analytic techniques such as Machine Learning and Text Analytics. Working with non-traditional relational data such as semi-structured and unstructured data such as text, JSON and social data is included in the course. Performing analytics using capabilities such as SQL, SQL over Hadoop and DBaaS sources is covered.




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.

Please note: DBS311 has replaced DBS 301. Student that have already taken DBS 301 are not required to take DBS311.

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 sent to you electronically.

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@senecapolytechnic.ca
416-764-0977


Glen Steins
Part-time Coordinator
Glen.Steins@senecapolytechnic.ca
437-312-0354


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