| Course Description |
|
| Course Name |
: |
Database Programming For Internet Applications |
|
| Course Code |
: |
EEE474 |
|
| Course Type |
: |
Optional |
|
| Level of Course |
: |
First Cycle |
|
| Year of Study |
: |
4 |
|
| Course Semester |
: |
Spring (16 Weeks) |
|
| ECTS |
: |
5 |
|
| Name of Lecturer(s) |
: |
Asst.Prof.Dr. TURGAY İBRİKÇİ
|
|
| Learning Outcomes of the Course |
: |
|
|
| Mode of Delivery |
: |
Face-to-Face |
|
| Prerequisites and Co-Prerequisites |
: |
None |
|
| Recommended Optional Programme Components |
: |
None |
|
| Aim(s) of Course |
: |
This course introduces the fundamentals for creating dynamic web page content generated using relational databases. This course is structured around Microsoft Visual Studio .NET and modern object-oriented programming languages like C#. Fundamental technologies like ADO.NET database connectivity, ASP.NET active page technology, XML, SOAP, and Web Services are examined. |
|
| Course Contents |
: |
This course covers database design and the use of database management systems for Internet applications. It includes extensive coverage of the relational model, relational algebra, and SQL. |
|
| Language of Instruction |
: |
English |
|
| Work Place |
: |
Classroom, Lab |
|
|
Course Outline /Schedule (Weekly) Planned Learning Activities |
| Week | Subject | Student's Preliminary Work | Learning Activities and Teaching Methods |
|
1 |
Meeting, What is XHTML? What are the differences between XHTML and HTML? |
Read the chapter on the subject |
None |
|
2 |
XHTML document type definition |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
3 |
Fundamental XHTML tags and page design |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
4 |
What is CSS? How to prepare local, global, and linked style sheets? |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
5 |
Structure and selectors of the CSS |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
6 |
The use of visual effects elements with XHTML CSS and XHTML |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
7 |
Fundamentals and syntax of the SQL language |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
8 |
Midterm |
It covers all previous topics in this course |
Midterm |
|
9 |
select and distinct statements of SQL |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
10 |
Insert, Update and delete statements of SQL |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
11 |
Create statement of SQL |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
12 |
SQL functions |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
13 |
Primary and Foreign keys |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
14 |
Create tables using SQL statements on the cross-examination |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
15 |
XHTML, CSS, and SQL in a Web page using the advanced design |
Read the chapter on the subject |
the hours of lecture for teaching and practical hours for applications of theoretical learning |
|
16/17 |
Final Exam |
it covers all opics of the course |
Exam |
|
|
| Contribution of the Course to Key Learning Outcomes |
| # | Key Learning Outcome | Contribution* |
|
1 |
Has capability in those fields of mathematics and physics that form the foundations of engineering. |
0 |
|
2 |
Grasps the main knowledge in the basic topics of electrical and electronic engineering. |
0 |
|
3 |
Comprehends the functional integrity of the knowledge gathered in the fields of basic engineering and electrical-electronics engineering. |
0 |
|
4 |
Identifies problems and analyzes the identified problems based on the gathered professional knowledge. |
2 |
|
5 |
Formulates and solves a given theoretical problem using the knowledge of basic engineering. |
1 |
|
6 |
Has aptitude for computer and information technologies |
5 |
|
7 |
Knows English at a level adequate to comprehend the main points of a scientific text, either general or about his profession, written in English. |
4 |
|
8 |
Has the ability to apply the knowledge of electrical-electronic engineering to profession-specific tools and devices. |
1 |
|
9 |
Has the ability to write a computer code towards a specific purpose using a familiar programming language. |
5 |
|
10 |
Has the ability to work either through a purpose oriented program or in union within a group where responsibilities are shared. |
4 |
|
11 |
Has the aptitude to identify proper sources of information, reaches them and uses them efficiently. |
4 |
|
12 |
Becomes able to communicate with other people with a proper style and uses an appropriate language. |
2 |
|
13 |
Internalizes the ethical values prescribed by his profession in particular and by the professional life in general. |
3 |
|
14 |
Has consciousness about the scientific, social, historical, economical and political facts of the society, world and age lived in. |
0 |
| * Contribution levels are between 0 (not) and 5 (maximum). |
|
|