Udemy

Platform

English

Language

Programming Languages

Category

Build Library Management System | Python & PyQt5

Build Library Management System With Python & PyQt5 & MySQL , Generating Excel Reports , Users , App Themes

4.35 (162 reviews)

Build Library Management System | Python & PyQt5

Students

6.5 hours

Content

Apr 2020

Last Update
Regular Price


What you will 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


Description

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



Content

Library System With Python & PyQt5 & MySQL

Course Introduction

Tools Setup

Project Structure

Design Our UI Structure

Designe Day to Day Operations Tab

Design Book Tab

Design Users Tab

Design Settings Tab

Design Themes Tab

Connect Our UI To Python Code

Design Our DB On MySQL Workbench

Coding The Main Buttons

Coding Settings Tab

Show Settings Data In TableWidget Part 1

Show Settings Data In TableWidget Part 2

Retrieving Settings Data In All Combobox

Add New Book Tab

Add Books Search

Edit & Delete Book

Adding Users Part 1

Adding Users Part 2

Add App Themes

Adding CLients Tab

Add New CLient

Search , Edit , Delete CLient

Show All Clients & Books

Fixing Issues In The Project

Adding Day-To-Day Operations Tab Part 1

Adding Day-To-Day Operations Tab Part 2

Design Login Window

Add Login To Our Project

Add Export Buttons In The Design

Enable Export To Excel Part 1

Enable Export To Excel Part 2

Fixing Themes Window Issue in UI

Install on Client Machine

Install Our DB On Client Machine

Converting Our Project To exe

source code

Bonus Lecture


Reviews

C
Carlos16 April 2021

El curso en si es bueno pero le falta actualizar muchas cosas al tutor; como usar poi en vez del writer para exportar a excel ya que esta deprecado, también es mejor que de un paso genere las interfaces ui, porque en proyectos grandes sería demasiado complicado estar convirtiendo cada archivo uno por uno y luego modificando las clases ya existentes. también el curso mejoraría implementando un patrón de diseño en la estructura del proyecto, con esto para refactorizar el código. igualmente con el generador de exe esta muy antiguo. me ubiera gustado usar pyinstaller para aprender un poco de ello.

J
José6 February 2021

In general the course was very interesting, the use of Qt Designer and its integration in Python. I just thought that the part related to the daily movements is not correct since it does not use the database of books and clients in the transactions.

N
Naidja21 July 2020

Thank you so much sir for this course. Before taking it , i had some basics on python but now i feel that i can do with it more than i expected .

E
Emil18 April 2020

WORST TEACHER EVER. He doesn't care for those who ask questions or for people who, like me, have basic knowledge of Python. Lot of NOT answerd questions too. He doesn't explain much of what he's teaching. He would say: "you need this or that, go install it". If this course is for beginners as well, why don't you explain in detail, how to install (windows, mac) the modules or packages you are using? Absolutely ridiculous! As an example, here's his answer to the following question: Q: how to install pyqt5 designer on a mac? A: Download it from the site Come on, are you a joke? Answer is "download it"? This is what you've written in the description of the course: Q: Are there any course requirements or prerequisites? A: simple python skills is needed and Q: Who this course is for: A: This course is aimed towards absolute beginners who want to learn how to build desktop applications with PyQt5 and Python

A
Ahmed4 April 2020

Good course for beginner I recommend future courses to be more details and give an idea about relational databases thanks Ahmed

A
Albe27 June 2019

Muy interesante; aunque la traducción al español subtitulada no es buena. Es un curso altamente recomendable

K
Khushal26 April 2019

I am not able to find how to use designer for tabs because the instructor didn’t mention how to download and use designer for tabs for windows

M
Marc8 March 2019

This course is very good , I'm actually building a library management system of my own so it's great for me. The instructor is very thorough and has a good approach. Keep up the good work. Thanks

M
Mohamed22 January 2019

The project is superficial can not be used in the real life the project lack some points like: each book in the library should has stock (the library will has many copies of the same book so we should consider the quantity of each book in the database -For example if the customer borrow one book (ex:'Deep learning'), its stock it should be decreased by one -no option for inventory and trace the books - permissions for users not defined - no reports - no notification for the user to notify him about the books should be returned by the customer every day


Coupons

DateDiscountStatus
5/10/2019100% OFFExpired
6/29/2019100% OFFExpired
11/8/201934% OFFExpired
3/22/2020100% OFFExpired
4/3/2020100% OFFExpired

2131092

Udemy ID

1/6/2019

Course created date

5/10/2019

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram