Python #41: SQLite Database Connection using Python | Tutorial by APDaga

Python #41: SQLite Database Connection using Python | Tutorial by APDaga
These days everyone is focusing on learning at least one of the programming languages. As it is said that learning a programming language helps in developing logical & analytical thinking. 

Out of all programming languages, I choose Python. Python is easy to understand for a new bee and it is having vast applications at the same time. 

Here, I am will be teaching/explaining Python from the scratch. Even a person from a non-technical background would be able to learn and understand all the python tutorials for sure.

Follow this free Python tutorial series in a proper sequence in order to get an in-depth understanding. It is advised to do the practice along with watching the video. 

Click Here to check out all Python Tutorials by APDaga.

{tocify} $title={Table of Contents} 
Recommended Python Courses:
1. Udemy: Top Python Courses
2. Udemy: 2021 Complete Python Bootcamp From Zero to Hero in Python
3. Udemy: Learn Python Programming Masterclass
4. Coursera: Python for Everybody
5. LinkedIn: Become a Python Developer
6. edX: Programming for Everybody (Getting Started with Python)
7. edureka: Python Programming Certification Training
8. Eduonix: Mighty Python Bundle


NOTE:
    • Video is in the English language (So, maximum people can take its advantage)
    • All the Jupyter Notebooks from each video are attached at the bottom of the post.
    • Only watching a video won't make you a developer. You should practice along with the video tutorial.

Technical Details:

    • Software Used: Anaconda (Latest Version) - Jupyter Notebook
    • Programming Language: Python 3.9 (or latest version)
    • Operating System: Windows 7, 8+, 10, 11 / Mac OS / Linux

Topics Covered:

    • What is an SQLite database?
    • Why and Where SQLite databases are used?
    • Python code to connect to SQLite database
    • How to create a new SQLite database using python code?
    • How to create a new SQLite table using python code?
    • How to insert new records  SQLite table using python code?
    • How to update the existing records in the SQLite table using python code?
    • How to delete the records from the SQLite table using python code?
    • How to delete the SQLite table using python code?
    • How to close the SQLite connection safely?

Tutorial Video:



Jupyter Notebook:

--------------------------------------------------------------------------------

Keep learning and make good use of what you learn. 
Feel free to share your thoughts about this post in the comment box below. 
and always remember
"With great power & knowledge comes great responsibility"

--------------------------------------------------------------------------------

Click here to learn Handwriting Analysis in detail for free.
&
Click here to see solutions for all Machine Learning Coursera Assignments.
&
Click here to see more codes for Raspberry Pi 3 and similar Families.
&
Click here to see more codes for NodeMCU ESP8266 and similar Families.
&
Click here to see more codes for Arduino Mega (ATMega 2560) and similar Families.

Feel free to ask doubts in the comment section. I will try my best to answer it.
If you find this helpful by any means, like, comment, and share the post.
This is the simplest way to encourage me to keep doing such work.

Thanks & Regards,
-Akshay P Daga

Post a Comment (0)
Previous Post Next Post