Database Administration Specialty - Certificate (2018/19)

All students that apply to the College are required to pay the $30 application fee. The application fee for international students is $100. Trades Apprenticeship students who are new to the College pay a one-time application fee per trade.

For credit based courses there is an $11.50 student association fee for each course. The maximum student associate fee is 3 courses per semester for a total of $34.50. Some programs (Trades, Vocational & Health) are charged based on number of weeks they are in session. For these programs the student association fee is $2.30 per week of study (an 8 week program is charged $2.30 x 8 weeks = $18.40 fee).

69.00

Total Fees:

$99.00

*These prices are for domestic students and may not be 100% accurate. However, these estimates will give you an adequate idea of tuition and fees for our programs. These prices do not include textbook costs. All prices are subject to change.

Program Update

We are not accepting newapplications at this time.

The Computer Support Technician program continues in 2017-18 for students who are currently enrolled and completing their program.

For information on other program options in the this field, please contact an education advisor at 1 877 489-2687 ext. 3243 or by email studentservices@cotr.bc.ca.

Program Overview

Our 8 month Computer Support Technician certificate provides you with hands-on experience in computer hardware, application support, operating systems, and networks. Offered 100% online, this program prepares you for a career in the exciting and ever-changing field of computing and information technology. We also offer you the flexibility to earn your certificate on a full-time or part-time study basis.

Learn how to:

Install, configure, and troubleshoot hardware and software

Design and code a website (HTML, CSS, JavaScript & more)

Use tools and techniques for systems analysis and design

Implement, manage and troubleshoot security in network infrastructure

Install, configure and manage servers

Admission Requirements

Applications or Principles of Math 10 or Foundations of Math or Pre-Calculus 10 or Math 070 with 75% or higher; or by assessment. English 12 or equivalent or Communications 12 or equivalent with a minimum grade of 65% or by assessment

Students should possess at least a basic level of computer literacy. Some experience with computer programming would be an asset.

Transfer Information

Many of our programs and courses will allow you to transfer to other colleges and universities in Canada. You can also apply to get transfer credits from past courses that will go towards completing your program here at College of the Rockies.

Transfer Opportunities

If you would like to continue your studies our courses transfer to a wide number of Canadian colleges and universities. If you are transferring to a BC college or university visit the BC Transfer website to see if our courses transfer to that institution.

Course Outline for: Database Administration Specialty - Certificate

This course will begin to prepare students to support and repair personal computers by examining: basic lab safety concerns; the operation of the major parts of PCs; the operation of devices that are commonly attached to PCs; basic troubleshooting guidelines; and the use of utility software. For students interested in pursuing an A+ certification the material presented in the course will be helpful for the hardware component of the A+ certification exams.

This course will introduce students to the basic concepts of a computer's operating system. Students in the course will spend time on the installation and configuration of the Windows operating system. Students will also be introduced to how to modify as well as optimize the Windows environment.

This course provides focused knowledge and practical skills in public and customer relations. Topics include interpersonal relations; positive customer attitudes and awareness; image and professionalism; quality customer service; customer service policies and skills; special needs customers; dealing with difficult customers; conflict resolution and negotiation; public speaking; and media relations. Cultural diversity and sensitivity is emphasized throughout in meeting the needs of multi-cultural customers. Additional topics covered are User Support and Help Desk Functions. User support processes and activities are examined.

This course introduces Web Page Development. It covers HTML and XHTML code, standards and validation. Use of design elements (colour, images) and multimedia are discussed. The student will examine the multitude of browsers, standards and requirements for web surfers everywhere and will produce a final web page that can satisfy most (or all) browser types. In the second half of the course Cascading Style Sheets (CSS) are used extensively, while XML and JavaScript are both touched on briefly. Students will also explore current issues in Web Development and the future of Web Development.

This course covers a wide range of material about networking, from careers in networking to local area networks, wide area networks, protocols, topologies, transmission media and security. It not only introduces a variety of concepts but also discusses in-depth the most significant aspects of networking, such as the TCP/IP protocol suite. In addition to explaining concepts, the course uses a multitude of real world examples of networking issues from a professional’s standpoint, making it a practical preparation for the real world.

This course introduces the tools and techniques that are used for systems analysis and design. Both the traditional and the object-oriented approach to systems analysis and design will be used. This involves methods of analysis for assessing the information needs of an organization and determining how computer systems can provide problem solving help. Requirements modeling will include additional coverage on use cases and use case descriptions. System design involves specifying in detail how the components of systems should be implemented and should be based on an in-depth understanding of the business problem obtained from systems analysis. At all stages throughout this course, an iterative approach to systems development will be emphasized.

This course will provide a practical foundation of database design and implementation. The course will cover relational modeling, relational design, normalization, functional dependencies, requirements gathering to design a solid database and SQL. The SQL component will introduce the student to inserting, editing, deleting and retrieving data from the database. There will be a strong hands-on component that includes real-world examples and exercises.

In this course we will be using MS SSQL Server. This database is used by a large business base in all variety of industries. Microsoft SQL Server is a computer application used to create desktop, enterprise and web-based database systems. This course is designed for students who already understand relational database design and have a basic understanding of SQL. This course will further provide students with an in-depth understanding of designing, implementing and configuring MS SQL Server. This course helps prepare students to write the MS SQL Server implementation and design certification exam.
Topics include SQL Server architecture, use of indexes, DDL and DML, security, transactions, optimization and replication. Upon successful completion, students will be able to perform complex queries, use the transact SQL language, create stored procedures and triggers, administer system access and end-users and plan back-ups.

The main goal of this course is to provide students with a comprehensive understanding of Microsoft Windows Server and to prepare students to tackle server administration. The course focuses on selecting server and client hardware; installing and configuring a server; managing users, groups and computer accounts; setting up and managing network printing services; understanding the elements of Active Directory and security; managing and implementing backup and disaster recovery; administering web resources; monitoring and tuning a server; and troubleshooting problems. Another goal is to prepare students for the Windows Server certification exam.

The main goal of this course is to provide students with a comprehensive understanding of networking infrastructure supported by Microsoft Windows Server. The course focuses on implementing routing and implementing, managing, and maintaining dynamic host configuration protocol (DHCP), domain name system (DNS), file services, print services and securing data and transmissions using IP security (IPSec). Another goal is to prepare students for the Windows Server certification exam.