Reporting Systems and Database Development

Select start date and campus

Applying as a Canadian applicant

Domestic students should apply online or by phone at 1-888-892-2228.

Applying as an International applicant

International students should apply online.

Campus tours

Campus tours are one of the best ways to experience Conestoga. During this time, we are offering online guided tours to show you all Conestoga has to offer.

Book your tour

Virtual tours

If you can't make an on-campus tour or attend one of our events, the virtual tour is a great way to visit us.

View our Virtual tour

Courses - January 2023

Level 1

Course details

Conestoga 101
CON0101

Description: This self-directed course focuses on introducing new students to the supports, services, and opportunities available at Conestoga College. By the end of this course, students will understand the academic expectations of the Conestoga learning environment, as well as the supports available to ensure their academic success. Students will also be able to identify on-campus services that support their health and wellness, and explore ways to get actively involved in the Conestoga community through co-curricular learning opportunities.

Hours: 1
Credits: 0
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Information Technology Project Management
MGMT8770

Description: Information Technology projects involve many team members, including users, developers, testers, database administrators, developer operations – to name a few. This course will present several topics on managing projects from inception to deployment and maintenance.

Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Web Technologies
PROG8570

Description: The Web serves as a vehicle for many modern applications. Understand the basics of how the Web operates and knowing some of the technologies in use is essential to building successful applications.

Hours: 70
Credits: 5
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Computer Programming
PROG8580

Description: The process of retrieving data and presenting it to the user often involves some data manipulation. Programming languages are often used to bridge the data base to the user interface. A popular programming language will be used to provide the student with knowledge of the fundamentals of computer programming.

Hours: 70
Credits: 5
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Relational Databases
PROG8590

Description: Relational databases are heavily used within organizations to manage their corporate data. The student will learn how to interpret the needs of the corporation into diagrams (like entity-relationship diagrams), build the normalized schema and implement the resulting model using a popular relational database. Focus will be placed on retrieving data using various forms of the SELECT statement.

Hours: 84
Credits: 6
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

NoSQL Databases
PROG8600

Description: The popularity of the Web has encouraged the development of databases that are designed for speedy data retrieval. Many organizations have turned to databases like MongoDB to host data that is readily accessible by large numbers of people. The student will learn how a NoSQL database differs from a relational database, and how to optimize the performance of a NoSQL database. Focus will be placed on data visualization.

Hours: 70
Credits: 5
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Level 2

Course details

Career Management
CDEV8130

Description: This course focuses on career management skills needed to navigate the evolving workplace. Students will evaluate their skills, attitudes, and expectations within their chosen careers and explore emerging trends in the workplace. Students will refine their networking strategies and create marketing documents to position them for success. Mock interviews will provide the opportunity for practice, feedback, and reflection as students prepare for future interviews. Students will explore communication strategies that support workplace success and advancement. By the end of this course, students will have created a personalized career management plan.

Hours: 28
Credits: 2
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: Not available at this time.

Ethics and Security
ETHS8130

Description: Database-related activity often involves the analysis of sensitive data. In this course, students will examine the ethics of using this type of data, as well as topics in applying appropriate security measures in data collection and visualization.

Hours: 42
Credits: 3
Pre-Requisites:
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Developing Web Applications
PROG8610

Description: Web-based applications are extremely popular. They can be in the form of external (Internet) or internal (intranet) applications. As a follow-up to the Web Technologies course, students will be able to build applications using various frameworks (like Model-View-Controller (MVC)) with a focus on using a database as a key part of the system.

Hours: 84
Credits: 6
Pre-Requisites: PROG8570
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Data Warehouse Implementation
PROG8620

Description: Corporate data may come from many sources within the organization. Integrating all this data is usually in the form of a Data Warehouse and is often challenging. Students will analyze the data needs of a corporation, develop the processes to extract and transform the data into an integrated and comprehensive database, and make the data available to the users.

Hours: 84
Credits: 6
Pre-Requisites: PROG8590
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Data Visualization and Reporting
PROG8630

Description: Different parts of an organization will have separate needs for viewing corporate data. The student will develop skills in being able to view and analyze corporate data using popular tools and readily available application components. Focus will be placed on building effective dashboards.

Hours: 84
Credits: 6
Pre-Requisites: PROG8580
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Implementing Data Security
PROG8640

Description: Data can be secured at many levels and often involves the management of permissions. Students will be able to apply permissions to a database and develop applications that utilize and support the security policies.

Hours: 42
Credits: 3
Pre-Requisites: PROG8580
CoRequisites:
Estimated required text and/or learning resource costs: No cost.

Please note:

Estimated required text and/or learning resource costs are based on the most recent available data through the Conestoga Campus Store.

Program outcomes

Develop, test, document, deploy, and maintain secure program code based on business requirements and employing current technologies.
Perform routine maintenance on a database using relevant accepted industry practices.
Apply industry standard networking concepts to develop, deploy, and maintain program code.
Gather and document application requirements as a result of a business analysis.
Demonstrate effectiveness as part of a team in the development of a business solution.
Apply industry-supported approaches to the development, deployment and maintenance of applications as used in current IT environments.
Contribute to the successful completion of the project applying the project management principles in use.
Design and implement databases based on business requirements and following standard practices in database modeling.
Create a process to build and maintain a data warehouse using current tools and procedures.