TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF SCIENCE AND LETTERS |
| COMPUTER SCIENCES PR. | |
| Code | BBZ302 |
| Name | Web Design and Programming II |
| Term | 2025-2026 Academic Year |
| Semester | 6. Semester |
| Duration (T+A) | 2-2 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 3 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Dr. Öğr. Üyesi Cevher ÖZDEN |
| Course Instructor |
The current term course schedule has not been prepared yet.
|
Course Goal / Objective
The aim of this course is to provide students with a basic knowledge of server-side programming, to gain skills in database design and SQL querying, to develop dynamic web pages and to develop the ability to interact with data.
Course Content
This course aims to provide back-end programming knowledge necessary for developing dynamic and data-driven web applications. Students will acquire hands-on skills in frontend-backend, SQL, database connectivity, data manipulation through forms, user sessions and AJAX usage.
Course Precondition
To have taken Web Design and Programming I course.
Resources
Basic Resources on Dynamic Web Applications and Database-Based Systems Recent Lecture Notes and Articles on Server-Side Web Development and Data Interaction
Notes
W3Schools - Server-side scripting, databases, and AJAX sections; Mozilla Developer Network (MDN) - Web API and client-server interaction documentation; Open Web Application Security Project (OWASP) Web security guidelines; Application examples and documents to be provided by the instructor.
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Explains the basic concepts of server-side programming. |
| LO02 | Performs basic queries (SELECT, INSERT, UPDATE, DELETE) on the database using SQL. |
| LO03 | Manages session and cookie management. |
| LO04 | Sends and receives asynchronous data to and from the server with AJAX. |
| LO05 | Develops a dynamic web application that is data driven and user interactive. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Gain comprehensive knowledge of fundamental concepts, algorithms, and data structures in Computer Science. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Learn essential computer topics such as software development, programming languages, and database management | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Understand advanced computer fields like data science, artificial intelligence, and machine learning. | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Acquire knowledge of topics like computer networks, cybersecurity, and database design. | |
| PLO05 | Beceriler - Bilişsel, Uygulamalı | Develop skills in designing, implementing, and analyzing algorithms | 5 |
| PLO06 | Beceriler - Bilişsel, Uygulamalı | Gain proficiency in using various programming languages effectively | 5 |
| PLO07 | Beceriler - Bilişsel, Uygulamalı | Learn skills in data analysis, database management, and processing large datasets. | |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | Acquire practical experience through working on software development projects. | 5 |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Strengthen teamwork and communication skills. | 5 |
| PLO10 | Yetkinlikler - Alana Özgü Yetkinlik | Foster a mindset open to technological innovations. | |
| PLO11 | Yetkinlikler - Öğrenme Yetkinliği | Encourage the capacity for continuous learning and self-improvement. | |
| PLO12 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Enhance the ability to solve complex problems |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to Server-Side Web Programming | Basic concepts: server, client, HTTP | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 2 | Variables, Conditionals, and Control Structures | Examples in the selected language | Öğretim Yöntemleri: Soru-Cevap, Anlatım, Tartışma, Gösterip Yaptırma |
| 3 | Functions and Modular Coding | Function structure samples | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma, Tartışma |
| 4 | Working with Forms and Data Input | Form structure and data handling | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 5 | File and Directory Operations | Server-side file handling | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 6 | Introduction to Databases and Basic Concepts | Database types and relational design | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 7 | Connecting Applications to Databases | Connection setup and security | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 8 | Mid-Term Exam | Review of previous topics | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Basic Queries on Databases | Query practice | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 10 | User Management: Registration, Login, Sessions | Sessions and authentication | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 11 | Cookies, Authorization and Basic Security | Intro to web security | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 12 | Asynchronous Data Handling and AJAX Logic | Client-server data flow | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 13 | Project Dev I: Design, Data Modeling, Page Structure | Planning and modeling | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 14 | Project Dev II: Implementation and Testing | Application development | Öğretim Yöntemleri: Anlatım, Tartışma, Gösterip Yaptırma |
| 15 | Final Review and Project Preparation | Mentoring and support | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Gösterip Yaptırma |
| 16 | Term Exams | Final Project Presentations I | Ölçme Yöntemleri: Proje / Tasarım |
| 17 | Term Exams | Final Project Presentations II | Ölçme Yöntemleri: Proje / Tasarım |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 4 | 56 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 4 | 56 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 5 | 1 | 5 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 1 | 1 |
| Final Exam | 1 | 1 | 1 |
| Total Workload (Hour) | 119 | ||
| Total Workload / 25 (h) | 4,76 | ||
| ECTS | 5 ECTS | ||