CSE686 - Internet Programming

Lecture #7 - Relational Data Model, SQL Server

Revised: 01 July 2008
Home Courses Code Handouts CoreTech Books Articles Math Research Masters Projects SWDev WebDev News OtherLinks SiteDesign Graduates AllPages Office Hours Notices Contents
CSE681-SWMAA CSE686-IP CSE687-OOD CSE775-DO CSE776-DP CSE778-AWP CSE784-SWS
Lecture #01 Lecture #02 Lecture #03 Lecture #04 Lecture #05
Lecture #06 Lecture #07 Lecture #08 Lecture #09 Lecture #10
Lab #01 Lab #02 Lab #03 Lab #04 Lab #05 Lab #06 Lab #07 Lab #08
Contents Syllabus

Web Resources:

Color Lab Color Codes HTML tags Everything HTML XML, HTML, Scripting Win32, COM, MFC webdeveloper.earthweb devx... W3Schools Web Developer's Virtual Library World-Wide Web Consortium WebReference devCentral

Office Hours:

Instructor & TAs

Content:

This lecture is concerned with Relational Databases and Active Data Objects and focuses on Examples relevant to the Final Project.

SQL Server:
SQL Data Types, Time Interval Data Types,
Structured Query Language (SQL) Tutorials:
steelarrow, SqlZoo, w3schools, Microsoft PDC, GeoCities, sqlTeam, sqlCourse2, sql-tutorial, XML to and from SQL, Introduction to SQL, SQL - Cal State Lecture Notes, SQL Tutorial, firstsql,
Active Data Objects (ADO):
Accessing Data with ADO.NET, Accessing Data with ASP.NET,
  1. Syllabus describes topics to be covered, reading material for you to digest before coming to class, and due dates for the assigned projects.
  2. Final Project #1, Final Project #2, Final Project #3, Final Project #4

    3. Notes from last week:
  3. FileTransfer web service - view web page
  4. FileTransfer web service - view folder

    5. Movable Blocks - a small portal prototype
  5. Persistant Movable Block(s), Movable Blocks Folder

    6. Relational DB Tutorials
  6. Cal State Class Notes

    7. ADO Tutorials
  7. ADO QuickStart
    Overview of ADO Operations
    Asp QuickStart
    ADO articles
    Single Table Commands

    8. The Relational Database Model
  8. The Relational Database Model
  9. Database Project
  10. Books Database
  11. Northwind Database
  12. Console Database
  13. Murat's Queries with Joins Presentation

    14. Asp.Net/SQL Examples
  14. GridView into Pubs Database, GridView into Pubs Folder
  15. SWProductsDB ASPX Data Reader, SWProductsDB Data Reader Folder
  16. SimpleDataReader Demo, SimpleDataReader folder
  17. SimpleDataSet Demo, SimpleDataSet folder
  18. DataGrid Details Demo, DataGrid Details folder
  19. Lab Assignment #7
  20. Lecture #7 folder contains a page of links to presentations and code discussed in this class. The Lecture folders will occasionally hold physical files of interest as well. Usually, however, all the materials of interest to the class are in the presentations and code folders. The contents of these folders will grow as you progress through the course.