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