 | |
| STAT1219-1 | Databases and computing resources
 |
|
| Duration : | 28h Pr, 20h Th |
|
| Credits/ECTS : |
|
|
| Holder(s) : | Pierre Ramlot |
|
| Language : | French language |
|
| Course contents : | 1. Information system and computer system
2. Database server
2.1. Client/server architecture
2.2. Computer storage: devices and media
2.3. Computer storage system
2.4. Data management system
3. Database design
3.1. The Entity/Relationship Model
3.2. Design steps
3.3. Conceptual schema
3.4. Logical access schema
3.5. DBMS/DMS schema
3.6. Study of the implementation of a database (study case)
4. SQL language
4.1. Overview
4.2. Data definition
4.3. Data manipulation
4.4. Data retrieval
5. Computing resources Management
5.1. Interoperability management
5.2. Incident management
5.3. Security management
5.4. Documentation management
5.5. Financial management
5.6. Staying up to date
6. Information Technology Components Lifecycle Management
6.1. Identification and specification of IT needs
6.2. Planning implementation of new IT solutions
6.3. Indirect procurement management
6.4. Fulfilment and reception
6.5. Exploitation and maintenance
6.6. Disposal, renewal, migration |
|
| Course objective : | Studying Data Management Concepts (logical and physical aspects) for the implementation of any Database Management System and its Data Processing System.
After completing the course the student is expected to
- use a data-modelling approach to design relational database structures,
- implement a database by using a Relational Database Management System,
- use the SQL language,
- evaluate technology investments and organizational implications to install a database server,
- use a methodological approach to purchase computing resources,
- write specifications and establish Procurement Documents to purchase Information Technology components,
- understand database and client/server concepts if he must talk with a DP Manager who have the day-to-day technical supervision of client/server Information Technology infrastructure. |
|
| Prerequisites : | Programming experience. |
|
| Organization : | Lectures : 20h
Practical Works : 28h |
|
| Assessment : | Written examination (100%) |
|
| Contacts : | Ramlot, Pierre (Informaticien-Directeur) -
Service d'Informatique de GxABT -
081 62 24 72 -
Pierre.Ramlot@ulg.ac.be(ramlot.p@fsagx.ac.be) |
|
|
| |
