MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Using Databases in Python

Course Summary

When you want to store data from a program, you have two general choices: files or databases. In this course, we're going to explore using a database from within Python by using the excellent ORM Peewee. We'll build a command line diary application that stores our thoughts and notes in a SQLite database, lets us review and delete them, and even has a search feature!

  • +

    Course Syllabus

    Meet Peewee

    One way of interacting with a database from Python is to use the Peewee ORM. An ORM, or Object Relational Mapping, turns database tables into Python objects and vice versa. Let's see how to create tables and manipulate data in them. 7 steps
    • Meet Peewee, Our ORM 1:46
    • ORM 5 questions
    • Modeling 6:45
    • Create Table 4 objectives
    • Creating Databases and Tables 2 questions
    • Queries Are Your Friend 9:28
    • First Queries 4 objectives

    Our Diary App

    Now that we understand Peewee, let's build the app that we're here to build. We want an application we can run from the command line that we can read, write, and delete entries through. 6 steps

    Gettin' CRUD-y With It

    It's time to build the real core of our application. Let's capture entries and save them, show them, search them, and delete them! 8 steps

Course Fee:
USD 25

Course Type:


Course Status:



1 - 4 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url