CSE686 - Internet Programming

Lecture #8 - Relational Data Model, SQL Server

Revised: 4/18/2011
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 Lecture #11 Lecture #12 Lecture #13 Lecture #14
Lab #01 Lab #02 Lab #03 Lab #04 Lab #05 Lab #06
Lab #07 Lab #08 Lab #09 Lab #10 Lab #11 Lab #12
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. Project Demonstrations:
    Final Project1 Final Project2 Final Project3
    Final Project Demo Schedule, Summer 2010
  3. Relational Database Tutorial:
    Cal State Class Notes
  4. ADO Tutorials:
    ADO QuickStart, Overview of ADO Operations, Asp QuickStart, ADO articles, Single Table Commands
  5. Asp.Net tutorials and videos - Recommended
    Asp.Net videos
    Scott Guthrie's Nerd Dinner MVC Demo
  6. Relational Database Presentation and Demos:
    Second MVC Demo with Editable Grid, Second MVC Demo folder
    Demo MVC Data, Demo MVC Data folder, Demo MVC Data Step-by-step
    The Relational Database Model

    Database Schema Examples

    Database Project - includes DemoDB, Pubs, and NorthWnd SQL Server DBs
    Northwind Access Database
    Console Access Database

    Murat's Queries with Joins Presentation

  7. ADO Presentation, Asp.Net/SQL Examples:
    ADO Presentation

    GridView into Pubs Database, GridView into Pubs Folder
    SWProductsDB ASPX Data Reader, SWProductsDB Data Reader Folder
    SimpleDataReader Demo, SimpleDataReader folder
    SimpleDataSet Demo, SimpleDataSet folder
    DataGrid Details Demo, DataGrid Details folder

  8. Portal Parts:
    Persistant Movable Block(s), Movable Blocks Folder
  9. Lab Assignment #7