Web Apps with web2py: Database Connectivity & the Model

web2py 2.21    |    Intermediate
  • 9 Videos | 1h 5m 25s
  • Includes Assessment
  • Earns a Badge
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.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    install a MySQL database which will later be integrated with a web2py app
    identify the steps involved in connecting a web2py app to a MySQL database
    recognize how web2py models are translated to relational database tables
    illustrate how to use the default web2py app interface to sign up new users
  • recognize how to insert rows into a table using the web2py admin interface
    recall how to use web2py's built-in grid widget to view the contents of a database table
    identify how to use the web2py grid to search the contents of a database table
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 9s
    UP NEXT
  • Playable
    2. 
    Installing a MySQL Database
    8m 19s
  • Locked
    3. 
    Integrating a web2py App with a Database
    8m 41s
  • Locked
    4. 
    Mapping web2py Models to a Database
    9m 20s
  • Locked
    5. 
    Adding Users for a web2py App
    7m 37s
  • Locked
    6. 
    Adding Data to a Table from the UI
    10m 49s
  • Locked
    7. 
    Using the web2py Grid Widget
    6m 28s
  • Locked
    8. 
    Searching for Data Using a web2py Grid
    9m 11s
  • Locked
    9. 
    Course Summary
    2m 51s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.