Skip to main content

Learn

  • Understand how to use SQLite databases with Python
  • Understand the basics of what a database can do.
  • Install Python, SQLite, Sublime Text, and Git Bash
  • You'll learn how to create a database and table
  • How to put data in and take data out using Python
  • How to update and delete data from a database
  • How to explore what's in a database whenever you want
  • How to create basic reports with data from your database

About

These days, everything uses a database, and SQLite is one of the most popular databases out there. Free and open-source, SQLite is a great database for smaller projects, hobby projects, or testing and development.

Likewise, Python is one of the most popular and powerful programming languages today. Pairing the two together is a powerful combination!

In this course you'll learn the basics of using SQLite with Python.

You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.

For this course, we assume you already have a basic knowledge of Python programming, but you don't need to know anything at all about databases or SQLite to take the course.

At the end of the course, you'll build a very basic app to help reinforce all the things you learned along the way.

Style and Approach

This course is packed with step-by-step instructions and working examples.

Features

  • Learn how to use SQLite databases with Python
  • Learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.

Course Length : 1 hour 27 minutes

ISBN : 9781838982867

Requirements

Add information about the skills and knowledge students need to take this course.

Author

John Elder

John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries. John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.

Frequently Asked Questions

What web browser should I use?

The Open edX platform works best with current versions of Chrome, Firefox or Safari, or with Internet Explorer version 9 and above.

See our list of supported browsers for the most up-to-date information.

respond
hours per week
respond
Free
respond
RPS
respond
en

Share this course

Categories

Data Science(241)

Coding and Tools(37)

Admin and Cloud(380)

DevOps(78)

Programming(631)

Application Development(754)

Web Development(547)

Big Data and Analytics(709)

Soft Skills(19)

Network Security & Infrastructure(285)

Process Concepts(8)

Database(80)

Business Intelligence(22)

I've read enough.Take me to RPS