Professor: | Sam Sultan | [sam.sultan@nyu.edu] |
Class website: | [oit2.sps.nyu.edu/~sultans/dbweb] (or) | [samsultan.com/dbweb] |
Office hours: | By Appointment | |
Course Days: | Tuesdays & Thursdays | |
Course Hours: | 6:00pm - 9:00pm |
Announcement(s): |
+ syllabus
+ outline |
+ books
+ grades |
+ final project
+ student listing |
+ demos HTML / SQL / PHP / Python
+ homework submission |
+ student feedback
+ student evaluation & comments |
This course examines the database and related applications technologies that have come to be critical in the enablement of web-based applications. The course builds on your knowledge of the web by providing you with an in-depth study of database related concepts using the MySql database. The course will also examine how to connect the web to the backend database server using the popular scripting language PHP or Python.
The course covers fundamentals of web technologies, database concepts, SQL, and the scripting language PHP and Python. Topics covered include creating client friendly html forms, designing and building databases, and using PHP or Python in conjunction with SQL to connect front-end web pages with back-end databases to collect, store, retrieve and present dynamically generated data.
As part of this course, the student will be exposed to HTML and the more structured HTML and CSS. The student will create web pages and web forms that collect and present data from the server. The student will be exposed to database concepts, and to the relational database model. The SQL language will be presented and used to design, build a database using the MySql database server. Students will also be exposed to the PHP and Python scripting language, and will use that language to build their own data-driven web sites.
MySql and PHP have become the world most popular open source products, and are currently being used by millions of web sites on the internet. Advance your career and learn how simple it is to use these two products to create your own data-driven web site
      The focus of the course will be on the following topics:
Required Reading & Materials -
Please do not negotiate for a better grade. If you are expecting to receive a grade of an "A" at the end of the semester, then I expect you to attend all sessions, to participate in class, to turn in your homework on time, and to keep up with the class reading material. If you see yourself falling behind do not hesitate to ask for help. This will ensure that you stay current with the class, and will ensure that you get a good grade on your work.
DATE | SESSION | TOPIC[s] COVERED |
  | ||
[Week 1] | 1a |
|
---|---|---|
Reading: | Chapter 1-6 (HTML5 & CSS3) | |
  | ||
  | 1b |
|
Reading: | Chapter 18 (HTML5 & CSS3) | |
  | ||
  | 2a |
|
Reading: | Chapter 7-9 (HTML5 & CSS3) | |
  | ||
  | 2b |
|
Reading: | Chapter 10-14 (HTML5 & CSS3) | |
  | ||
[Week 2] | 3a |
|
Reading: | Chapter 16 (HTML5 & CSS3) | |
  | ||
3b |
| |
Reading: | Chapter 2, 3 (Teach Yourself SQL in One Hour a Day) | |
  | ||
  | 4 |
|
Reading: | Chapter 5 (Teach Yourself SQL in One Hour a Day) | |
  | ||
[Week 3] | 5a |
|
Reading: | Chapter 7, 12 (Teach Yourself SQL in One Hour a Day) | |
  | ||
5b |
| |
Reading: | Chapter 4 (Teach Yourself SQL in One Hour a Day) | |
  | ||
6php
6py |
| |
Reading: | Chapter 1, 2 (PHP and MySQL Web Development) | |
  | ||
[Week 4] | 7php 7py |
|
Reading: | Chapter 3, 4, 5 (PHP and MySQL Web Development) | |
  | ||
  | 8 |
|
Reading: | Chapter 8 (PHP and MySQL Web Development) | |
  | ||
[Week 5] | 9a |
|
Reading: | Chapter 9 (PHP and MySQL Web Development) | |
  | ||
9b |
| |
Reading: | Chapter 11 (Teach Yourself SQL in One Hour a Day) | |
  | ||
  | 10php
10py |
|
Reading: | Chapter 11 (PHP and MySQL Web Development) | |
  | ||
  | 10b |
|
Reading: | None | |
  | ||
[Week 6] | 11php
11py |
|
Reading: | Chapter 23 (PHP and MySQL Web Development) | |
  | ||
  | 12 |
|