VOCATIONAL SCHOOL
Department of Computer Programming (Turkish)
MBP 101 | Course Introduction and Application Information
| Course Name |
Database Systems I
|
|
Code
|
Semester
|
Theory
(hour/week) |
Application/Lab
(hour/week) |
Local Credits
|
ECTS
|
|
MBP 101
|
Fall
|
2
|
0
|
2
|
5
|
| Prerequisites |
None
|
|||||
| Course Language |
Turkish
|
|||||
| Course Type |
Required
|
|||||
| Course Level |
Short Cycle
|
|||||
| Mode of Delivery | face to face | |||||
| Teaching Methods and Techniques of the Course | Application: Experiment / Laboratory / WorkshopLecture / Presentation | |||||
| Course Coordinator | - | |||||
| Course Lecturer(s) | ||||||
| Assistant(s) | - | |||||
| Course Objectives | The purpose of this course is to provide students the basic principles of database systems by also introducing the practical usage of database programming. |
| Learning Outcomes |
The students who succeeded in this course;
|
| Course Description | The content of this course includes the design, implementation and management phases of database server. |
|
|
Core Courses |
X
|
| Major Area Courses | ||
| Supportive Courses | ||
| Media and Management Skills Courses | ||
| Transferable Skill Courses |
WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES
| Week | Subjects | Related Preparation |
| 1 | Introduction to Database | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 1 |
| 2 | Introduction to SQL | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 2 |
| 3 | Data Types | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 3 |
| 4 | Table Creation | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 4 |
| 5 | Table Creation | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 4 |
| 6 | Relational Database | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 5 |
| 7 | Relational Database | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 5 |
| 8 | Midterm | |
| 9 | Data Grouping | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 6 |
| 10 | Data Grouping | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 6 |
| 11 | Data Filtering | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 6 |
| 12 | Changing the table data | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 7 |
| 13 | Advanced query techniques and project | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 8 |
| 14 | Advanced Projects and Reporting | Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017) Part 8 |
| 15 | Review of the semester | |
| 16 | Final |
| Course Notes/Textbooks | Lecture notes and slides, digital programming files. Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017). ISBN: 9789756797785 |
| Suggested Readings/Materials |
EVALUATION SYSTEM
| Semester Activities | Number | Weigthing |
| Participation |
1
|
10
|
| Laboratory / Application | ||
| Field Work | ||
| Quizzes / Studio Critiques | ||
| Portfolio | ||
| Homework / Assignments |
1
|
20
|
| Presentation / Jury | ||
| Project | ||
| Seminar / Workshop | ||
| Oral Exams | ||
| Midterm |
1
|
30
|
| Final Exam |
1
|
40
|
| Total |
| Weighting of Semester Activities on the Final Grade |
3
|
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
|
0
|
|
| Study Hours Out of Class |
16
|
2
|
32
|
| Field Work |
0
|
||
| Quizzes / Studio Critiques |
0
|
||
| Portfolio |
0
|
||
| Homework / Assignments |
1
|
20
|
20
|
| Presentation / Jury |
0
|
||
| Project |
0
|
||
| Seminar / Workshop |
0
|
||
| Oral Exam |
0
|
||
| Midterms |
1
|
30
|
30
|
| Final Exam |
1
|
30
|
30
|
| Total |
144
|
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 | To be able to develop the necessary applications by using internet and network technologies. |
|||||
| 3 | To follow developments in the field to adapt to changing conditions. |
X | ||||
| 4 | To be able to conduct experiments in the field and analyze the results. |
|||||
| 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. |
X | ||||
| 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 |
|||||
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest
NEWS |ALL NEWS
'Success' formula of the masters
Former CEO of Turkcell and investor Süreyya Ciliv, who held senior positions in high technology companies, met with students at the "Students
'Digital' mobilization
Izmir University of Economics (IUE) started a 'digital transformation' movement in order for students to improve themselves in this field by not