Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Build Library Management System | Python & PyQt5
Rating: 4.0 out of 5(233 ratings)
17,803 students

Build Library Management System | Python & PyQt5

Build Library Management System With Python & PyQt5 & MySQL , Generating Excel Reports , Users , App Themes
Created byMahmoud Ahmed
Last updated 4/2020
English

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

Course content

2 sections • 40 lectures • 6h 31m total length

  • Course Introduction5:36
  • Join The Community0:08
  • Tools Setup4:51
  • Project Structure4:34
  • Design Our UI Structure10:42
  • Designe Day to Day Operations Tab5:35
  • Design Book Tab10:30
  • Design Users Tab6:56
  • Design Settings Tab5:46
  • Design Themes Tab5:45
  • Connect Our UI To Python Code9:11
  • Design Our DB On MySQL Workbench8:40

    Design a library database on MySQL Workbench, create tables for books, users, and day-to-day operations, plus categories, authors, and publishers, and connect the code with a username and password.

  • Coding The Main Buttons13:29
  • Coding Settings Tab16:18
  • Show Settings Data In TableWidget Part 110:13
  • Show Settings Data In TableWidget Part 25:45
  • Retrieving Settings Data In All Combobox9:49
  • Add New Book Tab14:37
  • Add Books Search9:22
  • Edit & Delete Book13:39
  • Adding Users Part 117:49
  • Adding Users Part 212:58
  • Add App Themes18:13
  • Adding CLients Tab15:19
  • Add New CLient10:59
  • Search , Edit , Delete CLient15:42
  • Show All Clients & Books12:12
  • Fixing Issues In The Project16:10
  • Adding Day-To-Day Operations Tab Part 121:43
  • Adding Day-To-Day Operations Tab Part 29:18
  • Design Login Window4:20
  • Add Login To Our Project9:57
  • Add Export Buttons In The Design3:44
  • Enable Export To Excel Part 113:53
  • Enable Export To Excel Part 29:25
  • Fixing Themes Window Issue in UI3:26

Requirements

  • only python basics

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

Who this course is for:

  • any one want to build awesome desktop applications with python

Report abuse