Key words
Database, SQL, Oracle, PLSQL, tripper, stored procedure
Objectives
Gaining insight in the design, querying and administration of relational databases.
Building up an extensive knowledge of SQL is essential.
Topics
Introduction to theory, design and use of relational databases: tabels, normalization, integrity, transactions, (embedded) SQL, QBE (Access), practical exercises (oracle, PLSQL)
Prerequisites
None.
Final Objectives
Materials used
Syllabus
Referentie: An introduction to Database Systems C.J. Date
Study costs
None.
Study guidance
Lecturers are available throughout the labs and by email.
One can always make an appointment.
Teaching Methods
Lectures and computerlabs using oracle.
Assessment
Theory : 47 %
Excercises : 53 %
Lecturer(s)
Dirk VANDYCKE en Ann VAN OVERBERGE
|
|
