John Elder
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.
You’ll learn…
What Is A Database
How To Install Python
How To Install Git Bash Terminal
How To Use SQLite in a Python Program
How To Connect to Database in Python
How To Create A Database
How To Create A Table
How To Insert One Record Into Table
How To Insert Many Records Into Table
Understanding Data Types
How To Select Data From Table
How To Format Your Results
How To Use The Where Clause
How To Use The Like Clause and Wildcards
Instructor Details
Courses : 46
Specification: Intro To SQLite Databases for Python Programming
|
12 reviews for Intro To SQLite Databases for Python Programming
Add a review
| Price | $17.99 |
|---|---|
| Provider | |
| Duration | 1.5 hours |
| Year | 2021 |
| Level | Beginner |
| Language | English ... |
| Certificate | Yes |
| Quizzes | No |
$17.99
Benjamin Thrower –
Great course. Learned a lot.
Chenju Chen –
this is very simple class ,not very useful information
James McLaughlin –
Good course, having to modify instructions for my raspberry pi application.
Bill McKiddy –
It covered the basics as advertised. The instructor clearly enjoys teaching through these courses and explains things clearly.
Kempynck Jan –
Ja prima
Einar Wedoe –
Great stuff for a newcomer as I am to SQLite. This was excatly what I needed. The only reason for the last star being half, is that I feel the course could have covered a few more functions. But as an intro to Python and SQLite this is a good as it gets!! : )
S Berlin Brahnam –
First this whole thing is on youtube and second it does not give enough information to do anything.
Aashish Kumar –
The lectures were very much comfortable to understand and were full of knowledge. This is kind of an introduction to SQLite3 with Python course so do not expect a lot from this course. But if you want to begin with SQLite3 in Python, it’s a worthy course to take. Thanks!
Christian Rhein –
I get that this was aimed at a beginner but delivery was amateurish. It gives the impression that no effort was put into this video whatsoever and was cobbled together in a hurry to advertise his company. To me that shows a lack of respect for those who want to learn something and expect professionalism, especially if one pays for a course. I can look at amateur videos on youtube for free. Sometimes the instructor did not know what he was talking about. ‘Fetchone’ does not fetch the last item in the query but one item (the clue is in the name), even when this was corrected in a later video it still gives the impression that he did not make a plan where he want to go and what exactly we want to say and teach and you have to wonder whether he even knows his stuff (especially when you make blunders like that) When we reached the part about formating the output we also get the impression that our instructor is a bit clueless. The last line of the print out did not format as expected and he had no answer to that, so all we get to hear is, well you get the gist. Sorry that is not good enough not even for a beginner. If you had made a plan and tried out your code before you made the video that sort of stuff would not have happened or you could have researched how to correct this.
Stock Wang –
Great to Me
Tyler Vidricksen –
This was nice little course. It’s quick and to the point. If you are a beginner python coder and are just beginning to dabble in SQL, starting here is a good idea. .You’ll learn how to execute basic CRUD operations and learn how to call them inside functions. I do wish the course was a little longer though. The course is far from complete. There are several more topics in the python docs I wish were covered here (since the docs are cryptic for a newbie)… that said, the course is good enough to get me started.
Alex Ward –
Having previously covered the basics of SQL, this course is great at applying those fundamental concepts within a Python context. Exactly what I was looking for!