Build Complete Doctor Appointment App | Python Pyqt5 Sqlite

Develop Complete Doctor Appointment Booking App with Python, PyQt5 & SQLite3 using QT Designer step by step from scratch

What you'll learn

Master the Python GUI programming language by developing a complete software for doctor / hospital appointment booking, editing and report generating

Able to design beautiful interfaces (GUIs) for any application in Qt Designer. You will learn all requirements to design beautiful interfaces with hover effects

Add this project in your Portfolio or in your resume when you apply for python developers jobs. you will learn complete step by step codes to develop this app.

Able to create database, tables and how to connect the front end and back end using Python code.

Design beautiful interfaces for data science, machine learning, deep learning and IOT projects to show data, images and hover effects.

Learn GUI design, database design, table design and you will learn the communication process between the GUI application and slite3 database using python code

You will be able to develop a filly functioning application for any business using Python, Qt Designer and SQLite Database

Learn the CRUD database operations (CREATE, READ, UPDATE, DELETE) in SQLite3 database using this project.

Able to design database, tables for any application you want to develop yourself

Learn how to get data from GUI interface, how to add events to GUI controls and you will learn how show data in a GUI table which is collected from database

Requirements

Basic programming is enough

Need a laptop or desktop computer with internet connection

Description

Hello StudentsThank you very much for showing interest in this course.Welcome to the course Build Complete Doctor appointment App development in Python, Pyqt5 using SQLite database.Do you want to become an expert in Python GUI programming?Do you want to develop a complete Python GUI project to add it in your resume or in your portfolio?Do you want to learn SQLite database connectivity  with Python and Learn SQL statements through a real time project?Do you want to develop an appointment booking application for your client?then you are in the right courseBy joining this course,First you will learn how to install Python, Pyqt5, Pyqt5-tools, DB Browser, Visual Studio Code (it is optional) and configure the qt designer to desktop.Then you will learn How to create a beautiful login form design using Qt Designer that contains a password input and verify if it is correct or wrong using Python programming.Then you will learn how to create SQLite database and tables through python code and how to view all data through SQLite browser.Then we will be moving to create a beautiful doctor appoint details input form using Qt Designer and store the data entered in SQLite database. Then you will learn how to edit the doctor appointment like how to edit the booking name, city, phone number, booked time, status of appointment and you will learn how to Update or Delete the details from the database using update and delete SQL queries.Then you will learn how to create reports form and show report using date filter. For this you will learn how to design SQL date and SQL Select queries.Then you will learn Python output statements, Python conditional statements, Python For loops, Python lists and Python database connectivityYou will also learn how to set images in QLabel and how to make it fit inside the QLabel component.You will learn Qt Designer Widgets like QlineEdit, QPushButton, QLabel, QTableWidget, QDateEdit, QFrame, QComboBox controls and add them to our project.You will learn database operations like Create Database, Create table. Insert into, Select * from, Select max(id) from, Update table, delete from, operations to use in this project.You will learn how to create style sheet for Qt Designer Controls and your will learn how to create hover effects for the controls in this project.·You will learn the css styles for borders, background, opacity, font style, border-radius, border bottom and padding to implement in our project controls.After completing this course,You can build your own Appointment booking app for any business.You can design the required database, tables to any kind of project you want to developYou can create INSERT, UPDATE, DELETE, SELECT sql operations for any project you will developYou can easily create beautiful user interface for any kind of application you want to developYou can easily create Python functions to connect with qt designer controls.You can edit this project for any other purpose and deliver to the clients.Then why are you waiting…Join this course immediately…I will see you in the course..Thank you very much…

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Install Python

Lecture 3 Install Pyqt5 and pyqt5-tools

Lecture 4 Install visual studio code ( Optional ) - You can use any editor

Lecture 5 Create Desktop shortcut to Qt Designer

Section 2: Interface creation process - Login from

Lecture 6 Design a login form. We will design a form toe get input from the admin.

Section 3: Interface creation process - Main for design

Lecture 7 Creating the sidebar menu to access all the tabs of the project.

Lecture 8 Creating appoint booking input details form design

Section 4: Interface creation process - Edit appointment form design

Lecture 9 Design the edit appointment form using Qt Designer

Section 5: Interface creation process - Reports form design

Lecture 10 Design the reports page with QTableWidget and QDateEdit control

Section 6: User interface files and images for this project

Lecture 11 User interface file

Section 7: Create python file to interface with ui file

Lecture 12 Create python file to connect with user interface ui file

Section 8: Login and logout section

Lecture 13 Create login function to get admin password and login to main form

Lecture 14 Create logout function and go back to logion form from all three tab pages

Section 9: Creating icon links to all pages

Lecture 15 Write functions to link with all side bar icons to connect with pages

Section 10: Installing DB Browser

Lecture 16 Learn how to install DB Browser to view SQLite data base and tables

Section 11: Create SQLite Database and table

Lecture 17 Create Sqlite database and table

Section 12: Appointment Booking Process

Lecture 18 Generate appointment id

Lecture 19 Insert given details in the database

Section 13: Appointment Editing process

Lecture 20 Fill all appointment id in the combo box

Lecture 21 Fill name, city, booked time, status of appointment are displayed for id

Lecture 22 Update details in the database

Lecture 23 Delete an appointment from appointment table

Section 14: Generating reports

Lecture 24 Display complete reports

Lecture 25 Display date wise reports

Section 15: Hiding the tab bar

Lecture 26 Hiding the tab bar

Section 16: Project code

Lecture 27 appointment.py source code

If you are a student or a developer want to develop a complete software from the beginning to end,If you know basics of python programming and want to improve your skills by developing a best software,If you are want to convert the python program output into a GUI to present nicely,College students who want to develop their projects themselves in python,To show your IOT programming output through GUI in the Computer,To learn how to develop an appointment booking application using python programming