Advanced database storage and exploitation techniques

Type of course:	Compulsory
Language of instruction:	Romanian
Erasmus Language of instruction:	English
Name of lecturer:	Maria Loredana Oroian Boca
Seminar tutor:	Maria Loredana Oroian Boca
Form of education	Full-time

Form of instruction:	Lecture
Number of teaching hours per semester:	42
Number of teaching hours per week:	3
Semester:	Autumn
Form of receiving a credit for a course:	Grade
Number of ECTS credits allocated	7

Course aims:

Solving concrete practical problems that include elements of data structures and algorithms, programming
Development of programs in a general and / or specific programming language, starting from the specification of the requirements and until the execution, debugging and interpretation of the results
Use of techniques for conceptual modeling of data;
Acquiring knowledge of the types of models and modeling tools used in software application development

Course Entry Requirements:

-database, programming, data annalist

Course contents:

1. Database systems architectures; 2. SQL Advanced. SQL Union, Blind, Injection; 3. Object based database and XML; 4. Unified Modelling Language (UML). Transaction management; 5. Big data analysis; 6. Hadoop architecture and implementation; 7. MapReduce flow design. 8. SQL interaction with MapReduce;

Teaching methods:

lectures, examples, exercises

Learning outcomes:

a) systematic knowledge about the methodologies for making software products b) familiarization with modern concepts and concerns in writing the application software c) knowledge of the types of models and modeling tools used in the development of software applications d) the necessary motivation regarding the importance of the documentation of the soft products, in all the phases of the life cycle

Learning outcomes verification and assessment criteria:

project developing