Course/Event Essentials
Event/Course Start
Event/Course End
Event/Course Format
Online
Live (synchronous)
Primary Event/Course URL
Training Content and Scope
Scientific Domain
Technical Domain
Level of Instruction
Intermediate
Sector of the Target Audience
Research and Academia
Industry
Public Sector
Other (general public...)
HPC Profile of Target Audience
Application Users
Application Developers
Data Scientists
System Administrators
Language of Instruction
Other Information
Organiser
Supporting Project(s)
EuroCC2/CASTIEL2
Event/Course Description
This course provides an introduction to the PostgreSQL relational database, one of the most powerful and popular databases in the world. In this one-day course you will gain both theoretical knowledge and practical experience of using and managing a PostgreSQL database for data analysis. We use the Microsoft Windows operating system for this course.
1. Advanced SQL
Joining tables (JOIN)
Aggregation functions (SUM, AVG, COUNT, MAX, MIN)
Subqueries
2. Database Administration
Creating and managing users and privileges
Database backup and recovery
Monitoring and optimising performance