Database Management

3460:475/575

MW 5:10 – 6:25, CAS 107

Please don’t print any online materials (including lecture notes and software manuals) in the labs.

Instructor: Dr. Yingcai Xiao, Office: CAS 244, Telephone: 972-5809, Email: xiao@uakron.edu; Internet:  http://www.cs.uakron.edu/~xiao
Office Hours: M 3:00-3:25, 6:25-6:40p.m., W 3:00-5:00p.m., F 4:00-4:30p.m. or by appointment.

Grader: Varundev Garikapati

Email: vg8@uakron.edu

Office Hours: MW 6:25-7:25 p.m. in CAS 254 or by appointment.

 Final Exam Info

 Midterm Review Guide

 Course Syllabus

 Lecture Notes and Supporting Materials for the Textbook (Adapted lecture notes are at T:\Xiao\DB\Lectures)

 Examples

 Assignments (To be updated)

Assignment #1 (updated)

Assignment #2 (updated)

Assignment #3 (updated)

Assignment #4

Assignment #5

Term Project

 

 Resources

Download MSDNAA Software

 

Lab Computer Login, Documentation and Services

Lab Documentation

Lab 241 Hours, Lab 254 Hours

VPN Setup

 

How to Use SQL SERVER on winserv1

How to Build Three-tier Web Applications

How to Run Embedded SQL in C (ESQL/C) on SQLSERVER

How to Use Tomcat, JSP and ODBC in the Lab

How to Setup Tomcat, JSP and ODBC at Home

 

 JSP Resources

http://www.cs.uakron.edu/~xiao/yellow.gifHow to Run JSP Programs on the Lab Computers

http://www.cs.uakron.edu/~xiao/yellow.gifhttp://java.sun.com/products/jsp/jstl/

http://www.cs.uakron.edu/~xiao/yellow.gifhttp://java.sun.com/j2ee/1.4/docs/tutorial/doc/JSTL.html

http://www.cs.uakron.edu/~xiao/yellow.gifhttp://java.sun.com/j2ee/1.4/docs/tutorial/doc/JSPIntro9.html#wp73314

Sun's JSP site: http://java.sun.com/products/jsp/
Documentation: http://java.sun.com/products/jsp/docs.html
Perspective: http://java.sun.com/developer/technicalArticles/Programming/jsp/
Datasheet: http://java.sun.com/products/jsp/jsp_jservlet.ds.html
Tutorial: http://www.apl.jhu.edu/~hall/java/Servlet-Tutorial/

dot PHP

http://www.cs.uakron.edu/~xiao/yellow.gifHow to Run PHP Programs on the Lab Computers

http://www.cs.uakron.edu/~xiao/yellow.gif http://en.wikipedia.org/wiki/PHP

http://www.cs.uakron.edu/~xiao/yellow.gif http://php.net/

http://www.cs.uakron.edu/~xiao/yellow.gif http://www.w3schools.com/PHP/DEfaULT.asP

http://www.cs.uakron.edu/~xiao/yellow.gif Programming PHP

dot XML

http://www.cs.uakron.edu/~xiao/yellow.gif http://en.wikipedia.org/wiki/XML

http://www.cs.uakron.edu/~xiao/yellow.gif http://www.w3.org/XML/

http://www.cs.uakron.edu/~xiao/yellow.gif http://www.xml.com/

http://www.cs.uakron.edu/~xiao/yellow.gif http://www.w3schools.com/xml/default.asp

http://www.cs.uakron.edu/~xiao/yellow.gif http://www.w3.org/TR/xpath

http://www.cs.uakron.edu/~xiao/yellow.gif http://www.w3.org/TR/DOM-Level-2-Core

http://www.cs.uakron.edu/~xiao/yellow.gif http://www.saxproject.org

http://www.cs.uakron.edu/~xiao/yellow.gif XML Books:  http://books.google.com/books?q=XML&source=bll&ei=6hH5SdHoBNG9twfYo53FDw&sa=X&oi=book_group&resnum=11&ct=title&cad=bottom-3results

http://www.cs.uakron.edu/~xiao/yellow.gifXML/XSL Examples:

·         http://www.cs.uakron.edu/~xiao/isp2/xml/planes.xml (no style)

·         http://www.cs.uakron.edu/~xiao/isp2/xml/xslplane.xml (xsl)

·         http://www.cs.uakron.edu/~xiao/isp2/xml/xslplanes.xml (xsl)

·         http://winserv1.cs.uakron.edu/Examples/C13/Quotes/quotes.aspx (xml-xsl in ASP.NET)

 

 Final Review Guide