Syllabus

Course Description

This class is designed as a follow-up to V22.0004, "Computers in Principle and Practice I," which examined basic computer principles, theory and history, and also explored word processing, spreadsheets, web browsing and basic web authoring techniques.

This second course will cover an in-depth exploration of database design and implementation for desktop and web-based database implementations.

In order to take this course, students should have completed Computers in Principle and Practice I (V22.0004) or equivalent, and have either completed one semester of programming (such as V22.0002 or V22.0101) or have equivalent programming experience in a high level programming language such as Pascal, C,  or Java.

Course Materials

Books

MySQL, Second Edition: Visual QuickStart Guide, 2nd Edition

By Larry Ullman.
Published by Peachpit Press.
Series: Visual QuickStart Guide.
ISBN-10: 0-321-37573-4; ISBN-13: 978-0-321-37573-5
Published: May 10, 2006;
Copyright 2006

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.
Publisher: O'Reilly
Pub Date: January 2002
ISBN: 0-59600-273-4

Learning SQL is available from SAFARI books
by Alan Beaulieu
Publisher: O'Reilly
Pub Date: August 2005
ISBN: 0-596-00727-2

Writing Excel Macros with VBA, 2nd Edition is available from SAFARI books
by Steven Roman, Ph.D.
Publisher: O'Reilly
Pub Date: June 2002
ISBN: 0-596-00359-5

... These three publications are available for $5 each from Peachpit Press

Optional Books

Microsoft Office Access 2003 for Windows: Visual QuickStart Guide

By Steve Schwartz.
Published by Peachpit Press.
Series: Visual QuickStart Guide.
ISBN-10: 0-321-19393-8; ISBN-13: 978-0-321-19393-3
Published: Sep 24, 2003
Copyright 2003

Microsoft Office Excel 2003 for Windows: Visual QuickStart Guide

By Maria Langer
ISBN: 0321200381
Peachpit Press

Database Concepts 2/E

by David M. Kroenke
ISBN-10: 0131451413 for 2/E; Note that the Third Edition (3/E) became available after the start of this semester
Prentice Hall

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 websites. MS Office is available for the students to use in the ITS PC labs and Adobe Photoshop is available in both the PC and Mac Labs.

Subscribe to the Class Mailing List

Additional Information

Grading

This course will require one mid-term exam (20% of the final grade); one final exam (30% of the final grade); and approximately 8 homework assignments (accounting for 50% of the final grade). The final project will be due before the final exam.

Topics

This course will cover:


Send questions by email to: