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