Loading...

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

New students are invited to attend an information session.

Entry Requirements

Proficiency in English required.


Filter Classes: In Class     Online     Correspondence     Hybrid     Availability   


Curriculum

Core Courses

DBS201
Introduction to Database Design and SQL
Availability
 

Prerequisite(s):

IPC144 OR ULI101

This course introduces students to relational database design and SQL (Structured Query Language) used with relational databases. Students will be introduced to a history of database management covering hierarchical, network, relational and object oriented models with a focus on the relational model and its operators. Students will be presented with a methodology for relational database design using Entity Relationship Diagrams and normalization of data. Students will be introduced to a subset of SQL using IBM's DB2 on the iSeries platform. An overview of the functions of the Database Management System (DBMS) and of a Database Administrator (DBA) will also be presented.




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

DBS301
Database Design II and SQL Using Oracle
Availability
 

Prerequisite(s):

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

JAC444
Introduction to Java for C++ Programmers
Availability
 

Prerequisite(s):

OOP344 or BAC344

In the short time since its introduction, Java has become one of the most popular programming languages of all time. Java has evolved from a web-based language to a robust language used in all manner of application development. This course will serve as a thorough introduction to 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):

BPJ444/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 BPJ444

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.

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 (Advanced Standing)

Many students who enter Seneca College 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 Degree and Credit Transfer Office.

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) and Spring (June).

For further information including deadlines and fees, please visit the  Convocation website or contact the Convocation Office at 416-491-5050 ext. 77461.

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

Sejal Ahir
Program Assistant
Sejal.Ahir@senecacollege.ca
416-491-5050 ext.77290


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


Robin Richardson
Program Coordinator
Robin.Richardson@senecacollege.ca
416-491-5050 ext.77273


Information Session

New students are invited to attend an information session.