1

• Einstieg

13.02.2023

https://docs.google.com/presentation/d/1gppH6AmYGyXcpRHQbsVVwNlhNcfB-zBm735sz64WoRA/edit?usp=drive_link

2

• LDP Ökosystem

• Einrichten von DBeaver

• Struktur der Datenbank (LDP1 vs Metadb vs FOLIO DB)

• Best practice zur Verwaltung von SQL-Queries

  • GitHub / GitLab / NAS

  • Verlinkung in DBeaver

• Die erste kleine SQL-Query

27.02.2023

https://docs.google.com/presentation/d/1ew3sV4TbNybthS0ELGOCZPKA2HotS-Gc0HQz0f4-u6M/edit?usp=sharing

3

• Einrichten von DBeaver

• Die erste kleine SQL-Query

• Extraktion von Daten aus JSON mit PostgresSQL

• Stil der Queries in der Community

• Typen von Tabellen in der LDP

13.03.2023

https://docs.google.com/presentation/d/1OgeNy4m428IzkhvhYebcsjg5Hd-Dc8Aw0z2BrqGeGRQ/edit?usp=sharing

4

• Qualitätssicherung durch Reviews

• Konzept zur Verteilung von Reports

17.04.2023

https://docs.google.com/presentation/d/1swQYgln_wIMV5P5Pb-X5q2i0teRWLRn50JuNvwOTasQ/edit?usp=sharing

5

• SQL Crashkurs

08.05.2023

https://docs.google.com/presentation/d/1MMY_2cBQhOYhjmLI4jjbtE-xU_Gp31ecZZoaT8QBYV8/edit?usp=sharing

6

• Schreiben eines SQL-Query in Metadb

17.07.2023

https://docs.google.com/presentation/d/1CyVDNk_jdETIbYFVSXut_ncmxockyZYG3R3RFZazrmY/edit?usp=sharing

7

• LDLite, ein client-side Reporting Tool für Okapi-basierte Services

31.07.2023

https://docs.google.com/presentation/d/19P8z6gP3jNhUDCmVTxfrEQrX5r4Wc2OEzBi-OaBGzos/edit?usp=sharing

8

• Weitere Reporting-Optionen

18.09.2023

https://docs.google.com/presentation/d/1vA5INqYSHmKc0VPJ8q8xhQSZ5MngJLG3QacrvTcgbWI/edit?usp=sharing

9

• Reporting direkt in der FOLIO-Datenbank und Erstellen von Views

22.04.2024

https://docs.google.com/presentation/d/13NApI45lbTTX7_8L1huqnvJexFqYdTEUshPip8TXXBc/edit?usp=sharing

10

• Einführung in Jira für FOLIO

22.09.2024

https://docs.google.com/presentation/d/1_CwYKT-MnHX6Yn1BnadfMuw5ACvRqbnhShlbU0bbBgQ/edit?usp=sharing

General

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-General

MARC queries

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-MARC-queries

Inventory

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-Inventory

ACQ Reporting

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-ACQ

ERM Reporting

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-ERM

Finances

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-Finances

User Management

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-UM

Resource Access

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-RA

Cookbook: DBS

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-DBS#dbs---deutsche-bibliotheksstatistik-german-library-statistics

User Defined Function

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-User-Defined-Function