Web Apps with web2py: Database Connectivity & the Model

web2py 2.21    |    Intermediate
  • 9 videos | 1h 5m 25s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
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

  • 2m 9s
  • 8m 19s
    Find out how to install a MySQL database which will be integrated with a web2py app later. FREE ACCESS
  • Locked
    3.  Integrating a web2py App with a Database
    8m 41s
    In this video, find out how to identify the steps involved in connecting a web2py app to a MySQL database. FREE ACCESS
  • Locked
    4.  Mapping web2py Models to a Database
    9m 20s
    After completing this video, you will be able to recognize how web2py models are translated to relational database tables. FREE ACCESS
  • Locked
    5.  Adding Users for a web2py App
    7m 37s
    Upon completion of this video, you will be able to illustrate how to use the default web2py app interface to sign up new users. FREE ACCESS
  • Locked
    6.  Adding Data to a Table from the UI
    10m 49s
    Upon completion of this video, you will be able to insert rows into a table using the web2py admin interface. FREE ACCESS
  • Locked
    7.  Using the web2py Grid Widget
    6m 28s
    Upon completion of this video, you will be able to recall how to use web2py's built-in grid widget to view the contents of a database table. FREE ACCESS
  • Locked
    8.  Searching for Data Using a web2py Grid
    9m 11s
    In this video, you will learn how to use the web2py grid to search the contents of a database table. FREE ACCESS
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Web Apps with web2py: The Controller & View
Rating 4.8 of 5 users Rating 4.8 of 5 users (5)
Course Web Apps with web2py: Decorators, Foreign Key Constraints, & Table Forms
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Book Python Programming for Students: Explore Python in Multiple Dimensions with Project-Oriented Approach

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Structures & Algorithms in Python: Implementing Data Structures
Rating 4.4 of 226 users Rating 4.4 of 226 users (226)
Course Introduction to SQL Bootcamp: Session 2 Replay
Rating 4.3 of 212 users Rating 4.3 of 212 users (212)
Course AWS Solutions Architect Professional 2022: AWS Backup
Rating 4.4 of 14 users Rating 4.4 of 14 users (14)