• Online, Self-Paced

Database connectivity is a crucial part of any full-stack web application and is the most convenient manner to persistently store data like user login credentials. web2py is built on the Model-View-Controller (MVC) paradigm with the model focused on connecting to databases and managing data in external sources.

In this course, study the role of the model in web2py apps. Investigate the db.py file and learn how to integrate MySQL with web2py while using the MySQL database as a backend for your web apps. Next, explore how to install the MySQL server and MySQL Workbench tool, and practice integrating web2py with these technologies.

Finally, work with the SQLFORM.grid widget, which is an extremely powerful and simple way to work with data from the model and incorporate it into your app.

Learning Objectives

{"discover the key concepts covered in this course"}

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Software Development

Specialty Areas have been removed from the NICE Framework. With the recent release of the new NICE Framework data, updates to courses are underway. Until this course can be updated, this historical information is provided to give better context as to how it can help you with your cybersecurity goals.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.