Python and database data processing

Course/Event Essentials

Event/Course Start
Event/Course End
Event/Course Format
Online
Live (synchronous)

Venue Information

Country: Slovakia
Venue Details: Click here

Training Content and Scope

Scientific 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
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