Build Complete Doctor appointment App | Python Pyqt5 SQLite

Focused View

Muthu Manavandi

4:16:15

417 View

1. Introduction

1. Introduction.mp4

08:08

2. Install Python.mp4

03:50

3. Install Pyqt5 and pyqt5-tools.mp4

02:51

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

06:16

5. Create Desktop shortcut to Qt Designer.mp4

02:26

2. Interface creation process - Login from

1. Design a login form. We will design a form toe get input from the admin..mp4

19:19

3. Interface creation process - Main for design

1. Creating the sidebar menu to access all the tabs of the project..mp4

14:43

2. Creating appoint booking input details form design.mp4

15:05

4. Interface creation process - Edit appointment form design

1. Design the edit appointment form using Qt Designer.mp4

18:21

5. Interface creation process - Reports form design

1. Design the reports page with QTableWidget and QDateEdit control.mp4

11:34

6. User interface files and images for this project

1.1 1.zip

1.2 2.zip

1.3 3.zip

1.4 4.zip

1.5 appointment_login.zip

1.6 appointment.zip

1.7 background2.zip

1.8 background3.zip

1. User interface file.html

7. Create python file to interface with ui file

1. Create python file to connect with user interface ui file.mp4

09:34

8. Login and logout section

1. Create login function to get admin password and login to main form.mp4

06:42

2. Create logout function and go back to logion form from all three tab pages.mp4

03:48

9. Creating icon links to all pages

1. Write functions to link with all side bar icons to connect with pages.mp4

10:54

10. Installing DB Browser

1. Learn how to install DB Browser to view SQLite data base and tables.mp4

05:24

11. Create SQLite Database and table

1. Create Sqlite database and table.mp4

08:42

12. Appointment Booking Process

1. Generate appointment id.mp4

10:55

2. Insert given details in the database.mp4

17:24

13. Appointment Editing process

1. Fill all appointment id in the combo box.mp4

06:49

2. Fill name, city, booked time, status of appointment are displayed for id.mp4

15:45

3. Update details in the database.mp4

13:27

4. Delete an appointment from appointment table.mp4

07:50

14. Generating reports

1. Display complete reports.mp4

19:09

2. Display date wise reports.mp4

11:19

15. Hiding the tab bar

1. Hiding the tab bar.mp4

06:00

16. Project code

1.1 appointment.zip

1. appointment.py source code.html

Description

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

Who is this for?

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

More details

Description
Hello Students

Thank 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 course

By 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 connectivity
You 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 develop
You can create INSERT, UPDATE, DELETE, SELECT sql operations for any project you will develop
You can easily create beautiful user interface for any kind of application you want to develop
You 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**...
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Hello Students I am G.Muthu manavandi. I am working as computer course instructor in Sanyu academy from 2006 to till date. I am teaching C, C++, Java, PHP, Python, MS Office, Corel draw, Photoshop, Tally ERP and all computer course.My courses are very useful for all kind of learners because I teach every concept slowly and make the students understand easily.I hope my course will be very useful and provide good benefits for your job and career.If you are interested in Python, I would suggest the following course to get a real time software development experience. This course teaches the basic to advanced concepts to develop a Complete project in Python pyqt5 GUIBuild School Management System | Python, PyQt5 & Qt DesignerIf you want to learn mysql database programming through Python Pyqt5 and if you want to use it in all your project, I suggest to take Python Pyqt5 Database Programming with MySql in Qt DesignerThank you

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.