Course: 22 Videos
Length: 1.5 Hours
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 courses I’ll 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 we’ll build a very basic app to help reinforce all the things we learning along the way.
I’ll walk you through all of this and more, step by step. If you have any question along the way, I’m here to answer them.
If you’ve ever wanted to understand SQLite databases or use them in your Python programs, this is the course for you.
We’ll download everything you need for this course for free, you don’t need any special tools!
See you inside!
|Module 1||Using SQLite3 Databases With Python|
|Unit 1||Introduction | Video 1|
|Unit 2||Install Python | Video 2|
|Unit 3||Install Sublime Text & Git Bash Terminal | Video 3|
|Unit 4||Create SQLite Connection | Video 4|
|Unit 5||Create A Database Table | Video 5|
|Unit 6||Insert One Record Into The Table | Video 6|
|Unit 7||Insert Many Records Into The Table | Video 7|
|Unit 8||Query and Fetchall | Video 8|
|Unit 9||Format Results | Video 9|
|Unit 10||Primary Key ID | Video 10|
|Unit 11||Where Clause | Video 11|
|Unit 12||Update Records | Video 12|
|Unit 13||Delete Records | Video 13|
|Unit 14||Order Results By | Video 14|
|Unit 15||And / Or | Video 15|
|Unit 16||Limiting Results | Video 16|
|Unit 17||Drop Table | Video 17|
|Unit 18||Our App - Show All Function | Video 18|
|Unit 19||Our App - Add A Record Function | Video 19|
|Unit 20||Our App - Delete a Record Function | Video 20|
|Unit 21||Our App - Add Many Records Function | Video 21|
|Unit 22||Our App - Where Clause Function | Video 22|