Reporting Systems and Database Development

Select start date and campus

Close

Applying as a Canadian applicant

Domestic students should apply online or by phone at 1-888-892-2228. For more information, visit Applying to Conestoga.

apply now: Canadian applicants

Applying as an International applicant

International students should apply online. Note: not all programs are open to international students.

apply now: international applicants
Close

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 - May 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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

Program outcomes

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