| COMPUTER PROGRAMMING | |||||
|---|---|---|---|---|---|
| Associate | TR-NQF-HE: Level 5 | QF-EHEA: Short Cycle | EQF-LLL: Level 5 | ||
General Information about the Course
| Course Code: | BGP 113 | ||||||||
| Course Title: | Databases 1 | ||||||||
| Course Semester: | 1. Semester / Fall | ||||||||
| Course Credits: |
|
||||||||
| Language of instruction: | TR | ||||||||
| Prerequisite of the course: | No | ||||||||
| Type of course: | Necessary | ||||||||
| Level of course: |
|
||||||||
| Course Lecturer(s): | Assistant Professor Begüm Al |
Purpose and content of the course
| Course Objectives: | It is aimed to gain competence in basic database concepts, relational data model, table data structure, relational arithmetic operations, basic SQL and advanced SQL queries, ODBC, programming of stored procedures and functions, normalization, triggering and development of database applications. |
| Course Objective: | It is aimed to gain the skills of designing a database, using the relational data model, querying, writing SQL stored procedures, triggers, and views. |
| Mode of Delivery: | Face to face |
Learning Outcomes
| Knowledge (Described as Theoritical and/or Factual Knowledge.) | ||
| Skills (Describe as Cognitive and/or Practical Skills.) | ||
|
1) Students will have the ability to read code and the ability to implement a solution to a problem via MS SQL. |
||
| 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.) | ||
Course Topics
| Week | Subject | ||
| 1) | Entrance to Databases | ||
| 2) | Relational Data Model | ||
| 3) | Designing Database | ||
| 4) | Data Definition Language and Data Manipulation Language | ||
| 5) | Queries | ||
| 6) | Sub queries and grouping | ||
| 7) | Normalization | ||
| 8) | Constraints | ||
| 9) | View | ||
| 10) | Trigger | ||
| 11) | Stored Procedure | ||
| 13) | Database Programming Application | ||
| 14) | Database Programming Application | ||
| 15) | Database Programming Application | ||
| 16) | Database Programming Application | ||
|
|||
Ders - Program Öğrenme Kazanım İlişkisi
| No Effect | 1 Lowest | 2 Average | 3 Highest |
| Ders Öğrenme Kazanımları | 1 |
|---|---|
| Program Outcomes | |
| 1) Today, where technology is a necessity in every field, it has become a necessity for all institutions to produce technology and ensure its continuity. It is a fact that there is always a need for qualified technical staff who can provide hardware and software solutions in Turkey and all over the world. It is important to train individuals who are experts in software in order to implement the creative and innovative ideas produced. Our Computer Programming department; It aims to train competent and creative individuals in basic programming and algorithm development techniques, current programming languages, project management methodologies, database management, network systems and hardware. In addition to technical application and theoretical content, courses that support our students' personal development and that they can focus on according to their interests are also offered. | |
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 | 64 | % 0 |
| Laboratory | 16 | % 0 |
| Application | 16 | % 0 |
| Practice Exam | 2 | % 0 |
| Quizzes | % 0 | |
| Homework Assignments | 8 | % 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.) | 1 | % 0 |
| Project Preparation + Presentation | % 0 | |
| Report Preparation + Presentation | % 0 | |
| Presentation / Seminar Preparation + Presenting | % 0 | |
| Oral examination | % 0 | |
| Midterms | % 0 | |
| Final | 1 | % 60 |
| Report Submission | % 0 | |
| Bütünleme | % 0 | |
| Kanaat Notu | % 0 | |
| Committee | % 0 | |
| Yazma Ödev Dosyası | 1 | % 0 |
| Portfolio | % 0 | |
| Take-Home Exam | % 0 | |
| Logbook | % 0 | |
| Discussion | % 0 | |
| Participation | % 0 | |
| total | % 60 | |
| PERCENTAGE OF SEMESTER WORK | % 0 | |
| PERCENTAGE OF FINAL WORK | % 60 | |
| total | % 60 | |
Calculation of Workload and ECTS Credits
| Activities | Number of Activities | Workload |
| Course Hours | 16 | 48 |
| Laboratory | 16 | 32 |
| Application | 16 | 32 |
| Practice Exam | ||
| Special Course Internship (Work Placement) | ||
| Field Work | ||
| Study Hours Out of Class | 16 | 22 |
| Article Critical | ||
| Article Writing | ||
| Module Group Study | ||
| Brainstorming | ||
| Role Playing + Dramatizing | ||
| Out-of-Class Study (Pre-study, Reinforcement, Practice Review, etc.) | ||
| Homework (reading, writing, watching movies, etc.) | ||
| Project Preparation + Presentation | ||
| Report Preparation + Presentation | ||
| Presentation / Seminar Preparation + Presenting | ||
| Oral examination | ||
| Preparing for Midterm Exams | 3 | 3 |
| MIDTERM EXAM (Visa) | 1 | 1 |
| Preparing for the General Exam | 2 | 2 |
| GENERAL EXAM (Final) | 1 | 11 |
| Participation | ||
| Discussion | ||
| Portfolio | ||
| Take-Home Exam | ||
| Logbook | ||
| Total Workload | 151 | |
| ECTS (30 saat = 1 AKTS ) | 5 | |