Integrating Python with a Relational Database Training Course
This course presents a comprehensive approach to integrating Python applications with PostgreSQL databases. The program covers three key tools: the psycopg library for direct database communication, Pandas for tabular data operations, and the SQLAlchemy ORM for object-oriented data management.
Participants will learn how to securely execute SQL queries using parameterization to protect against SQL injection attacks. The course also includes integration with the Pandas library, enabling efficient loading and exporting of data between DataFrames and the PostgreSQL database.
A significant portion of the training is dedicated to SQLAlchemy. Participants will learn to define data models as Python classes, map them to tables, and perform all CRUD operations without writing raw SQL. They will also explore techniques for filtering, sorting, grouping data, and managing table relationships in an object-oriented manner.
Upon completion, participants will be able to select the appropriate tool for specific use cases, communicate securely with databases, and utilize both low-level SQL queries and high-level ORM abstractions. They will gain practical skills essential for daily database work in Python projects.
This course is available as onsite live training in Poland or online live training.Course Outline
Module I: psycopg Library
1. Configuring the connection to the PostgreSQL database
2. Review of SQL fundamentals
3. Executing database queries
4. Security - protection against SQL injection attacks
Module II: Pandas in the Context of Databases
1. Loading data from the database into a DataFrame
2. Exporting data from Pandas to PostgreSQL
3. Optimizing large dataset transfers
Module III: SQLAlchemy ORM
1. Configuring connections using SQLAlchemy
2. Defining data models as Python classes
3. The object-relational mapping mechanism
4. Adding records via class instances
5. Retrieving and displaying data from tables
6. Updating and deleting records
Requirements
Open Training Courses require 5+ participants.
Integrating Python with a Relational Database Training Course - Booking
Integrating Python with a Relational Database Training Course - Enquiry
Integrating Python with a Relational Database - Consultancy Enquiry
Testimonials (2)
Learning that the QGIS and a tool that can used by other different professionals such land survey
Bame Duncan Koko - Bentel Technologies (Pty) Ltd
Course - QGIS for Geographic Information System
How to use open satellites data for real applications
Tshering Dorji - Druk Holding and Investments
Course - Advanced Geographic Information Systems (GIS)
Provisional Courses
Related Courses
Testable Requirements - How to Write Good Acceptance Criteria?
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at intermediate-level business and IT professionals who wish to learn how to write effective acceptance criteria for requirements.
By the end of this training, participants will be able to:
- Understand the importance of acceptance criteria.
- Create and verify requirements acceptance criteria.
- Apply different methods for describing acceptance criteria.
- Ensure the quality of analytical artifacts.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level to advanced-level GIS professionals and analysts who wish to learn how to effectively use ArcGIS for data visualization, spatial analysis, and geospatial project management.
By the end of this training, participants will be able to:
- Navigate and utilize ArcGIS tools for geospatial data management.
- Create and customize maps with layers and attributes.
- Perform advanced spatial analysis and geoprocessing tasks.
- Automate workflows using ModelBuilder and Python.
ArcGIS Enterprise for Technical Support
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level IT support personnel who wish to provide robust support for ArcGIS Enterprise, addressing any anomalies or failures effectively.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn to install, configure, and manage ArcGIS Enterprise.
- Gain skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master the techniques for backup, recovery, and performance optimization.
ArcGIS Fundamentals
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level professionals who wish to learn the fundamental concepts and tools of ArcGIS.
By the end of this training, participants will be able to:
- Understand the basic concepts of GIS and spatial data.
- Navigate the ArcGIS interface.
- Create and manage spatial data.
- Perform basic spatial analysis.
- Create maps and visualizations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus is an advanced version of ArcGIS Pro, offering extended features for geospatial data analysis, 3D modeling, automation, and enterprise collaboration.
This instructor-led, live training (online or onsite) is aimed at intermediate-level GIS professionals who wish to deepen their skills in spatial data analysis, automation, and sharing using ArcGIS Professional Plus tools.
By the end of this training, participants will be able to:
- Leverage ArcGIS Pro Plus tools for data visualization and analysis.
- Create 2D and 3D maps with advanced symbology and geoprocessing techniques.
- Automate workflows using ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at advanced-level GIS professionals who wish to use ArcGIS Pro to enhance their spatial analysis capabilities, conduct comprehensive geostatistical analysis, and apply advanced 3D modeling techniques for more effective decision-making and problem-solving in real-world scenarios.
By the end of this training, participants will be able to:
- Develop advanced skills in spatial analysis techniques using ArcGIS Pro.
- Utilize Python scripting for automation and complex data processing.
- Apply spatial modeling for problem-solving in real-world scenarios.
- Conduct geostatistical analysis for advanced data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the evolving energy sector, the integration of electrical transient analysis with precise geographic data is a strategic necessity. Currently, reliance on fragmented data leads to significant operational risks. This 14-day intensive program in Melbourne is designed to bridge the gap between electrical engineering and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at intermediate-level geographers who wish to deepen their expertise in spatial analysis, data management, and GIS applications.
By the end of this training, participants will be able to:
- Apply advanced spatial analysis techniques to solve complex geographical problems.
- Manage large spatial databases and perform data quality control.
- Create dynamic and interactive maps and visualizations for various applications.
- Utilize programming and automation to streamline GIS workflows.
Insurance in the Digital Era
14 HoursInsurance in the Digital Era is an applied overview of how digital transformation reshapes products, operations, and customer engagement in the insurance industry.
This instructor-led, live training (online or onsite) is aimed at intermediate-level insurance professionals who wish to understand and apply digital technologies, data-driven strategies, and innovation frameworks to modernize insurance offerings and operations.
By the end of this training, participants will be able to:
- Explain the role of AI, Big Data, IoT, and automation in modern insurance workflows.
- Identify InsurTech trends and how they affect the insurance ecosystem.
- Design customer-centric strategies enabled by digital tools and data insights.
- Apply data-driven approaches to risk management and decision making.
- Develop an innovation and change management approach suitable for insurers.
- Assess real-world case studies and translate lessons into local initiatives.
Format of the Course
- Interactive lecture and discussion.
- Case study analysis and group workshops.
- Practical exercises and action planning for participants’ organizations.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
IREB CPRE – Foundation Level (Extended): Practical Requirements Engineering and Certification Preparation
14 HoursRequirements Engineering (RE) is a key discipline within software and systems development, focused on identifying, documenting, and managing the needs and constraints of stakeholders to ensure project success.
This instructor-led, live training (online or onsite) is aimed at intermediate-level professionals who wish to deepen their understanding of practical Requirements Engineering while preparing for the IREB CPRE – Foundation Level certification exam.
Upon completion of this training, participants will be able to:
- Understand and apply the key concepts and terminology defined by the IREB CPRE Foundation syllabus.
- Identify and elicit requirements using effective and context-appropriate techniques.
- Model, document, and validate requirements for real-world projects.
- Manage requirements changes, traceability, and prioritization throughout the project lifecycle.
- Use Requirements Engineering tools and best practices to enhance communication and project outcomes.
- Be fully prepared to take and pass the IREB CPRE – Foundation Level certification exam.
Format of the Course
- Interactive lecture and discussion.
- Case-based exercises and collaborative workshops.
- Exam preparation sessions and practice questions.
Course Customization Options
- Additional modules or industry-specific case studies can be added on request.
Basics of Requirements Engineering and Analysis
14 HoursRequirements engineering is the process of defining, collecting, documenting, managing and analyzing the needs, expectations and functionalities that should be implemented by a given system, product or IT project. Requirements engineering plays a key role in the success of IT projects because accurate, understandable and consistent requirements constitute the foundation for the system or product being created. Correctly understanding and precisely defining the needs of users and stakeholders is crucial to achieving customer satisfaction and the success of IT projects.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level earth sciences and engineering professionals who wish to use Python for geospatial analysis in both ArcGIS and QGIS environments.
By the end of this training, participants will be able to:
- Learn Python syntax and control structures for executing geospatial tasks efficiently.
- Use Pandas, Numpy, and Matplotlib for data analysis and visualization in GIS.
- Manipulate and analyze vector data with Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows using Python scripting in ArcGIS and QGIS.
- Develop custom Python-based geoprocessing tools for ArcGIS and QGIS to streamline tasks.
QGIS for Geographic Information System
21 HoursA geographic information system (GIS) is a system designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The acronym GIS is sometimes used for geographic information science (GIScience) to refer to the academic discipline that studies geographic information systems and is a large domain within the broader academic discipline of geoinformatics.
QGIS functions as geographic information system (GIS) software, allowing users to analyze and edit spatial information, in addition to composing and exporting graphical maps. QGIS supports both raster and vector layers; vector data is stored as either point, line, or polygon features. Multiple formats of raster images are supported, and the software can georeference images. To summarize it allows the users to Create, edit, visualise, analyse and publish geospatial information on Windows, Mac, Linux, BSD.
This program, in its first phase, introduces the QGIS interface for general usage. In the second phase, we introduce PyQGIS - the python libraries of QGIS that allows the integration of GIS functionalities in your python code or your python application, so that you may even create your own Python Plugin around a particular GIS functionality.
Requirements Management
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at intermediate-level business and IT professionals who wish to enhance their skills in requirements management.
By the end of this training, participants will be able to:
- Understand the key activities and products of requirements management.
- Apply effective techniques for requirements elicitation.
- Document requirements using appropriate methods and notations.
- Implement a requirements architecture and repository.