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.
What You Will Learn
- 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
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.
About The 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.
Table of contents
- Chapter 1 : Installation
- Chapter 2 : Using SQLite With Python
- Chapter 3 : Build A Simple Database App with Python
- Title: Introduction to SQLite Databases for Python Programming
- Release date: May 2019
- Publisher(s): Packt Publishing
- ISBN: 9781838982867
You might also like
Programming with Data: Python and Pandas LiveLessons
5 Hours of Video Instruction Learn how to use Pandas and Python to load and transform …
Python, SQL, and Tableau: Integrating Python, SQL, and Tableau
Python, SQL, and Tableau are three of the most widely used tools in the world of …
The Complete Python and PostgreSQL Developer Course
Ever wanted to learn one of the most popular programming languages on the planet? Why not …
Python 3: Project-based Python, Algorithms, Data Structures
This course is one of the most comprehensive and beginner-friendly courses on learning to code with …