Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 31 Minute(s)
Language
English
Taught by
Mahmoud Ahmed
Rating
Course Overview
Build Library Management System With Python & PyQt5 & MySQL , Generating Excel Reports , Users , App Themes
In this course you'll learn how to build a Library System with PyQt5 and Python!
PyQt5 is one of the best frameworks for developing desktop applications that looks awesome
In this course I'll be developing on a my Mac machine, but you should be able to follow along if you're on a Windows or Linux. I'll show you how to download and install Python and PyQt5
You'll be able to build Desktop Applications and simple business Applications when you're finished with this course.
we will build a library system with:
adding new books
adding books categories
adding books Author
adding books Publisher
adding day to day operations for rent or retrieving books
Generate Excel reports from our data
Adding new users with user login and editing user data
WHAT DO YOU NEED TO TAKE THIS COURSE?
You don't need any tools or special skills to take this course. I'll show you how to download and install everything you'll need for free (PyQt, Python, and the Pycharm).
DO I NEED TO KNOW PYTHON TO TAKE THIS COURSE?
simple python basics! it's a good idea to learn Python if you want to use PyQt5. But you don't have to know advanced Python to take this course. I'll walk you through everything you need to know.
Building desktop applications with PyQt5 is very easy , and the course will make it very fun
What you’ll learn
Installing Python
Installing PyQt5
Installing MySQL Server
Design nice desktop applications with QtDesigner
Styling desktop applications with CSS
Design a database using mysql workbench
Connecting to mysql database with python
inserting , selecting , updating , deleting database data from our app
Adding project themes and change between them easly
Adding new users
Updating user data
Login at startup
Are there any course requirements or prerequisites?
simple python skills is needed
Who this course is for:
This course is aimed towards absolute beginners who want to learn how to build desktop applications with PyQt5 and Python
Course Content
- 2 section(s)
- 40 lecture(s)
- Section 1 Library System With Python & PyQt5 & MySQL
- Section 2 Install on Client Machine
What You’ll Learn
- Installing Python, Installing PyQt5, Installing MySQL Server, Design nice desktop applications with QtDesigner, Styling desktop applications with CSS, Design a database using mysql workbench, Connecting to mysql database with python, inserting , selecting , updating , deleting database data from our app, Adding project themes and change between them easly, Adding new users, Updating user data, Login at startup
Skills covered in this course
Reviews
-
RRamesh Chakali
Very nice one
-
AArthur Sullivan
Instructor is hard to understand, the sub-titles are jibberish and need to be edited to show the correct instruction. If utilizing MySql there needs to be a video on how to configure the options and accounts to set it up. Also need to point out that mysql-workbench-community-8.0.42 is only compatable with mysql-installer-community-8.0.42.0 not mysql-9.3.0. Other than those annoyances the course is providing all of the fundamentals that are needed to program PyQt5, sql and Python.
-
JJacques Heine
Beaucoup de bonnes idées et d'informations à exploiter. Assez chaotique. les fichiers fournis ne correspondent pas à l'exposé. Les commentaires en anglais sont incompréhensibles et les sous-titres sont inexploitables.
-
MMehmet Kirez
This course is useless to build a library system. It has some logical and some coding problems. Logical problem about day to Day Operations, you choose retrieve or rent and how many days so logicaly if you choose retrive a book should turn but it shown like rent, for example a book retrive 2022-05-30 to 2022-06-05. İf We choose retrive a book should delete on databae or something else. Another problem is program has realy bad coding, If you have to use data from database and you entered wrong data program is crush. For example when you search a book to editing book if you entered a name which is not in database program is closed otomaticaly, it is same all edit sections and day to day operation section. Instructor recorded videos a few years ago but i think he did nothing about this logical issues
