Learn more about the academic programs we are delivering in Winter 2025. If you have any questions about part-time studies, please contact us.
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 Certificate of Completion 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).
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.
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.
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.
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.
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.
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.
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.
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.
Please note: DBS311 has replaced DBS 301. Student that have already taken DBS 301 are not required to take DBS311.
Upon successful completion of the program requirements, please submit a Request for Certificate of Completion Form to the Faculty of Continuing Education and Training. There is no cost for this and your Certificate of Completion will be sent to you electronically.
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.
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.
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.
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.