General Information about the Course

Course Code:	BGP112
Course Title:	Database Management Systems II
Course Semester:	2. Semester / Spring
Course Credits:	Theoretical Practical Credit ECTS 2 2 3 4
Language of instruction:	TR
Prerequisite of the course:	No
Ders İş Deneyimini Gerektiriyor mu?:	No
Type of course:	Necessary
Level of course:	Associate TR-NQF-HE:5. Master`s Degree QF-EHEA:Short Cycle EQF-LLL:5. Master`s Degree
Course Lecturer(s):	Lecturer Volkan Aksoy
Course Assistants:

Purpose and content of the course

Course Objectives:	To teach advanced concepts and applications of database management systems.
Course Objective:	Be able to write complex SQL queries, optimize database performance and have knowledge about distributed database systems
Mode of Delivery:	Face to face

Learning Outcomes

Knowledge (Described as Theoritical and/or Factual Knowledge.)

1) Preparing the necessary documentation and presentation for the database project and making the presentation

Skills (Describe as Cognitive and/or Practical Skills.)

1) To be able to make necessary queries and other operations in business processes using SQL.

2) To be able to create user functions that can easily perform user operations using SQL and database server system specific programming structures.

3) To be able to code procedures/functions and triggers using SQL and database server system specific programming constructs.

4) To be able to set up and operate a database server and use the necessary tools/environments for access.

5) To be able to work in a team to design and develop a database for a specific job,

Competences (Described as "Ability of the learner to apply knowledge and skills autonomously with responsibility", "Learning to learn"," Communication and social" and "Field specific" competences.)

1) Students develop the competence to effectively manage, secure, and optimize performance of large-scale database systems.

Course Topics

Week	Subject
Related Preparation	Pekiştirme
1)	TRANSACTION
2)	TRANSACTION
3)	T-SQL(Transact SQL)
4)	T-SQL(Transact SQL)
5)	T-SQL(Transact SQL)
6)	T-SQL(Transact SQL)
7)	SAMPLE APPLICATIONS
8)	PL/SQL(Procedural Language/SQL)
9)	PL/SQL(Procedural Language/SQL)
10)	PL/SQL(Procedural Language/SQL)
11)	PL/SQL(Procedural Language/SQL)
12)	SERVER OPERATIONS
13)	Backup and Restore
14)	REPORTING
References: Özseven, T. (2020). Veritabanı Yönetim Sistemleri I ÖZKAN, Ö. Ü. B. (2020). Veritabanı Yönetimi. YARIMAĞAN, Ü. (2016). VERİ TABANI SİSTEMLERİ. 3D YAYINEVİ.

Ders - Program Öğrenme Kazanım İlişkisi

No Effect	1 Lowest	2 Average	3 Highest

Ders Öğrenme Kazanımları	1	1	2	3	4	5	1
Program Outcomes
1) Understand the basic concepts and terminology of computer science.
2) Ability to write code in widely used programming languages such as C, C++, Java, Python.
3) In-depth knowledge of algorithms and data structures.
4) To have knowledge about planning, execution and management of software projects.
5) To have knowledge about database design, management and SQL querying.	3	3	3	3	3	3	3
6) To have knowledge about computer networks, internet technologies and communication protocols.
7) Ability to write effective code in various programming languages and platforms.
8) Ability to solve complex problems with algorithmic thinking.
9) Ability to develop software solutions using mathematical and logical thinking skills.
10) Database creation, management and querying skills.	3	3	3	3	3	3	3
11) Ability to develop web applications with HTML, CSS, JavaScript and related frameworks.
12) Mobile application development skills for Android and iOS platforms.
13) To be able to work effectively in a team in software development processes.
14) Skills to plan, execute and manage software projects.
15) Continuous learning competence by following the innovations and current developments in technology.
16) Ability to communicate effectively with technical and non-technical stakeholders.
17) Adopting innovative approaches in software projects with creative thinking.
18) Having the necessary motivation for self-learning and professional development.
19) To bring the ideas and designs produced in the field of graphic design to the level of being able to apply them correctly within team work, to have the knowledge and to work harmoniously with the team in the field of design and production.
20) Plans the creation, application and production stages of graphic design. Visualizes designs using graphic programs on the computer.

Course Teaching, Learning Methods

Q & A
Case Problem Solving/ Drama- Role/ Case Management
Laboratory
Quantitative Problem Solving
Fieldwork
Group Study / Assignment
Individual Assignment
WEB-based Learning
Internship
Practice in Field
Project Preparation
Report Writing
Seminar
Supervision
Social Activity
Occupational Activity
Occupational Trip
Application (Modelling, Design, Model, Simulation, Experiment et.)
Reading
Thesis Preparation
Field Study
Student Club and Council Activities
Other
Logbook
Interview and Oral Conversation
Research
Watching a movie
Bibliography preparation
Oral, inscribed and visual knowledge production
Taking photographs
Sketching
Mapping and marking
Reading maps
Copying textures
Creating a library of materials
Presentation

Evaluation System

Semester Requirements	Number of Activities	Level of Contribution
Attendance		% 0
Laboratory		% 0
Application		% 0
Practice Exam		% 0
Quizzes		% 0
Homework Assignments		% 0
Presentation		% 0
Project		% 0
Special Course Internship (Work Placement)		% 0
Field Study		% 0
Article Critical		% 0
Article Writing		% 0
Module Group Study		% 0
Brainstorming		% 0
Role Playing + Dramatizing		% 0
Out of Class Study		% 0
Preliminary Work, Reinforcement		% 0
Application Repetition etc.		% 0
Homework (reading, writing, watching movies, etc.)		% 0
Project Preparation + Presentation		% 0
Report Preparation + Presentation		% 0
Presentation / Seminar Preparation + Presenting		% 0
Oral examination		% 0
Midterms	1	% 40
Final	1	% 60
Report Submission		% 0
Bütünleme		% 0
Kanaat Notu		% 0
Committee		% 0
Yazma Ödev Dosyası		% 0
Portfolio		% 0
Take-Home Exam		% 0
Logbook		% 0
Discussion		% 0
Participation		% 0
total		% 100
PERCENTAGE OF SEMESTER WORK		% 40
PERCENTAGE OF FINAL WORK		% 60
total		% 100

Calculation of Workload and ECTS Credits

Activities	Number of Activities	Workload
Course Hours	14	56
Laboratory
Application
Practice Exam
Special Course Internship (Work Placement)
Field Work
Study Hours Out of Class
Article Critical
Article Writing
Module Group Study
Brainstorming
Role Playing + Dramatizing
Out-of-Class Study (Pre-study, Reinforcement, Practice Review, etc.)	14	28
Homework (reading, writing, watching movies, etc.)
Project Preparation + Presentation
Report Preparation + Presentation
Presentation / Seminar Preparation + Presenting
Oral examination
Preparing for Midterm Exams	7	14
MIDTERM EXAM (Visa)	1	1
Preparing for the General Exam	14	21
GENERAL EXAM (Final)	1	1
Participation
Discussion
Portfolio
Take-Home Exam
Logbook
Total Workload		121
ECTS (30 saat = 1 AKTS )		4