Course/Event Essentials
Event/Course Start
Event/Course End
Event/Course Format
Online
Primary Event/Course URL
Training Content and Scope
Scientific Domain
Technical Domain
Level of Instruction
Intermediate
Advanced
Sector of the Target Audience
Research and Academia
Industry
Public Sector
Other (general public...)
HPC Profile of Target Audience
Application Users
Data Scientists
System Administrators
Language of Instruction
Other Information
Organiser
Supporting Project(s)
EuroCC2/CASTIEL2
Event/Course Description
1. Introduction to databases and database systems
- Databases, tables, queries
- Datalore
- Libraries and modules (pymysql, psycopg2, google-cloud)
- Secrets and passwords
- Environs
- Database connection and disconnection
2. Querying in SQL and Python
- SQL language and queries
- Tables and Dataframes
- Selection of data and columns from the table (Select)
- Data types in DB and Python
- Aggregation functions (Sum, Min, Max, Avg, Count)
- Limits (Limit, Top, Offset) and logical operators (And, Or, Not, Xor)
- Grouping rows (Group by)
- Logical operators (And, Or, Not, Xor)
- Creating (Create), deleting (Delete) and updating (Update) a table