DV240 PHP and MySQL II

Course Description

Extending the concepts presented in the prior Web Development certificate classes, students will take concepts behind databases further and learn what makes larger database driven sites like Facebook. We’ll begin discussing sessions, security and advanced database design concepts. Students will have an opportunity to create a database driven site from scratch, which will serve as a powerful addition to their portfolios.

Format/Topics

  • MySQL and phpMyAdmin
  • Database architecture best practices
  • Database security best practices
  • $_SESSION and authentication
  • Create/Read/Update/Delete (CRUD) applications
  • Iterating through database results

Learning Outcomes

  • Become stronger with PHP syntax
  • Begin working with databases and how to manage them
  • Understand common CRUD database application paradigm