Home - Search by Faculty - By teacher - By course


INFO0927-1

Introduction to databases

[ version française ]

Duration :30h Th
Credits/ECTS :
3e ingénieur commercial2
3e année du grade de bachelier en gestion de l'entreprise3
3e année du grade de bachelier en ingénieur commercial2
Holder(s) :Eric Vyncke
Course contents : Introduction to database
1. Concept of computer applications
2. Architecture of a database
3. Definition and standardization
SQL data manipulation language
1. Introduction to SQL
2. data definition language
3. data manipulation language
Database complements
1. Application architectures
2. Multiusers issues
3. Physical and logical security
Databases
1. Introduction and terminology
2. research tools
3. Off line support : CD-Rom
4. On line support
5. Data publication on the web (including HTML, and PHP with SQL interface)
Course objective : Understanding of management information system, database, data bank and how to use them in order to find the required information.
This lecture has also a technical aspect.
Prerequisites : Fundamentals of computer science and computer literacy
Ability of use Windows, Internet Explorer (or equivalent browser).
Effective use of at least one programming language (C, Pascal, javascript, ...)
Ability to use MS-Access will be benefitial.
Workshops : The practical exercices are done in two ways:
  • during the lecture in order to immediately practice the learned notions
  • in a group exercice: high volume of work but not scheduled. Could also be done outside of the University
Organization : Theory course with reference to real-life cases
Practical exercises during the course : creation, modification and queries in SQL ; creation of a dynamic website with links to a database
Written notes : No paper document is available since the content is in permanent flux in order to 'stick' to current state of the art.
A copy of slides (as well as solutions to exercices) are available on http://campus.hec.ulg.ac.be
Assessment : 1st session assessment = practical group assignment, marked; written examination on exercises (SQL and HTML); oral examination on the theory
2nd session assessment : idem (the practical assignement does not need to be done if already completed)
prolonged 2nd session assessment : idem (the practical assignement does not need to be done if already completed)
Contacts : Eric Vyncke, +32.475/31.24.58 evyncke@cisco.com
Eddy Heins, Eddy.Heins@ulg.ac.be




ULg : Students and Studies Administration - Academic Affairs
Contact : Monique Marcourt, direction A.E.E.
Date of data : 18/05/2007
Developed by SEGI