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.
COURSE LEARNING GOALS:
1. Course Objectives:
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
The focus of the course will be on the following topics:
HTML and especially tables and forms
CSS Cascading Style Sheet
Relational database concepts
Database design and normalization
The SQL programming language
The Data Definition Language (DDL)
The Data Manipulation Language (DML)
The PHP scripting language
The Python scripting language
File and database manipulation
Session management and cookies
2. Student Learning Outcomes:
Knowledge of HTML and specifically how to create HTML tables and HTML forms
Ability to integrate CSS to improve visual web presentation
Understand database concepts and design
Ability to create database tables to support web interaction
Ability to access database tables to insert, update, query and delete data
Ability to create and end-to-end database driven web application
Understand usage of PHP and how to integrate PHP in web applications
Understand usage of Python and how to integrate Python in web applications
Understand how to integrate PHP and Python with MySql databases
Ability to create cookies and to manage stateful web sessions
Class Attendance and Participation: To receive full credit for the course, you must attend all classes since much of the learning occurs during class presentation and discussions.
Please contact the instructor if you anticipate missing any part of the class.
Grades will be based on:
Involvement in class activities
Participation which demonstrates integration of reading, class work, relevance and application.
Willingness to learn by accepting feedback, trying new skills and approaches, etc.
Quality/quantity of providing effective and balanced feedback.
Homework: Homeworks must be submitted on time within 1 week after date assigned.
Late submission will severely impact your homework grade, or may not be accepted altogether at instructor discretion.
All homework pages must be stapled together, no exception (paper clips not accepted)
Print out your homework code and output and bring with you to class
I will not accept homework via email unless you are not able to attend the class.
Proper indentation where appropriate is a must. If not properly indented I may return it without grading it.
Class Project Presentation: There will be a group/team class presentation.
The presentation will be a culmination of verbal, visual and presentation skills. It will also be the culmination of topics, concepts and competencies learned in this class.
Midterm Exam: There will be a midterm exam. The exam will be an open book, open notes style exam.
The exam will test the student's acquisition of topics, concepts and competencies learned by midterm.
Final Exam: There will be a final exam. The exam will be an open book, open notes style exam.
The exam will test the student's acquisition of topics, concepts and competencies learned in this class.
The final exam will not be cumulative. It will only cover topics discussed since the midterm.
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.