BCS 350: Web Database Development

This advanced course prepares the student to use database management systems with Web server software to develop and maintain the information content of a Web site. Students in the course should have a thorough knowledge of HTML, Web scripting, database management, and server technology. Credits: 3.00

Prerequisite

BCS 130 and BCS 260 with a minimum grade of C.

Course Objectives

At the completion of this course, students will:

1. Have the skill to create dynamic Web front-ends, middleware, and back-end components of e-commerce sites.
2. Understand web database construction.
3. Understand client-side technologies.
4. Understand server-side technologies.
5. Understand the connectivity of databases to web pages.
6. Know how to write conditions, branching, loops, functions, user-defined functions in PHP.
7. Know how to implement arrays, strings, and advanced data manipulation in PHP.
8. Be able to write SQL using MySQL: queries: join, inserting, updating, and deleting data.
9. Query a MySQL Database using PHP.
10. Write to web databases.
11. Validate Server-Side with PHP and validate Client-side with JavaScript.
12. Understand PHP Session Management
13. Understand HTTP authentication with PHP.

Textbook

• Learning PHP, My SQL, & JavaScript 5th Edition, Robin Nixon, O'Reilly Publishing 2018, ISBN-13: 978-1491978917, ISBN-10: 1491978910