Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|
DATABASE APPLICATIONS | BPR2160430 | Fall Semester | 1+2 | 2 | 5 |
Prerequisites Courses | |
Recommended Elective Courses | |
Language of Course | Turkish |
Course Level | Short Cycle (Associate's Degree) |
Course Type | Elective |
Course Coordinator | Lect. Beyza KOYULMUŞ |
Name of Lecturer(s) | Lect. Cihan DEMİR |
Assistant(s) | |
Aim | The aim of this course is to transfer intermediate level programming details on Database Setup, Management and Database Management, which are most commonly encountered in business life. |
Course Content | This course contains; Introduction & Explanation of course contents,Database Setup and Configuration ,Database Management ,Database Disaster Recovery ,Data Query Operations and Conditions (SQL),Data Query Operations and Conditions (SQL),Data modification operations (DML),Data Definition Processes (DDL),Grouping Data - Group Functions,Package, Function and Procedure Writing,Package, Function and Procedure Writing,Loops,Condition Expressions,General Review. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
Defines basic database concepts. | 6, 8, 9 | A, E |
Makes data query (SQL) | 14, 8, 9 | A, E |
Makes data modeling | 14, 6, 9 | A, E |
Writes functions and procedures | 12, 6, 8, 9 | A, E |
Performs data definition and modification operations | 14, 6, 8, 9 | A, E |
Teaching Methods: | 12: Problem Solving Method, 14: Self Study Method, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework |
Course Outline
Order | Subjects | Preliminary Work |
---|
1 | Introduction & Explanation of course contents | |
2 | Database Setup and Configuration | |
3 | Database Management | |
4 | Database Disaster Recovery | |
5 | Data Query Operations and Conditions (SQL) | |
6 | Data Query Operations and Conditions (SQL) | |
7 | Data modification operations (DML) | |
8 | Data Definition Processes (DDL) | |
9 | Grouping Data - Group Functions | |
10 | Package, Function and Procedure Writing | |
11 | Package, Function and Procedure Writing | |
12 | Loops | |
13 | Condition Expressions | |
14 | General Review | |
Resources |
Lecture slides and documents to be given in the course |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications |
No | Program Qualification | Contribution Level |
1 | 2 | 3 | 4 | 5 |
1 | Has the background in algorithms, programming, and application development in software engineering projects; and has the ability to use them together in business. | | | | | X |
2 | Chooses and uses the proper solution methods and special techniques for programming purpose. | | | | | X |
3 | Uses modern techniques and tools for programming applications. | | | | | X |
4 | Works effectively individually and in teams. | | | X | | |
5 | Implements and follows test cases of developed software and applications. | | | | X | |
6 | Has the awareness in workplace practices, worker health, environmental and workplace safety, professional and ethical responsibility, and legal issues about programming practices. | | | | | X |
7 | Reaches information, and surveys resources for this purpose. | | | | | X |
8 | Aware of the necessity of life-long learning; follows technological advances and renews him/herself. | | | | | X |
9 | Communicates, oral and written, effectively using modern tools. | | | | | X |
10 | Aware of universal and social effects of software solutions and practices; develops new software tools for solving universal problems and social advance. | | | X | | |
11 | Keeps attention in clean and readable code design. | | | | | X |
12 | Considers and follows user centered design principles. | X | | | | |
Assessment Methods
Contribution Level | Absolute Evaluation |
Rate of Midterm Exam to Success | | 40 |
Rate of Final Exam to Success | | 60 |
Total | | 100 |
ECTS / Workload Table |
Activities | Number of | Duration(Hour) | Total Workload(Hour) |
Course Hours | 14 | 3 | 42 |
Guided Problem Solving | 14 | 3 | 42 |
Resolution of Homework Problems and Submission as a Report | 3 | 10 | 30 |
Term Project | 0 | 0 | 0 |
Presentation of Project / Seminar | 1 | 2 | 2 |
Quiz | 1 | 2 | 2 |
Midterm Exam | 14 | 1 | 14 |
General Exam | 14 | 1 | 14 |
Performance Task, Maintenance Plan | 0 | 0 | 0 |
Total Workload(Hour) | 146 |
Dersin AKTS Kredisi = Toplam İş Yükü (Saat)/30*=(146/30) | 5 |
ECTS of the course: 30 hours of work is counted as 1 ECTS credit. |
Detail Informations of the Course
Course Description
Course | Code | Semester | T+P (Hour) | Credit | ECTS |
---|
DATABASE APPLICATIONS | BPR2160430 | Fall Semester | 1+2 | 2 | 5 |
Prerequisites Courses | |
Recommended Elective Courses | |
Language of Course | Turkish |
Course Level | Short Cycle (Associate's Degree) |
Course Type | Elective |
Course Coordinator | Lect. Beyza KOYULMUŞ |
Name of Lecturer(s) | Lect. Cihan DEMİR |
Assistant(s) | |
Aim | The aim of this course is to transfer intermediate level programming details on Database Setup, Management and Database Management, which are most commonly encountered in business life. |
Course Content | This course contains; Introduction & Explanation of course contents,Database Setup and Configuration ,Database Management ,Database Disaster Recovery ,Data Query Operations and Conditions (SQL),Data Query Operations and Conditions (SQL),Data modification operations (DML),Data Definition Processes (DDL),Grouping Data - Group Functions,Package, Function and Procedure Writing,Package, Function and Procedure Writing,Loops,Condition Expressions,General Review. |
Dersin Öğrenme Kazanımları | Teaching Methods | Assessment Methods |
Defines basic database concepts. | 6, 8, 9 | A, E |
Makes data query (SQL) | 14, 8, 9 | A, E |
Makes data modeling | 14, 6, 9 | A, E |
Writes functions and procedures | 12, 6, 8, 9 | A, E |
Performs data definition and modification operations | 14, 6, 8, 9 | A, E |
Teaching Methods: | 12: Problem Solving Method, 14: Self Study Method, 6: Experiential Learning, 8: Flipped Classroom Learning, 9: Lecture Method |
Assessment Methods: | A: Traditional Written Exam, E: Homework |
Course Outline
Order | Subjects | Preliminary Work |
---|
1 | Introduction & Explanation of course contents | |
2 | Database Setup and Configuration | |
3 | Database Management | |
4 | Database Disaster Recovery | |
5 | Data Query Operations and Conditions (SQL) | |
6 | Data Query Operations and Conditions (SQL) | |
7 | Data modification operations (DML) | |
8 | Data Definition Processes (DDL) | |
9 | Grouping Data - Group Functions | |
10 | Package, Function and Procedure Writing | |
11 | Package, Function and Procedure Writing | |
12 | Loops | |
13 | Condition Expressions | |
14 | General Review | |
Resources |
Lecture slides and documents to be given in the course |
Course Contribution to Program Qualifications
Course Contribution to Program Qualifications |
No | Program Qualification | Contribution Level |
1 | 2 | 3 | 4 | 5 |
1 | Has the background in algorithms, programming, and application development in software engineering projects; and has the ability to use them together in business. | | | | | X |
2 | Chooses and uses the proper solution methods and special techniques for programming purpose. | | | | | X |
3 | Uses modern techniques and tools for programming applications. | | | | | X |
4 | Works effectively individually and in teams. | | | X | | |
5 | Implements and follows test cases of developed software and applications. | | | | X | |
6 | Has the awareness in workplace practices, worker health, environmental and workplace safety, professional and ethical responsibility, and legal issues about programming practices. | | | | | X |
7 | Reaches information, and surveys resources for this purpose. | | | | | X |
8 | Aware of the necessity of life-long learning; follows technological advances and renews him/herself. | | | | | X |
9 | Communicates, oral and written, effectively using modern tools. | | | | | X |
10 | Aware of universal and social effects of software solutions and practices; develops new software tools for solving universal problems and social advance. | | | X | | |
11 | Keeps attention in clean and readable code design. | | | | | X |
12 | Considers and follows user centered design principles. | X | | | | |
Assessment Methods
Contribution Level | Absolute Evaluation |
Rate of Midterm Exam to Success | | 40 |
Rate of Final Exam to Success | | 60 |
Total | | 100 |
Numerical Data
Ekleme Tarihi: 05/11/2023 - 20:23Son Güncelleme Tarihi: 05/11/2023 - 20:25
×- A-Z Programs
- Undergraduate
- Graduate
- Academic Calendar
- Double Major & Minor Programs
- Erasmus
- Prospective Students
- Registration
- Re-Enrolment
- Fees
- Directorate of Registrar’s Office
- FAQ
- Accommodation
- Scholarships
- Lateral and Vertical Transfer
- Summer School
- Preparation
- Transportation