Geo-ICT Training Center, The Netherlands
200 courses, 20 online supports,
60 moocs, 30 trainees
Course: PostgreSQL & Python
- Planning and Registration
This one-day course PostgreSQL and Python costs € 695 PostgreSQL is an object-relational database management system (ORDDBMS) that is widely used within companies. Python is a programming language that has many applications. One of those applications of python is to automate certain processes within PostgreSQL. Some prior knowledge of both python and PostgreSQL is desirable, but not necessary. Therefore, in preparation for this course, a basic python course can be interesting.
In this course PostgreSQL and Python all kinds of SQL commands will be executed using python. Automatic data will be loaded, modified or deleted. We can also retrieve data from the database to perform analyzes. A number of important commands will be discussed. First, it will connect to the database. After which actions are performed with the “execute” command. Secondly, all kinds of queries will be executed with a cursor object. The rollback command will also be used. This command can reverse certain transactions. Commit is the rollback counterpart. A specific transaction can be recorded in the database. With the fetchall function, all rows in a table can be loaded, after which the data can be continued. Finally, the close function ensures that the connection is neatly closed.
All kinds of data types will be used when executing the queries in PostgreSQL. Think of datetime, blob and spatial datatypes. When loading and working with spatial data we will use ppygis2. A number of error messages that may arise will also be discussed.
What you can do after this course:
- Connecting to the database via python
- Execute SQL commands using python
- Loading different data types into PostgreSQL via python
- Can interpret error messages so that work can be performed independently
- Automatically execute transactions in PostgreSQL