3rd Bachelor in Computing and Systems: Industrial Computing
Data base management system
< Back
ECTS Credits | 3 |
---|
Number of Hours (h/year) | 30 |
---|
Teaching staff | HERBIET, Laurence KUTY, Ludovic |
---|
Course Unit | Compulsory |
---|
Term | Quad. 1 |
---|
Code | TECH-INS00017/3 |
---|
Prerequisite | - Knowledge of relational model and SQL
- Mastership of application development on a centralized database
|
---|
Aims and Objectives | - To get a good knowledge of client/server model
- To be able to develop an application based on client/server model
- In a second generation client/server approach, to be able to develop stored procedures, packages and triggers
- To understand the multi-tier architecture concepts and the working of an application server
- To be able to integrate a lot of analysis and programming techniques to develop an application with a Web interface on distributed databases in a heterogeneous environment
- To know dynamic SQL
|
---|
Description | - Client/server model and et distant access to a database
- Definition and practical interrogation of an SQL database, storage of procedures and triggers and development of applications (3GL) accessing it.
- Exceptions management
- Multi-tier architecture approach
- Development of an Intranet application with dynamic pages generation on a database
- Dynamic SQL
|
---|
Bibliography | - DELMAL (P.), SQL2 - SQL3 : applications à Oracle, De Boeck Université, 3rd edition, 2001.
- Oracle 10gR2 documentation.
|
---|
Teaching and Learning Methods | Lectures Project or fieldwork
practical work |
---|
Assessment Methods | Oral examinations
|
---|
Notes | Yes
|
---|
Language | French
|
---|
The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.