- University
- Academic
- Schools/Vocational Schools
- Vocational School of Justice
- Vocational School
- Vocational School
- Department of Banking and Insurance (Turkish)
- Department of Computer Programming (Turkish)
- Department of Foreign Trade (Turkish)
- Department of Graphic Design (Turkish)
- Department of Interior Design (Turkish)
- Department of Construction Technology (Turkish)
- Department of Occupational Health and Safety (Turkish)
- Department of Media and Communication (Turkish)
- Department of Architectural Restoration (Turkish)
- Department of Radio and Tv Programming (Turkish)
- Department of Civil Aviation Cabin Services (Turkish)
- Department of Civil Aviation Transportation Management (Turkish)
- Department of Tourism and Hotel Management (Turkish)
- Department of Applied English Translation
- Vocational School Of Health Services
- Vocational School Of Health Services
- Department of Child Development (Turkish)
- Department of Physiotherapy (Turkish)
- Department of Paramedic (Turkish)
- Department of Opticianry (Turkish)
- Department of Medical Documentation and Secreteriat (Turkish)
- Department of Medical Imaging Techniques (Turkish)
- Department of Medical Laboratory Techniques (Turkish)
- Department of Elderly Care (Turkish)
- School of Applied Management Sciences
- School of Foreign Languages
- Faculties
- Faculty of Arts and Sciences
- Faculty of Fine Arts and Design
- Faculty of Law
- Faculty of Communication
- Faculty of Business
- Faculty of Engineering
- Faculty of Engineering
- Department of Computer Engineering
- Department of Biomedical Engineering
- Department of Electrical and Electronics Engineering
- Department of Industrial Engineering
- Department of Food Engineering
- Department of Genetics and Bioengineering
- Department of Aerospace Engineering
- Department of Civil Engineering
- Department of Mechanical Engineering
- Department of Mechatronics Engineering
- Department of Software Engineering
- Faculty of Health Sciences
- Medicine
- Graduate School
- Common Courses
- Schools/Vocational Schools
- Research
- Research Centers
- Library
- Smart Campus
- Technology Transfer Office
- İzmir Sciencepark
- Continuous Education Center (EKOSEM)
- Children's University
- Ethics Committee
- Teaching and Learning Center (EKOEĞİTİM)
- Psychology Application and Research Center
- Researcher Training Coordinatorship
- Research Collaborations And Innovation Coordinatorship
- Campus
- INTERNATIONAL
- Contact
Department of Computer Programming (Turkish)
MBP 203 | Course Introduction and Application Information
| Course Name |
Database and Management
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
MBP 203
|
Fall/Spring
|
2
|
2
|
3
|
5
|
| Prerequisites |
None
|
|||||
| Course Language |
Turkish
|
|||||
| Course Type |
Elective
|
|||||
| Course Level |
Short Cycle
|
|||||
| Mode of Delivery | - | |||||
| Teaching Methods and Techniques of the Course | Group WorkProblem SolvingQ&AApplication: Experiment / Laboratory / WorkshopLecture / Presentation | |||||
| National Occupation Classification | - | |||||
| Course Coordinator | - | |||||
| Course Lecturer(s) | ||||||
| Assistant(s) | - | |||||
| Course Objectives | The aim of this course is to equip students with the fundamental competencies in database design and management, enabling them to play an active role in software development and data management processes. |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description | This course teaches students database concepts, the relational model, and the basic structures of the SQL language. Database design processes, normalization, and data modeling topics are covered in detail. Students learn query techniques and perform applications such as establishing database connections, adding and updating data, and querying using Python and Java. Thus, they gain theoretical knowledge and practical skills for effectively using databases in modern software development environments. |
| Related Sustainable Development Goals |
|
|
|
Core Courses | |
| Major Area Courses |
X
|
|
| Supportive Courses | ||
| Media and Management Skills Courses | ||
| Transferable Skill Courses |
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
| Week | Subjects | Related Preparation |
| 1 | Introduction to Data and Databases | Selçuk Alp; Savaş Özdemir; Arzu Kilitci Calayır, "Veritabanı Yönetim Sistemleri", Türkmen Kitabevi (2022), Chapter 1 |
| 2 | Relational Database Model | Selçuk Alp; Savaş Özdemir; Arzu Kilitci Calayır, "Veritabanı Yönetim Sistemleri", Türkmen Kitabevi (2022), Chapter 2 |
| 3 | Introduction to SQL | Selçuk Alp; Savaş Özdemir; Arzu Kilitci Calayır, "Veritabanı Yönetim Sistemleri", Türkmen Kitabevi (2022), Chapter 3 |
| 4 | SQL Queries and Subqueries | Selçuk Alp; Savaş Özdemir; Arzu Kilitci Calayır, "Veritabanı Yönetim Sistemleri", Türkmen Kitabevi (2022), Chapter 4 |
| 5 | Advanced SQL Queries - I | Selçuk Alp; Savaş Özdemir; Arzu Kilitci Calayır, "Veritabanı Yönetim Sistemleri", Türkmen Kitabevi (2022), Chapter 5 |
| 6 | Advanced SQL Queries - II – Quiz - I | Selçuk Alp; Savaş Özdemir; Arzu Kilitci Calayır, "Veritabanı Yönetim Sistemleri", Türkmen Kitabevi (2022), Chapter 6 |
| 7 | Views and Triggers | Selçuk Alp; Savaş Özdemir; Arzu Kilitci Calayır, "Veritabanı Yönetim Sistemleri", Türkmen Kitabevi (2022), Chapter 10 |
| 8 | Midterm | |
| 9 | Database Connection with Python | https://dev.mysql.com/doc/ |
| 10 | Advanced Applications with Python | https://dev.mysql.com/doc/ |
| 11 | Database Connection with Java | https://www.sqlite.org/docs.html |
| 12 | CRUD Operations with Java | https://www.sqlite.org/docs.html |
| 13 | Quiz - II | |
| 14 | Project Work | https://dev.mysql.com/doc/ |
| 15 | Project Work | https://www.sqlite.org/docs.html |
| 16 | Final |
| Course Notes/Textbooks | Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015). ISBN: 9786053271574 |
| Suggested Readings/Materials | https://dev.mysql.com/doc/ https://www.sqlite.org/docs.html |
EVALUATION SYSTEM
| Semester Activities | Number | Weigthing |
| Participation | ||
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques | ||
| Portfolio | ||
| Homework / Assignments | ||
| Presentation / Jury | ||
| Project |
1
|
35
|
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
25
|
| Final Exam |
1
|
40
|
| Total |
| Weighting of Semester Activities on the Final Grade |
2
|
60
|
| Weighting of End-of-Semester Activities on the Final Grade |
1
|
40
|
| Total |
ECTS / WORKLOAD TABLE
| Semester Activities | Number | Duration (Hours) | Workload |
|---|---|---|---|
| Theoretical Course Hours (Including exam week: 16 x total hours) |
16
|
2
|
32
|
| Laboratory / Application Hours (Including exam week: '.16.' x total hours) |
16
|
2
|
32
|
| Study Hours Out of Class |
14
|
1
|
14
|
| Field Work |
0
|
||
| Quizzes / Studio Critiques |
0
|
||
| Portfolio |
0
|
||
| Homework / Assignments |
0
|
||
| Presentation / Jury |
0
|
||
| Project |
1
|
17
|
17
|
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
15
|
15
|
| Final Exam |
1
|
40
|
40
|
| Total |
150
|
COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP
|
#
|
Program Competencies/Outcomes |
* Contribution Level
|
|||||
|
1
|
2
|
3
|
4
|
5
|
|||
| 1 |
To be able to have basic computer hardware and software knowledge. |
-
|
-
|
X
|
-
|
-
|
|
| 2 |
Explain web programming and network technologies and develop applications. |
-
|
-
|
-
|
-
|
-
|
|
| 3 |
Have written, verbal and non-verbal communication skills by doing team work. |
X
|
-
|
-
|
-
|
-
|
|
| 4 |
Do research, analyze and produce solutions for the problems encountered in the field. |
-
|
-
|
X
|
-
|
-
|
|
| 5 |
To be able to use basic programming languages related to the field. |
-
|
X
|
-
|
-
|
-
|
|
| 6 |
To be able to design and install a computer system that includes software, hardware, or both, meeting the basic needs of the field. |
-
|
X
|
-
|
-
|
-
|
|
| 7 |
To be able to interpret and follow current developments in the field of computer programming. |
-
|
X
|
-
|
-
|
-
|
|
| 8 |
To be able to carry professional and ethical responsibility and have awareness of professional ethics in their practices. |
-
|
-
|
-
|
-
|
-
|
|
| 9 |
To have basic theoretical and practical knowledge about mathematics, computing and computer science. |
-
|
-
|
-
|
-
|
-
|
|
| 10 |
To be able to follow the information in the field and communicate with colleagues by using English at the general level of European Language Portfolio A2. |
-
|
-
|
-
|
-
|
-
|
|
| 11 |
To be able to direct his/her education to a further level of education |
-
|
-
|
-
|
-
|
-
|
|
| 12 |
Have knowledge about occupational safety, environmental awareness and quality standards. |
-
|
-
|
-
|
-
|
-
|
|
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
NEWSALL NEWS
IZMIR UNIVERSITY OF ECONOMICS GÜZELBAHÇE CAMPUS
DetailsGLOBAL CAREER
As Izmir University of Economics transforms into a world-class university, it also raises successful young people with global competence.
More..CONTRIBUTION TO SCIENCE
Izmir University of Economics produces qualified knowledge and competent technologies.
More..VALUING PEOPLE
Izmir University of Economics sees producing social benefit as its reason for existence.
More..
You are one step ahead with your graduate education at Izmir University of Economics.