Ders Planı

Lesson Information

Course Credit	3.0
Course ECTS Credit	6.0
Teaching Language of Instruction	İngilizce
Level of Course	Bachelor's Degree, TYYÇ: Level 6, EQF-LLL: Level 6, QF-EHEA: First Cycle
Type of Course	Compulsory
Mode of Delivery	Face-to-face
Does the course require compulsory or optional work experience?	Z
Course Coordinator
Instructor (s)
Course Assistant

Purpose and Content

The aim of the course	Upon completion of this course, participants will have gained knowledge of database system concepts and the ability to: • understand user requirements/views • analyze existing and future data processing needs • develop an enterprise data model that reflects the organization's fundamental business rules • develop and refine the conceptual data model, including all entities, relationships, attributes, and business rules • integrate and merge database views into conceptual model • apply normalization techniques • identify data integrity and security requirements • derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements
Course Content	This course covers fundamentals of database architecture, database management systems, and database systems. Principles and methodologies of database design, and techniques for database application development

The aim of the course

Upon completion of this course, participants will have gained knowledge of database system concepts and the ability to: • understand user requirements/views • analyze existing and future data processing needs • develop an enterprise data model that reflects the organization's fundamental business rules • develop and refine the conceptual data model, including all entities, relationships, attributes, and business rules • integrate and merge database views into conceptual model • apply normalization techniques • identify data integrity and security requirements • derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements

Course Content

This course covers fundamentals of database architecture, database management systems, and database systems. Principles and methodologies of database design, and techniques for database application development

Learning Outcomes

Adequate knowledge in mathematics, physical sciences and the engineering subjects of individual branches; the ability to implement theoretical and practical knowledge in the respective areas to modeling and solving engineering problems.
Ability to identify, define, formulate and solve complex engineering problems; ability to select and implement the appropriate analysis and modeling methods in this respect.
Ability to design and conduct experiments for analyzing engineering problems or research subjects specific to the discipline, to collect data, to analyze and interpret the results.
Ability to use, choose and develop modern techniques and means required for engineering applications; ability to use information technologies effectively.
An ability to design and conduct experiments, collect data, analyze and interpret results for the study of complex engineering problems or discipline-specific research topics.
Awareness of the necessity of lifelong learning; ability to reach information, follow the latest developments in science and technology; ability to ensure self-renewal perpetually.
Acting in line with ethical principles, sense of professional and ethical responsibility; knowledge on the standards of engineering applications.
Ability to work effectively in interdisciplinary and multi-disciplinary teams and individual works.
Information about the effects of engineering applications on health, environment and safety in terms of universal and social aspects and information about the problems of the era; awareness about the legal results of engineering solutions.
Ability to communicate efficiently both in oral and written ways in Turkish; knowledge of at least one foreign language; ability to effectively prepare reports and understand written reports, prepare design and production reports, effective presentation, giving and receiving clear and understandable instructions.
Knowledge of business practices such as project management, risk management and change management; awareness of entrepreneurship, innovation; information about sustainable development.

Weekly Course Subjects

1	Introduction to Java FX and Syllabus Discussion
2	Review of Database concepts and SQL
3	Normalization and Entity Relationship Diagrams
4	MySQL queries examples and JDBC
5	MySQL Stored Procedures
6	MySQL Triggers
7	MySQL Views
8	MySQL Functions
9	Midterm Exam
10	Hibernate
11	Hibernate
12	Project Evaluations
13	Project Evaluations
14	Project Evaluations

Resources

URLs will be provided as course notes when needed.

CLASS 1

CLASS 2

CLASS 3

CLASS 4

Lesson Information

Purpose and Content

Learning Outcomes

Weekly Course Subjects

Resources

ABOUT IAU

COMMITTEE

PUBLICATIONS

MEDIA CENTER