BCS Courses

 

Ready to Apply?
File your application
online through SUNY's
website.
Apply Now

 
Home :: Academics :: School of Business :: Computer Systems Homepage :: BCS Courses :: BCS 350: Web Database Development (PHP/MySQL)

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 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. Understadn HTTP authentication with PHP.

 Textbooks:

Nixon - Learning PHP, MySQL, JavaScript & CSS, 2nd Edition
O.Reilly Publishing - ISBN 9781449319267