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ı