SMI1002Winter 2025Databases
← Back to university path
Databases II
Detailed view of the course, studied concepts, technologies used, and major academic work associated with it.
Code
SMI1002
Session
Winter 2025
Domain
Databases
Overview
Advanced database course focused on the technical and internal aspects of database management systems. It helped me better understand storage, indexing, query processing, transaction management, concurrency, security, and the links between databases, web applications, and data analysis.
Technologies used
OracleSQLPL/SQLJSPData Warehousing
Key concepts covered
- Data organization and file structures
- Information storage in a DBMS
- Indexing
- Hash functions
- Query processing
- Query optimization
- Transaction processing
- Concurrency control
- Recovery systems
- Database security
- Access control
- Data encryption and protection
- DBMS architectures
- Parallel and distributed databases
- Databases and web applications
- Client-server and multi-tier architectures
- Object-relational databases
- XML and data exploitation
- Data analysis
- OLAP
- Data warehousing
- Data mining
- Design and implementation of a multi-user Oracle application
Coursework and evaluated components
- Team session project on a relational database using Oracle
- Preliminary analysis and design of the project
- Implementation of a multi-user application
- Use of SQL, PL/SQL, and possibly complementary tools
- Midterm exam
- Final exam