DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-II

Course Description

Fundamental concepts and applications about DB architectures will be discussed like properties of popular databases, backup, recovery, replication and reverse engineering. Also, students will gain knowledge on transactions, indexes, PL/SQL, Triggers, stored, functions, stored procedures and cursors. Views, materialized views, query performance optimization, database application Development with a programming language and SQL injection will also explained. Case studies will cover the topics studies in this lecture.

DATABASE MANAGEMENT SYSTEMS AND PROGRAMMING-II

Evaluation Tools (Active Term)

No evaluation items have been defined.

Course outcomes

1. 01 To develop skills for database administration for database objects
2. 02 To give students an ability to clarify and apply the fundamental concepts in stored procedures/functions/triggers/materialized views
3. 03 To give students a working knowledge and ability to apply Oracle DBMS Server's PLSQL
4. 04 To enable students develop an application with DBMS

Course Syllabus

Reference Books & Course Materials

1. 01 Elmasri & Navathe "Fundementals of Database systems" 5th edition 2007
2. 02 Oracle PL/SQL: Expert Techniques for Developers and Database Administrators
3. 03 Database System Concepts

Learning Outcomes

No learning outcomes have been defined.

Program Outcomes

1. P01 Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied knowledge in these areas in complex engineering problems.
2. P02 Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose.
3. P03 Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way as to meet the desired result; ability to apply modern design methods for this purpose.
4. P04 Ability to devise, select, and use modern techniques and tools needed for analysing and solving complex problems encountered in engineering practice; ability to employ information technologies effectively
5. P05 Ability to design and conduct experiments, gather data, analyse and interpret results for investigating complex engineering problems or discipline specific research questions
6. P06 Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually.
7. P07 Ability to communicate effectively in Turkish, both orally and in writing; knowledge of a minimum of one foreign language; ability to write effective reports and comprehend written reports, prepare design and production reports, make effective presentations, and give and receive clear and intelligible instructions.
8. P08 Recognition of the need for lifelong learning ; ability to access information, to follow developments in science and technology, and to continue to educate him/herself
9. P09 Consciousness to behave according to ethical principles and professional and ethical responsibility; knowledge on standards used in engineering practice.
10. P10 Knowledge about business life practices such as project management, risk management, and change management; awareness in entrepreneurship, innovation; knowledge about sustainable development.
11. P11 Knowledge about the global and social effects of engineering practices on health, environment, and safety, and contemporary issues of the century reflected into the field of engineering; awareness of the legal consequences of engineering solutions.

Po-Lo Matrix

The PO-LO matrix has not been populated yet.