This lesson is still being designed and assembled (Pre-Alpha version)

Introduction to Databases for HEP

Introduction to databases with application in HEP and Nuclear Physics

Prerequisites

  • Fixme

HSF Software Training

HSF Logo
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.

Schedule

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. A bit more on queries How to perform SQL Join?
How to make use of different SQL joins?
03:11 6. Conditions Database Example Using SQLAlchemy
03:11 7. 07 Break
03:11 8. SQLite What is SQLite?
How do I create an SQLite database?
04:41 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:47 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:49 Finish

The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.

Authors

The following people contributed to the content of this lesson:
Note that this list does not include the contributors to the framework as developed by the carpentries.