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.

Learning Outcomes

1. Have the skills to create dynamic Web front-ends, middleware, and back-end components of e-commerce sites.
2. Discuss web database construction.
3. Identify client-side technologies.
4. Describe server-side technologies.
5. Explain connectivity of databases to web pages.
6. Write conditions, branching, loops, functions, and classes in PHP.
7. Implement arrays, strings and advanced data manipulation in PHP.
8. Use DDL statements for creating, altering, and deleting databases, tables, and indexes.
9. Use DML statements for adding, updating, deleting records, retrieving, and joining data from a database.
10. Query a MySQL database using PHP to insert, update, delete, and search data in a web database.
11. Perform client-side validation with JavaScript and server-side validation with PHP.
12. Discuss and use PHP session management.
13. Implement 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