Please tell us a little bit about yourself

Search the: Search the directory Website Directory

Apply Donate Crisis Centre

Services and information

Accessibility
Bookstore
Brand Central
IT services
Library
Service disruptions

Safety and security

Campus emergencies
Campus safety
Health and Safety
Mental health and wellness
Sexual violence support and education

Faculty and staff

Faculties and departments
Faculty resources
Resources and services

Students

Academic Calendar
Canvas
MyOntarioTech
Ridgebacks
Student email

Ontario Tech home page

Academic Calendar

Ontario Tech home page

Undergraduate

Apply now
Academics
Blog
Connect with us
English Language Centre
International applicants
International Office
Programs
More in Undergraduate

Graduate

Application process and requirements
Doctoral Programs
Graduate diploma programs
Graduate student awards
International applicants
Master’s programs
Tours and events
Contact
More in Graduate

Programs

Programs by faculty
Undergraduate
Graduate
College-to-university transfer
Direct entry co-op
Online programs
Pre-med programs
Continuous Learning
More in Programs

Student life

Contact us
Indigenous Hub
International Office
Parents and Families
Services
Varsity Athletics

Undergraduate

Academic Advising
Academic calendar
Academic Integrity
Change of program
Convocation
Course registration
Fees and payment
Important dates and deadlines
More in Undergraduate

Graduate

Communicating with you
Grad student toolkit
Graduate Academic Calendar
Course registration
Grad Pro Skills (GPS)
Important dates
Student finances
Student forms and publications
More in Graduate

Student life

Contact us
Accessibility
Student Learning Centre
Career Readiness
Community
Equity and Inclusion
Health and Wellness
Indigenous Education and Cultural Services
More in Student life

Campus services

Bookstore
Campus Libraries
Office of Campus Safety
Directions and transit
- Car
- Transit
- Train
- Plane
- Parking
- U-Pass
Food services
Health centre
- Campus Health Centre
Housing options
- On-campus
- Off-campus
Ontario Tech Ucard
More in Campus services

Research

Discover Research
Entrepreneurship
- Brilliant Entrepreneurship
Faculty
IRIS Research Portal
Partnerships & Innovation
Students

Research Facilities

CERL building — Clean Energy Research Laboratory (CERL)

ONTARIO-TECH-CMCC Institute for Disability and Rehabilitation Research

Giving

Donate

UOIT donors — Memorial and Tribute Gifts

A male and female studnet looking at the UOIT buildings

Giving at Ontario Tech

Our faculty and students are at the leading edge of research in Canada, developing innovative solutions to today’s complex problems. Your support is building a better world.

Donate now

Facebook
Twitter
Instagram
LinkedIn
YouTube

2000 Simcoe Street North
Oshawa, Ontario L1G 0C5
Canada

905.721.8668

Ontario Tech University is the brand name used to refer to the University of Ontario Institute of Technology.

Ontario Tech acknowledges the lands and people of the Mississaugas of Scugog Island First Nation which is covered by the Williams Treaties and are the traditional territory of the Mississaugas, a branch of the greater Anishinaabeg Nation, including Algonquin, Ojibway, Odawa and Pottawatomi. Learn more.

Top

Ontario Tech University

Dec 26, 2024

2023-2024 Undergraduate Calendar

Select a Calendar

Global Search Calendar Search
Choose Search Location

Search Keyword Field

Whole Word/Phrase
Advanced search

Catalog Navigation

Calendar Home

Programs (by degree)

Programs (by faculty)

Course descriptions

Admissions

Academic regulations

Academic schedule

Fees and charges

Calendar notice and disclaimer

Student privacy

Governance

Glossary

My favourites

HELP

2023-2024 Undergraduate Calendar [ARCHIVED CALENDAR]

Print-Friendly Page (opens a new window)

Add to favourites (opens a new window)

BUSI 3504U – Databases, Data Warehouses and Business Intelligence

This course is designed for information technology and business students as a first step towards becoming a data management and business intelligence professional. It focuses on three areas: databases, data warehouses and business intelligence. First, it covers the foundations of data modelling, including entity-relationship diagrams, normalization and denormalization, database management techniques and Structured Query Language (SQL). Next, it exposes students to the implementation and use of data warehouses from conceptual and practical perspectives. Finally, it covers the use of databases and data warehouses for various business intelligence tasks. Throughout the course, students will be given an opportunity to explore popular database, data warehousing and business intelligence software tools.
Credit hours: 3
Lecture hours: 3
Prerequisite(s): BUSI 1520U and (BUSI 2040U or BUSI 3040U) or the permission of the instructor.
Credit restriction(s): CSCI 3030U or INFR 3810U

Add to favourites (opens a new window)