Python SQLite Data Entry Form with Tkinter tutorial for beginners - Python GUI project

SQLite Data Entry form with Python tutorial for beginners. Python GUI project for beginners. Learn how to create a responsive data entry form with Tkinter and add the data to an SQLite database.
Learn SQLite 3 with Python. Learn how to launch and create your first Data Entry GUI for Python programs and desktop applications.
Part 1 (Tkinter GUI) • Tkinter Data Entry For...
In this tutorial, you will learn how to use Tkinter, Python, and SQLite to enter data to an SQLite database using your data entry form. You will:
- Install and setup DB Browser
- Create a new SQLite database file with Python
- Create SQLite table with Python
- Insert data to SQLite table with Python
Source code: github.com/codefirstio/tkinte...
For more info:
Install and Setup Tkinter for beginners: • Install and Setup Tkin...
Playlist link: • Tkinter tutorials
Timestamps:
00:00 Introduction and overview
01:58 Intro to SQLite and DB Browser
03:00 Recapping the previous video
03:52 Creating an SQLite database with Python
05:08 Creating an SQLite table with Python
08:21 Inserting data into the SQLite table
Socials:
My email: [e-mail]
Tiktok: / hala.codes
*************
*Tags*
Tkinter tutorial
Tkinter Data Entry
Data Entry form Tkinter
Tkinter install
Tkinter Setup
Tkinter GUI tutorial
GUI tutorial Python
GUI Project Python
Graphical User Interface Python
Python tutorial
SQLite Python
Python SQLite tutorial
Python SQLite3

[@kaduflutist]

Thank you, Hala! You're an excellent instructor and coach. I'm so thankful and grateful for your time and expertise. Keep doing this great job!

[@novicetech1]

Absolutely outstanding tutorial! Thank you so much. I have been away from Python since 2018. I was only ever really interested in doing things with Tkinter and SQLite. When I finally got back to it this year (2023), I was shattered to discover that most of my knowledge was gone (that kinda comes with age). In an effort to review, I stumbled across your videos. I am so grateful to you. I now feel like I am back on my feet again with these technologies. Thank you, thank you, thank you.

[@zettkusanagi6322]

Thank you for this series. You go straight to the point and are very clear on instructions. I was able to understand Tkinter Layout thanks to your teaching. I am now checking other of your projects.

[@jimhess2590]

These videos were very, very helpful. I learned most of everything that I needed to move my project forward. Thanks!!!

[@user-ub3vy8rj4d]

Tack så mycket. Tydligt och mycket användbart. Lycka till.
Thanks so much. Clear and very useful. Good luck.

[@andresfelipebarrera5110]

Very helpful, finally I could advance in my project, very grateful!!

[@netreis1]

Perdi algumas horas buscando uma solução para o meu código e neste video ficou esclarecido. Parabéns!

[@user-ph5jv5nz7p]

Дай бог тебе здоровья
God bless you for your video, blyad'

[@user-ek1jf2ep2k]

Iam a newbee, I was looking for this, you nailed it Hala, looking forward to learn more from you, Shukran

[@Diogene-pl1lq]

Thanks alot Hala, I am improving my skills along your advices and teaching!
You are the data's fairy😉

[@jehoshaphatamihere9204]

Thanks very much madam, God bless you, You have made the code very simple to understand
you are my python teacher from now onward

[@Pattypatpat7122]

Amazing tutorial! I've learnt a lot in such a short period of time

[@rickyusuf8696]

Jazaaki Allahu khairan for the wonderful video! It was a great refresher for me, and the way you explained it was very easy to follow along and make sense of it.

[@Foiliagegaming]

Great video. I started following along and I was running into an error with the database where it was saying that a column did not exist. After staring at the code for to long trying to pin down what it was (assuming it was a typo) I called it quits for the day. Today I had the same error for a different column but was able to find the problem and it worked! Thank you!

[@garymaya1767]

i love you! thank you for the information!

[@sumitkumargupta1720]

Very helpful video. Thanks a lot.

[@ParadoxCheats]

amazing explanation of everything

[@fazilelectronics3080]

Thank you so much. I've learned a lot from your video

[@Gareth.W]

Amazing tutorial. Thanks so much for creating this.

[@fabiomatta1530]

Thank you very much for your work. Love the way you teach.

[@ziarasuli3102]

This Tutorial is really useful thanks alot.

[@paulsingirok4600]

Thankyou. This was very helpful.

[@Pythonmailservice]

