Introduction to databases with application in HEP and Nuclear Physics
Prerequisites
- Fixme
HSF Software Training
This training module is part of the HSF Software Training Center, a series of training modules that serves HEP newcomers the software skills needed as they enter the field, and in parallel, instill best practices for writing software.
| Setup | Download files required for the lesson | |
| 00:00 | 1. Introduction |
What is a database management system and why it is a good idea to use one?
What are the differences between relational and non-relational databases? |
| 01:30 | 2. MySQL Basics |
What are the core SQL commands you need to know to interact with a MySQL database?
How do you create, update, and delete records in a MySQL database? |
| 01:30 | 3. 03 Break | |
| 01:30 | 4. SQLAlchemy and MySQL: Exercises |
How to perform CRUD operations using SQLAlchemy?
How to query and filter records in SQLAlchemy? |
| 01:41 | 5. Relations between Tables |
How to perform SQL Join?
How to make use of different SQL joins? |
| 03:11 | 6. Introduction to Conditions Databases in HEP |
What are the key objects in a Conditions Database and how are they related?
How can you use SQLAlchemy to model and query a simple Conditions Database? |
| 03:14 | 7. 07 Break | |
| 03:14 | 8. SQLite |
What is SQLite?
How do I create an SQLite database? |
| 04:44 | 9. Intro to NoSQL and Opensearch Queries |
What is NoSQL database and Opensearch?
How to perform indexing in Opensearch? How to query and filter records in opensearch? |
| 04:50 | 10. Opensearch Text Based Queries |
How to perform text based search in opensearch?
What are the ways to do text based search in opensearch? |
| 04:52 | Finish |
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.