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

The demand for database professionals in the industry is increasing. Along with knowledge of databases (like Oracle TM), it is now becoming increasingly important to be able to integrate it with Java. This certificate will give students the opportunity to focus on both of these skills. This certificate is targeted towards:

  1. Existing programmers who have programmed in other languages, but now want to supplement their skill set with Oracle TM Database and Java.
  2. Existing Business Analysts who need to become more technically oriented.
  3. Students who want to move towards a career in Database/Java with a focus on Oracle TM.

Information Session

Students are invited to attend an information session.

Entry Requirements

Proficiency in English required.

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

Core 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.

JAC444
Introduction to Java for C++ Programmers
Availability
 

Prerequisite(s):

OOP345 or JAC333

This course will get students hands on practice using Java as an object-oriented language. Topics studied will include OO concepts in Java, threads, exceptions, GUI programming using Graphics 2D/Swing, input/output, networking, client-server programming, applets, servlets and database access via JDBC.




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.

PRO684
E-Commerce Fundamentals using Java Web Application
Availability
 

Prerequisite(s):

BPJ 444/JAC444 and WEB222

This course is designed to introduce the student to build end-to-end web applications using HTML/JSP/Servlet, with an emphasis on server-side Java application development.




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

PRO687
JEE Application Development - Open Source Tech.
Availability
 

Prerequisite(s):

PRO684 and WEB222

Students learn the architecture of the open source technologies as Struts and Hibernate. Students learn how to set up an extensible development environment for J2EE AJAX techniques for creating interactive web applications, Web Struts based Applications and persist the data using Hibernate. The course covers in detail most aspects of the implementation with regards to reusability, scalability, internationalization and maintainability of the application. AJAX is the methodology of getting the web pages to feel more responsive by exchanging small amounts of data with the server behind the scenes, which will lead to a more flexible and reliable web application. The Struts framework has the acceptance of the industry and unveils a large usability along many J2EE applications with large cover for financial, banking, industrial and manufacturing sectors. The framework wants to be extensible and flexible in order to be used on different applications with no pre-requirements except the J2EE environment. Hibernate is gaining a lots of popularity and lets you develop persistent classes following common Java idiom - including association, inheritance, polymorphism, composition and the Java collections framework. Hibernate has been used to shape the new EJB entity bean portion of specifications.




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

PRO689
Project Development using Java Persistence Appl.
Availability
 

Prerequisite(s):

PRO684 and DBS301

Implementing web applications using Module View Controller Architecture (MVC) allows java developers to separate the business layer from the presentation and the control layers. This business layer is the interface with the database of the system, so managing the database persistency issues is very much required. Studying the importance of the persistency layer with the most used architectures and frameworks in java world is essential to have a complete web application design and implementation. Using Hibernate 3 and Java persistence APIs (EBJ3) as the famous persistency layer frameworks is a big strength in building web applications. In this course, different architectures will be viewed and studied, approaches to persistency will be investigated and different frameworks will be viewed. Comparison among these frameworks will be done. Also, in this course a project will be designed and implemented using web application (Experience Sun Glassfish Enterprise Servers) and Hibernate 3 as a persistency layer with the covering of all the issues database developers have to deal with.




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

WSA500
Web Services Architecture
Availability
 

Prerequisite(s):

JAC444 or BPJ 444

The use of Web Services is expanding rapidly as the need for application-to-application communication and interoperability grows, making them available across the internet. The course will introduce students to a set of communication technologies as defined by Web Service standards. This course specifically address the skills needed to understand basic concepts like XML, WSDL, UDDI, SOAP.




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

EJB605
EJB Architecture and J2EE
Availability
 

Prerequisite(s):

JAC444 and PRO684

This course will emphasize the development of re-usable JEE components and also provide comprehensive coverage of EJB architecture.

 




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

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

Credit for Prior Learning

Prior Learning Assessment

Earn college credits for what you already know.
Prior Learning Assessment is a method of assessing and recognizing learning that is equal to college level learning, but has been gained outside a traditional classroom (through work experience, volunteering, outside study, etc.). If you can prove that the knowledge you have gained meets the outcomes of a Seneca course, then credit will be awarded.

How does the PLA process work?
Prior Learning is demonstrated through a "challenge" process. The process measures learning through a variety of methods which may include tests, portfolio assessment, interviews, demonstrations, essays, and work samples. The method used will be determined in consultation with a Program Coordinator.
For more information and to determine if you are eligible for PLA, please call the Program Coordinator.

The process may take from 6 to 8 weeks.

Note: Not all courses can be challenged. For more information go to PLA website or contact your Program Coordinator.

Transfer Credit

Many students who enter Seneca Polytechnic will have earned academic credits in post-secondary educational institutions which they may be able to apply toward completion of a Seneca College program.

Requests for Transfer Credit must be for a specific course and must be accompanied by an official transcript and course outline. A minimum grade of "C" (60 percent) is generally required for a course to be considered for Transfer Credit.

Download a Transfer Credit Request form. An official copy of your transcript and applicable detailed course outlines should be attached and submitted. Please note it may take 4 to 6 weeks for a Transfer Credit decision.

More Information

Please visit the Office of the Registrar.

Graduation/Convocation

When you meet all program requirements and become eligible for a certificate, diploma, or degree, you must inform the Registrar by completing a Graduation Application form and paying the graduation and alumni fee. Certificates, diplomas, and applied degrees are issued twice a year in the Fall (October), Spring (June) and Winter (February).

For further information including deadlines and fees, please visit the Convocation website or contact the Convocation Office at theservicehub@senecapolytechnic.ca.

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 Program Coordinator
Glen.Steins@senecapolytechnic.ca
437-312-0354


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





Information Session

Students are invited to attend an information session.