| MATHEMATICS (TURKISH, PHD) | |||||
| PhD | TR-NQF-HE: Level 8 | QF-EHEA: Third Cycle | EQF-LLL: Level 8 | ||
| Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
| SEN2102 | IBM Database Programming | Fall | 2 | 2 | 3 | 6 |
| The course opens with the approval of the Department at the beginning of each semester |
| Language of instruction: | En |
| Type of course: | Departmental Elective |
| Course Level: | |
| Mode of Delivery: | Face to face |
| Course Coordinator : | Dr. Öğr. Üyesi TAMER UÇAR |
| Course Lecturer(s): |
Dr. Öğr. Üyesi TAMER UÇAR Dr. Öğr. Üyesi YÜCEL BATU SALMAN |
| Course Objectives: | The aim of the course is to let the students to design and implement the relational databases with web access for database-driven web applications. Main objective is to understand the database programming methods with advances in SQL and PL/SQL, and dynamic web programming techniques focusing on databases. The course covers SQL, Advanced SQL, PL/SQL, and architectural design by using DBMS. |
|
The students who have succeeded in this course; 1. Define the fundamental concepts for designing, using and constructing database systems 2. Develop an analytical approach to real world situations 3. Reconstruct problem solving skills 4. Design data models and logical database, construct database implementation 5. Design database queries by using SQL. 6. Identify the basics of PL/SQL programming. 7. Develop database applications with PL/SQL. 8. Develop database applications by properly managing concurrent transactions. 9. Design database interfaces. |
| The course content is composed of database concepts, database design, data modeling and normalization, an overview to Oracle, Oracle tables, data management and retrieval, functions and grouping, join operations, the basics of PL/SQL, PL/SQL control structures and embedded SQL, PL/SQL cursor and exceptions, PL/SQL composite data types (Records, Tables, Varrays), procedure, function, package and trigger, Oracle with Java, architecture and administration. |
| Week | Subject | Related Preparation | |
| 1) | Database Concepts: A Relational Approach | ||
| 2) | Database Design: Data Modeling and Normalization | ||
| 3) | Oracle: An Overview / Oracle Tables: DDL | ||
| 4) | Working with Tables: Data Management and Retrieval | ||
| 5) | Working with Tables: Functions and Grouping / Joins | ||
| 6) | PL/SQL: A Programming Language | ||
| 7) | PL/SQL Basics | ||
| 8) | More on PL/SQL: Control Structures and Embedded SQL | ||
| 9) | PL/SQL Cursor and Exceptions | ||
| 10) | PL/SQL Composite Data Types: Records, Tables, Varrays | ||
| 11) | Procedure, Function, Package and Trigger | ||
| 12) | Oracle with Java: A Tutorial on JDBC and SQLj | ||
| 13) | Architecture and Administration | ||
| 14) | Project Presentations | ||
| Course Notes: | Silberschatz, A., Korth, H.F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw Hill. Elmasri, R., Navathe, S.B., Fundamentals of Database Systems, 5th Edition, Addison Wesley. Shah, N., Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL, Pearson Prentice Hall. |
| References: |
| Semester Requirements | Number of Activities | Level of Contribution |
| Attendance | 1 | % 15 |
| Laboratory | % 0 | |
| Application | % 0 | |
| Field Work | % 0 | |
| Special Course Internship (Work Placement) | % 0 | |
| Quizzes | 2 | % 10 |
| Homework Assignments | 1 | % 5 |
| Presentation | 1 | % 10 |
| Project | % 0 | |
| Seminar | % 0 | |
| Midterms | 1 | % 20 |
| Preliminary Jury | % 0 | |
| Final | 1 | % 40 |
| Paper Submission | % 0 | |
| Jury | % 0 | |
| Bütünleme | % 0 | |
| Total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 60 | |
| PERCENTAGE OF FINAL WORK | % 40 | |
| Total | % 100 | |
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 14 | 2 | 28 |
| Laboratory | 14 | 2 | 28 |
| Application | 0 | 0 | 0 |
| Special Course Internship (Work Placement) | 0 | 0 | 0 |
| Field Work | 0 | 0 | 0 |
| Study Hours Out of Class | 5 | 3 | 15 |
| Presentations / Seminar | 1 | 8 | 8 |
| Project | 1 | 15 | 15 |
| Homework Assignments | 2 | 5 | 10 |
| Quizzes | 2 | 2 | 4 |
| Preliminary Jury | 0 | 0 | 0 |
| Midterms | 1 | 14 | 14 |
| Paper Submission | 0 | 0 | 0 |
| Jury | 0 | 0 | 0 |
| Final | 1 | 18 | 18 |
| Total Workload | 140 | ||
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution |