Subject
Information technology
Program
Bachelor’s degree (BBA)
Location
Côte-des-Neiges
Instruction mode
Credits
3
Description
This course aims at developing the skills and abilities necessary for the design and implementation of an operational database and the development of the applications required for its use.
Databases are an essential element of information systems. The information necessary for the operations and management of the company is obtained from the data describing the company's daily activities. This same data will later be transferred into data warehouses to allow managers and functional analysts to use business intelligence technologies and carry out in-depth analyses. The course will discuss performance issues and database administration. Students will become familiar with the use of professional tools used in the implementation of databases and with the development of applications, using the SQL language.
Themes covered
Relational data model characteristics
Creating relational models using SQL commands
Simple and complex SQL queries (union intersect and subtract) subqueries and synchronized queries
Views Transactions and Triggers
Database design: standardization conceptual and logical model
Query and database performance
Important notes
Préalable(s) : TECH 10701(A)
Course in French: TECH 20712