COURSE INFORMATON
Course Title Code Semester L+P Hour Credits ECTS
Database Programming for Internet * EEE   474 8 3 4 5

Prerequisites and co-requisites
Recommended Optional Programme Components None

Language of Instruction Turkish
Course Level First Cycle Programmes (Bachelor's Degree)
Course Type
Course Coordinator Assoc.Prof.Dr. Turgay İBRİKÇİ
Instructors
Doç.Dr.TURGAY İBRİKÇİ1. Öğretim Grup:A
Doç.Dr.TURGAY İBRİKÇİ2. Öğretim Grup:A
 
Assistants
Goals
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 CSharp. Fundamental technologies like ADO.NET database connectivity, ASP.NET active page technology, XML, SOAP, and Web Services are examined.
Content
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.

Learning Outcomes
-


Course's Contribution To Program
NoProgram Learning OutcomesContribution
12345
1
Has capability in those fields of mathematics and physics that form the foundations of engineering.
2
Grasps the main knowledge in the basic topics of electrical and electronic engineering.
3
Comprehends the functional integrity of the knowledge gathered in the fields of basic engineering and electrical-electronics engineering.
X
4
Identifies problems and analyzes the identified problems based on the gathered professional knowledge.
X
5
Formulates and solves a given theoretical problem using the knowledge of basic engineering.
X
6
Has aptitude for computer and information technologies
X
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.
X
8
Has the ability to apply the knowledge of electrical-electronic engineering to profession-specific tools and devices.
X
9
Has the ability to write a computer code towards a specific purpose using a familiar programming language.
X
10
Has the ability to work either through a purpose oriented program or in union within a group where responsibilities are shared.
X
11
Has the aptitude to identify proper sources of information, reaches them and uses them efficiently.
X
12
Becomes able to communicate with other people with a proper style and uses an appropriate language.
X
13
Internalizes the ethical values prescribed by his profession in particular and by the professional life in general.
14
Has consciousness about the scientific, social, historical, economical and political facts of the society, world and age lived in.

Course Content
WeekTopicsStudy Materials _ocw_rs_drs_yontem
1 Meeting, What XHTML is, Creating and Running a Stored Procedure Read the chapter on the subject
2 Running a Simple Stored Procedure from CSharp Code Read the chapter on the subject
3 Data requirements and conceptual model Read the chapter on the subject
4 SQL queries over the database Read the chapter on the subject
5 Introducing CSharp header files for the database Read the chapter on the subject
6 Working on Simple Classes and the classes for the database Read the chapter on the subject
7 Fundamentals and syntax of the SQL language Read the chapter on the subject
8 Midterm It covers all previous topics in this course
9 select and distinct statements of SQL Read the chapter on the subject
10 Insert, Update and delete statements of SQL Read the chapter on the subject
11 Create statement of SQL Read the chapter on the subject
12 SQL functions Read the chapter on the subject
13 Primary and Foreign keys Read the chapter on the subject
14 Create tables using SQL statements on the cross-examination Read the chapter on the subject
15 XHTML, CSS, and SQL in a Web page using the advanced design Read the chapter on the subject
16-17 Final Exam it covers all topics of the course

Recommended or Required Reading
Textbook
Additional Resources
www.w3schools.com Internet sitesi, Dreamviewer ve SQL Server 2008 programı