The goals of this course are to introduce students the widely used internet technologies;to teach students the essentials of PHP programming language which allows them to create dynamic web pages and also to teach students MySQL relational database management system which allows them to store and manage the data.
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
Basic programming skills and (in order to follow the course resources) basic English knowledge are necessary and sufficient.
Instructor(s)
Lecturer Aydın DEMİRİZ
Course Assistant(s)
Schedule
Tue: 13.00-15.00 & Thu 11.00-13.00
Office Hour(s)
Tuesday 15.00-17.00.
Teaching Methods and Techniques
- Lecture
- Implementation at Computer Lab.
Principle Sources
- Luke Welling, Laura Thomson,PHP and MySQL Web Development, 4th ed., Addison Wesley Professional, 2008.
Other Sources
None
Course Schedules
Week
Contents
Learning Methods
1. Week
Overview of Internet TechnologiesGenel Bakış, Client-side Scripting, Server-side Scripting, HTML
Oral presentation
2. Week
PHP: Variables, Data Types, Operators, Control Structures
Oral presentation, implementation
3. Week
Storing and Manipulating Data in PHP
Oral presentation, implementation
4. Week
Arrays, Strings
Oral presentation, implementation
5. Week
Object Oriented PHP
Oral presentation, implementation
6. Week
MySQL Relational Database Management System
Oral presentation, implementation
7. Week
Selecting, Inserting, Updating and Deleting Data in MySQL
Oral presentation, implementation
8. Week
Midterm Exam-1
Exam
9. Week
Advanced MySQL
Oral presentation, implementation
10. Week
e-Commerce and Security
Oral presentation, implementation
11. Week
User Authentication in PHP and MySQL
Oral presentation, implementation
12. Week
Midterm Exam-2
Exam
13. Week
Designing an e-commerce Web Site
Oral presentation, implementation
14. Week
Advanced PHP Techniques
Oral presentation, implementation
15. Week
Finals Week
Exam
16. Week
Finals Week
Exam
17. Week
Finals Week
Exam
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
40
Final Exam
1
60
Program Outcomes
PO-1
Interpreting advanced theoretical and applied knowledge in Mathematics and Computer Science.
PO-2
Critiquing and evaluating data by implementing the acquired knowledge and skills in Mathematics and Computer Science.
PO-3
Recognizing, describing, and analyzing problems in Mathematics and Computer Science; producing solution proposals based on research and evidence.
PO-4
Understanding the operating logic of computer and recognizing computational-based thinking using mathematics as a discipline.
PO-5
Collaborating as a team-member, as well as individually, to produce solutions to problems in Mathematics and Computer Science.
PO-6
Communicating in a foreign language, and interpreting oral and written communicational abilities in Turkish.
PO-7
Using time effectively in inventing solutions by implementing analytical thinking.
PO-8
Understanding professional ethics and responsibilities.
PO-9
Having the ability to behave independently, to take initiative, and to be creative.
PO-10
Understanding the importance of lifelong learning and developing professional skills continuously.
PO-11
Using professional knowledge for the benefit of the society.
Learning Outcomes
LO-1
The student gains general knowledge about internet technologies.
LO-2
The student creates dynamic web pages by learning PHP programming language and its features.
LO-3
The student gains knowledge about how to store and manipule the data with MySQL.
LO-4
The student learns how to connect to a MySQL database through PHP and he/she understands how to make queries, to insert and to delete data.
LO-5
The student gains the ability to design simple but secure e-commerce web sites.
