|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-complete-project/
课程评论：没有评论
**课程名称：** 使用 Python、PyQt5 和 SQLite 构建完整的医生预约应用程序 **课程概览：** 本课程旨在帮助您成为一名精通 Python GUI 编程的专家，并能独立开发完整的 Python GUI 项目。您将通过一个实际的医生预约应用程序，学习如何掌握 PyQt5 界面设计、Python 编程以及 SQLite 数据库连接和 SQL 语句。 **学习内容：** * **环境搭建：** 学习安装和配置 Python, PyQt5, PyQt5-tools, DB Browser, 以及可选的 Visual Studio Code，并掌握 Qt Designer 的使用。 * **GUI 设计：“** 使用 Qt Designer 设计美观的登录界面，并学习如何用 Python 验证用户凭据。 * **数据库操作：** 学习通过 Python 代码创建 SQLite 数据库和表，并使用 SQLite Browser 查看数据。 * **预约系统核心功能：** * 使用 Qt Designer 设计医生预约详情录入界面，并将数据存储到 SQLite 数据库。 * 学习如何编辑预约信息，包括姓名、城市、电话、预约时间、状态等。 * 掌握使用 UPDATE 和 DELETE SQL 语句更新和删除数据库中的记录。 * **报表功能：** * 创建报表界面，并实现按日期过滤显示报表。 * 学习 SQL 中的日期函数和 SELECT 查询语句。 * **Python 基础：** * 巩固 Python 的输出语句、条件语句、for 循环、列表以及数据库连接等核心知识。 * **PyQt5 组件和样式：** * 学习如何在 QLabel 中设置和适配图片。 * 掌握 PyQt5 中常用的控件，如 QLineEdit, QPushButton, QLabel, QTableWidget, QDateEdit, QFrame, QComboBox 等，并了解如何将它们添加到项目中。 * 学习如何为 Qt Designer 控件创建样式表（Stylesheet），包括边框、背景、透明度、字体样式、圆角、下边框和内边距等 CSS 样式，并实现控件的悬停效果。 * **数据库操作深入：** * 熟悉数据库的创建（Create Database）、创建表（Create table）、插入数据（Insert into）、查询数据（Select * from, Select max(id) from）、更新数据（Update table）、删除数据（delete from）等操作。 **课程收获：** 完成本课程后，您将能够： * 独立开发属于自己的约会预订应用程序，适用于任何业务。 * 为任何项目设计所需的数据库和数据表。 * 为任何项目创建 INSERT, UPDATE, DELETE, SELECT SQL 操作。 * 轻松为任何应用程序创建美观的用户界面。 * 轻松创建 Python 函数以连接 Qt Designer 控件。 * 根据需求修改本项目，并将其交付给客户。 **立即加入，开启您的 Python GUI 开发之旅！**
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...
