Home || Syllabus || Assignments || Readings || Resources
Office hours: Mondays 11:00-12:30, Thursdays 2:00-3:30 and by appointment
Tutoring hours: Ben Chen, Tuesdays - 12:30-3:00 in WWH Room 805 and Wednesdays -12:30-2:00 in WWH Room 705
Send email to firstname.lastname@example.org
Database Concepts, 5th Edition (New) or 4th Edition
Database Concepts, 5/E
David Kroenke, David Auer
Published: 07/25/2010 Publisher: Prentice Hall
Learning MySQL: Get a Handle on Your Data
By Seyed M.M. Tahaghoghi, Hugh E. Williams
Publisher: O'Reilly Media
Released: November 2006
PHP for the Web: Visual QuickStart Guide, 3rd Edition
By Larry Ullman
Published Dec 12, 2008 by Peachpit Press.
NOTE: It appears that the 4th edition might be available for Spring, 2012.
Additional books will be available to our class on-line through the NYU Library services "SAFARI" books during the semester. You would have the option to purchase these books if you prefer, or read them on-line.
Access Database Design & Programming, 3rd Edition is available from SAFARI books
by Steven Roman, Ph.D.
Pub Date: January 2002
Writing Excel Macros with VBA, 2nd Edition is available from SAFARI books
by Steven Roman, Ph.D.
Pub Date: June 2002
MySQL Cookbook is available from SAFARI books
by Paul DuBois
Pub. Date: 2007
Learning SQL is available from SAFARI books
By: Alan Beaulieu
Publisher: O'Reilly Media, Inc.
Pub. Date: August 22, 2005
Print ISBN-13: 978-0-596-00727-0
Internet Resources and Software
All students will be assigned a Unix account with access to MySQL and all required software for this class to use for their web sites. MS Office and Adobe's Photoshop and Dreamweaver applications are available for the students to use in the ITS labs.
Students' grades and comments on all assignments will be posted to Blackboard. Email sent to the class mailing list will be sent via Blackboard. All of the rest of the materials for the course are posted here on the course home site on the Computer Science Department web site.
This course will require one mid-term exam (20% of the final grade); one final exam (20% of the final grade); and approximately six homework assignments (accounting for 60% of the final grade).
This course will cover:
- Database theory and design
- Programming with Macros and Visual Basic (VBA) in MS-Excel
- Programming in Visual Basic and designing a protypte database in MS-Access
- Using MySQL to explore SQL programming
- Implementation database applications on the web in a Unix environment using MySQL for the data and PHP to build the user interface (Note: PHP is not a pre-requisite; we will study PHP tools available for working with MySQL in class)
- An overview and discussion of concepts in database management and database environments such as NoSQL