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.