Coding

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 Only
Prerequisites
  • Basic knowledge in Python coding
  • Having completed the module "Python - Object Oriented Programming"

Planning and location
Session 1
01/12/2025 - Monday
09:00 - 13:00
Session 2
02/12/2025 - Tuesday
09:00 - 13:00
Session 3
03/12/2025 - Wednesday
09:00 - 13:00
Session 4
04/12/2025 - Thursday
09:00 - 13:00
Session 5
05/12/2025 - Friday
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 Occupations
Available Edition(s):

https://www.dlh.lu/web/image/product.template/1955/image_1920?unique=298b716

This combination does not exist.

80.00 € 80.0 EUR 80.00 €

80.00 €

Not Available For Sale

Your trainer(s) for this course
Ana GAGGERO
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.