Date: 13 - 14.03.2025, Online
The course first provides an overview of the topic of data management, in particular the storage and processing of structured data with the help of databases. An application example from laboratory operation is used to show how to create a technical concept based on technical requirements and implement a relational database from this. Because nowadays data from various sources and in various structures must be processed, the topics of data integration and data analysis are also covered. In particular, aspects of data warehousing, big data, data science and artificial intelligence are discussed.
For whom is this seminar interesting
- Professionals, managers, lab managers and technical employees who want to learn about the developments and methods of digital transformation in a modern, agile organization, especially on the topic of data management.
- The course is suitable for beginners, but is also aimed at advanced students who would like to expand their laboratory practice with suitable background knowledge. Previous knowledge is not required.
After the seminar
- you know the difference between Excel and databases.
- recognize the opportunities and benefits of databases for your organization.
- you have the necessary expertise to set up a database tailored to the needs of your organization together with your IT department.
Contents
Introduction
"AI is the engine of digitalization, data is the fuel"
Processes, data, functions, applications
Distributed systems and layer model: data, application, presentation
Laboratory Information and Management Systems (LIMS)
Basics
Characters, data, information, knowledge, ..., competitiveness (North's knowledge staircase)
Data structures: structured data, semi-structured data, unstructured data
Data formats: CSV, XLS, XML etc.
Master data, transaction data, inventory data
Transactions, ACID principle, OLTP
Data management
Data protection vs. data security
Databases: From concept to implementation
Requirements for databases
Technical concept: Data modeling, entity relationship model (ERM)
Technical concept: Relational model
Implementation: Relational databases and structured query language (SQL)
Data integration and data analysis
Data warehouse, star schema, ETL process
Business intelligence, reporting, OLAP
Modern data analysis methods
Data mining, predictive analytics
Big data, NoSQL databases
Data science and artificial intelligence
Application examples from laboratory operations
Date:
13 - 14.03.2025
Participation fee: € 1,100.00 (€ 1,320.90 incl. VAT)
Online
Contact
Dr. Klinkner & Partner GmbH
Wilhelm-Heinrich-Straße 16
66117 Saarbrücken
Tel +49 (0) 681 / 982 10 - 0
Web: http://www.klinkner.de