Introduction to database management with PostgreSQL

Tuesday, March 19 2024 01:00PM-04:30PM to Wednesday 20 March 2024 13:00-16:30

Zoom

Language of the workshop: English

Workshop content

Database management systems (DBMS) provide a very powerful way to organize data, perform complex queries and interact with other tools for graphics, statistical analysis or dynamic web applications. MySQL and PostgreSQL are popular free, open-source DBMS and are used by thousands of companies and individuals worldwide. This two-day workshop, offered in English, will provide a short description of what DBMS can do and how full fledged DBMS such as PostgreSQL compare with software like MS Excel or MS Access for storing and querying scientific data. Topics that will be covered during the workshop include:

  • When to (not to) use a DBMS
  • Concepts of database management and organization
  • How to organize biodiversity data in databases
  • Installation of PostgreSQL
  • Importing data into PostgreSQL
  • Basics of the SQL language
  • More advanced SQL functions
  • Using dbeaver to explore the database
  • Options for form creation.
  • Interacting between PostgreSQL and other programs such as R.

The workshop will focus on hands-on learning through exercises with an example database related to biodiversity science. Short presentations will be given by the lecturer to introduce each section. Participants are expected to bring their own laptops to the workshop and to install PostgreSQL on their computers. Detailed instructions will be given to the participants one week prior to the workshop.

For any questions, please contact Guillaume Larocque (glaroc@gmail.com)

Audience

This workshop is FREE for QCBS members, both students and researchers. Non-QCBS members will be charged 50$+tx (students and NGOs) or 100$+tx (others) to attend the workshop, payable on line by credit card prior to the workshop. Registration of non-QCBS members might be restricted depending on the number of registrants. Participants are not expected to have any prior knowledge of database management or computer programming.

Registration

Please register using the form below: