Ders Planı

ISTANBUL AYDIN UNIVERSITY

CLASS 1

CLASS 4

Lesson plan / DATABASE SYSTEMS-I

Lesson Information

Course Credit	3.0
Course ECTS Credit	4.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	Distance Learning
Does the course require compulsory or optional work experience?	Z
Course Coordinator
Instructor (s)
Course Assistant

Purpose and Content

The aim of the course	To give to students the principles of investication, design and application of DataBase Managment Systems, File Organization problems, Relational Algebra Theory, SQL-language, Searching strategies in DB-systems.
Course Content	Basıc conceps of DB Systems, Data modeling using ER-model, Record storage principles, file organization methods, Integrity constraints in DBS, Relational DB language SQL, Functional Dependences in DBS,Normal forms, DBS Security problems.

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 Database Systems
2	DBMS concepts and Architecture (ACID)
3	Data modeling using ER-Model.
4	Relational Database Design in MS SQL Server
5	Data Types and Constraints in MS SQL Server
6	SQL Commands in MS SQL Server (Create, Alter, Drop)
7	SQL Commands in MS SQL Server (Insert, Update, Delete)
8	SELECT Command (Group By, Order By, Like, Between)
9	Nested SELECT statements
10	JOIN Operations (Inner, Outer, Full Joins)
11	T-SQL programming in MS SQL Server
12	Stored Procedures/Functions
13	Triggers
14	Cursors

Resources

1-Elmasri R., Navathe Sh., "Fundamentals of DataBase Systems", Addison Wesley, 2000.

EUA Kurumsal Öz değerlendirme Programı İzleme Raporu