Thank you!

[@eqsciencerayong2678]

thank u. for the best practices.

[@zooeymoments8516]

Totally helpful. I learned a lot.
Could be able to make new video how to retieve, edit and save back to database. It will mean a lot.

[@Sunilkumar-1564]

thank you so much 👍👍👍👍👍👍

[@perlasaadeh3322]

I'm passing because of you! THANK YOU!

[@codefirstwithhala]

Thank you for your support!

[@vinzenzglenk860]

Great video

[@kingmenka2085]

Hala
You are amazing keep up the good work

[@vaidheeswaranbharathy87]

Excellent

[@user-uq4ox9ki1f]

very useful tutorials

[@thecubanrelaxshitposting3733]

your videos are sooo great i love it

[@codefirstwithhala]

Thank you so much!

[@rzvn111]

Thanks!

[@2ncielkrommalzeme210]

Your Video with your teaching way is very good thanks İ ant to by a coffe in future.

[@steamersteamer1003]

I think you are awesome!

[@Frazur]

This was super helpful. Even though I am using mySQL, the syntax is almost the same. This really help guide me in the right direction

[@codefirstwithhala]

Glad it helped!

[@gregoneill4391]

@@codefirstwithhala is there a possibility of doing a PySimpleGUI version video??

[@TyphonNeuron]

Thanks for the tutorial so far. Can you continue with this data entry form and sqlite3 to show how to delete data from tables or how to export the table data into csv or json formats? Great videos, nice, celar explanations. Thanks again.

[@barackuse]

Great Video, what if we wanted to retrieve data from the DB? Will there be video on that?

[@deviskalo]

Thanks so much! You really did great work here. I am glad and appreciate your work.

[@its_code]

😍😍🤩🤩 very helpful 🖤

[@codefirstwithhala]

Glad you think so!

[@its_code]

@@codefirstwithhala 🤗🤩🤩😍

[@campfiregames4633]

Thank you

[@codefirstwithhala]

Welcome!

[@weikang234]

Hello Hala, can i check what are the extensions you use in VS Code for your Python? Mine does not have the same color coding as yours

[@autarroy]

Hello Hala,
First of all I would like to thank you for your kind explanation.
I'm doing exactly what you did but I get a question mark when creating my .db Could you help me?

[@kapibara2440]

Brilliant tutorial Hala ❤❤❤

[@SuperKevinFS]

HI thanks for a great course. I do not know how to connect sqlite (i use subline) and DB browser sqlite could you kindly point me in the right directions there is not much on this aspect of SQLITE thank u

[@alfiartya23]

Hi, I would like to say thank you with this video. It really helpful for my project. But I want to ask, when I want to take example user age which is a number/integer. Should I use .get() or convert it into int() that user age entry? because every entry input will always return string value. Thank you 😄

[@ryder4481]

age = int(user_age_entry.get())

[@gregoneill4391]

@Code First with Hala Hi I am trying to do this with a form for my project but it was with pysimplegui, I can get some success with this but I cant seem to get it to store the values in it. do you have a pysimplegui version of this?

[@horsfallprosper5909]

Which text colour editor are you using in your Vs code

[@dmskarunaratne80]

at the end of conn.close() clear data entry form with clear data function??

[@infernimus9563]

11:30 why don't you use the executemany method to execute multiple queries?

[@blendid242]

Hi, How change theme color text for sql code plz. I always an orange text :(

[@MohamedShams919]

how can i save the data to excel sheet on sharepoint?

[@Rapha_Carpio]

can we put these kind of apps on a html?

[@2ncielkrommalzeme210]

how can we encrypt our file in sqlite.??????

[@diegovilchesloyola6656]

How can you do an .exe?

[@user-cr3wz2fi3g]

Using the pyinstaller library

[@user-hn6xc9kh4j]

Why don't you present your content in the language of your country instead of using the English language to publish the content, silly girl

[@Zak-l7e]

Brilliant video, just another way of coding:
conn = sqlite3.connect('test1.db')
c = conn.cursor()
c.execute(
"CREATE TABLE IF NOT EXISTS Student_Form (Title string, First Name TEXT, Surname TEXT, Age INTEGER, "
"Nationality TEXT, Num_courses INTEGER, Num_semesters INTEGER)")
c.execute("INSERT INTO Student_Form VALUES (?,?,?,?,?,?,?)",
(title, first_name, last_name, age, nationality, num_courses, num_semesters))
conn.commit()
conn.close()