Python - Databases and Desktop Application Creation
This course is ideal for anyone who already has a basic knowledge in Python coding and wants to learn how to develop high-level softwares using the world's most widely used programming language. The course will provide a comprehensive understanding of databases by creating a database in PostgreSQL and managing it from Python code. The second half of the course will focus on the creation of user interfaces using PyQt5. The lesson will take place in an interactive and practical format, alternating between theory and exercises, where the students can apply their knowledge into practice.
Content
- Database theory
- Basic SQL queries
- Integration of Python with a PostgreSQL database
- Desktop application UI using PyQt5
Learning Outcomes
On completion of this course, participants will learn:
- To setup a PostgreSQL database
- To manage the database from Python code
- To perform simple queries to retrieve/update data
- To create a graphical Ul using PyQt5
Training Method
This course is designed in an interactive format that includes theoretical presentations as well as practical exercises to be completed both during the lesson and at home. The participants will build a project throughout the week with the knowledge acquired during each day of the course.
Certification
Participation OnlyPrerequisites
- Basic knowledge in Python coding
- Having completed the module "Python - Object Oriented Programming"
Planning and location
09:00 - 13:00
09:00 - 13:00
09:00 - 13:00
09:00 - 13:00
09:00 - 13:00
Learning Track
This course is part of the following learning track(s) and can be booked as a stand-alone training or as part of a whole:
ESCO Skills
ESCO Occupations
Your trainer(s) for this course
Ana GAGGERO
Ana Gaggero holds a Ms degree in Computer Sciences from the University of Luxembourg.
She has 10 years of experience in software
development, mainly in Adobe products related projects. She has been teaching at DLH since 2024 and also teaches programming for children.