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
-
2m 9s
-
8m 19sFind out how to install a MySQL database which will be integrated with a web2py app later. FREE ACCESS
-
3. Integrating a web2py App with a Database8m 41sIn this video, find out how to identify the steps involved in connecting a web2py app to a MySQL database. FREE ACCESS
-
4. Mapping web2py Models to a Database9m 20sAfter completing this video, you will be able to recognize how web2py models are translated to relational database tables. FREE ACCESS
-
5. Adding Users for a web2py App7m 37sUpon 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
-
6. Adding Data to a Table from the UI10m 49sUpon completion of this video, you will be able to insert rows into a table using the web2py admin interface. FREE ACCESS
-
7. Using the web2py Grid Widget6m 28sUpon 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
-
8. Searching for Data Using a web2py Grid9m 11sIn this video, you will learn how to use the web2py grid to search the contents of a database table. FREE ACCESS
-
9. Course Summary2m 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.
