AU$24.99
per month
Video
May 2019
1hr 27mins
1st Edition
-
Learn how to use SQLite databases with Python
-
Create databases and tables
-
Insert, sort, and extract specific data
Free and open-source, SQLite is a popular database among developers for smaller projects, hobby projects, and even testing and development. When used with Python, one of the most powerful programming languages, they make a powerful combination.
In this course you'll learn the basics of using SQLite with Python. You'll get started with installing Python and SQLite. The course will then get you up to speed with creating databases and tables. To help you build on your knowledge further, you’ll get comprehensive insights into working with tables, including adding, updating, and retrieving specific data using standard SQLite commands. Finally, you’ll build a basic app to help reinforce all the things that you’ve learned through the course.
By the end of this course, you’ll have hands-on experience in effectively using SQLite with Python.
This course is designed for anyone who wants to use SQLite databases with Python. Although a basic understanding of Python programming is assumed, knowledge of databases or SQLite is not mandatory.
-
Explore the fundamental aspects of what a database can do
-
Install Python, SQLite, Sublime Text, and Git Bash
-
Gain practical knowledge by building an app Update and delete data from a database
-
Discover the technique of creating basic reports with data from your database