3rd Bachelor in Management Computing
Database administration and advanced techniques
< Back
| ECTS Credits | 3 |
|---|---|
| Number of Hours (h/year) | 45 |
| Teaching staff | HERBIET, Laurence |
| Course Unit | Compulsory |
| Term | Quad. 1 |
| Code | ECO-INF00014/3 |
| Prerequisite | Knowledge of SQL and client/server model Mastership of Entity-Relationship and relational models |
|---|---|
| Aims and Objectives | To handle the fundamentals of data warehousing To develop a WEB interface project in a multi-tier architecture and a business intelligence solution To understand the database administration principles To administer and to optimize relational databases |
| Description | The cube model and the data warehouses The data warehouse’s derives Database administration (process level , memory level and physical storage level) Backup and recovery practices Database Security : virtual private databases, identity management, grid computing, net services |
| Bibliography | KIMBALL (R.), Entrepôts de données, Guide pratique du concepteur de Data Warehouse, Paris, Wiley, 1997.
GOUARNE (J-M), Le projet décisionnel, Enjeux Modèles Architectures du Data Warehouse, Eyrolles, Paris, 1998.
DELMAL (P.), SQL2-SQL3, Applications à Oracle, De Boeck Université, 2000. ORACLE 9i Administration, Collection « Ressources Informatiques », Editions ENI, Nantes, Novembre 2002. Pratique d’ORACLE, Universal Data Server, Editions WEKA, Paris, Mars 2004. |
| Teaching and Learning Methods | Lectures Tutorials Laboratory work Lectures and practical work |
| Assessment Methods | Written examinations Oral examinations Projects or practical work Continuous assessment Lectures : Oral examination Practical work : continued evaluation |
| Notes | In part |
| Language | French |
The information contained herein is intended for informational purposes only. The Higher Education Institution disclaims any responsibility with regard to its content.