Related Studies

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:

Existing programmers who have programmed in other languages, but now want to supplement their
skill set with Oracle
TM Database and Java.

Existing Business Analysts who need to become more technically oriented.

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

Note: Remove filter(s) above to view all program curriculum requirements.

Curriculum

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.

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.

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.

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.

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.

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.

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

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.