Create a CRUD Contacts Database App with Python and SQLite
What you'll learn
- Setup Python
- Setup SQLite
- Create database and table
- Import from tkinter module
- Create logo image
- Create application window
- Create application Graphical User Interface -GUI
- Create class and methods
- Add and position Widgets
- Connect application GUI to SQLite Database
- Set and fix size for application window
- Perform CRUD Operations from app GUI
Course content
- Preview01:48
- Preview05:16
- 04:34Installing Python on windows
- 06:57Installing Python3 on a mac
- Preview03:57
- 07:31What is SQLite
- 06:40Download and install SQLite
- 05:34Install DB browser for sqlite
- 06:27Create a database and table
Requirements
- Basic knowledge of SQL and SQLite
- Basic knowledge of Python
Description
Python is a dynamic modern object -oriented programming language that is easy to learn and can be used to do a lot of things both big and small. Python is what is referred to as a high level language. That means it is a language that is closer to humans than computer.It is also known as a general purpose programming language due to it's flexibility.
We are going to use the SQLite database which is a light and portable database system. It is ideal for small projects.
We will interact and perform various CRUD (Create|Read|Update|Delete) operations on the SQLite database from our application graphical user interface.
In this course,you learn the basics of graphical user interface (GUI) programming. The primary GUI toolkit we will be using is Tk, Python’s default GUI. We’ll access Tk from its Python interface called Tkinter (short for “Tk interface”).Tkinter is Python’s default GUI library Python, along with Tkinter, provides a fast and exciting way to build useful applications
We will be creating a contacts database application that we can use to store a list of contacts.
Who this course is for:
- Ne-wish beginners to Python
- Ne-wish beginners to SQL and SQLite
Instructor
![Bluelime Learning Solutions](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 17,340 Reviews
- 406,108 Students
- 221 Courses
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.