Loading...

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   


Curriculum

Required Courses

DBS201
Introduction to Database Design and SQL
Availability
 

Prerequisite(s):

Experience with operating systems.

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.

Elective (Select 2)

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.

DBT544
DB2
Availability
 

Prerequisite(s):

IBC233 and DBS201

This course provides an in-depth look at DB2 Universal Database for the AS/400, the most widely used multi-user relational database in the world. This course will start with a brief look at the native interface which includes logical, physical and field reference files and then focus on the SQL/400 interface which includes Data Definition Language, Data Manipulation Language, Embedded SQL/400, Stored Procedures and the SQL Procedure language, Journaling and Commitment Control and ODBC. Advanced topics include Database Constraints, File Overrides, Trigger Programs, Database security, Backup and Recovery, the Universal Database and Operations Navigator.




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.

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 mailed to you.

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 Computer Studies coordinator for help in choosing courses. To obtain waivers of prerequisites, and apply for advanced standings, please call 416-491-5050, ext 33025.

Program Contacts

Debbie Hoover
Program Assistant
Debbie.Hoover@senecacollege.ca
416-491-5050 ext.22921


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


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