Datenmanagement mit SQL (openHPI)

Datenmanagement mit SQL (openHPI)

Datenbanken bilden die Basis fast aller großen Software-Anwendungen. In Unternehmen, in der Forschung, im Web – überall entstehen riesige Datenmengen, die es gilt sicher zu speichern und die effizient abfragbar sein müssen.

Datenbanken bilden die Basis fast aller großen Software-Anwendungen. In Unternehmen, in der Forschung, im Web – überall entstehen riesige Datenmengen, die es gilt sicher zu speichern und die effizient abfragbar sein müssen. In dem openHPI Kurs "Datenmanagement mit SQL" lernen wir die Grundlagen von modernen Datenbanksystemen kennen. Wir untersuchen ihren Aufbau, wir planen den Entwurf von Datenbanken und schließlich lernen wir die weltweit dominierende Anfragesprache SQL kennen. Mittels SQL kann man einfach formulierte aber sehr mächtige Anfragen an eine Datenbank senden.

More info: https://openhpi.de/courses/649d026d-3cbb-43c1-9290-8dcecacb3fab

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

SQL: A Practical Introduction for Querying Databases (Coursera) Coursera
IBM

SQL: A Practical Introduction for Querying Databases (Coursera)

Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The purpose of this course is to help you learn and apply foundational and intermediate knowledge of the SQL language, and become familiar with many relational database (RDBMS) concepts along the way.

Nov 16th 2026
5-12 Weeks
BigQuery Fundamentals for Teradata Professionals (Coursera) Coursera
Google Cloud

BigQuery Fundamentals for Teradata Professionals (Coursera)

This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Teradata and want to begin working in BigQuery. Through interactive lecture content and hands-on labs, you learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing upon your knowledge of Teradata, you also learn about similarities and differences between Teradata and BigQuery to help you get started with data warehouses in BigQuery.

Nov 9th 2026
2 Weeks
In-Memory Data Management (内存数据库管理) (openHPI) OpenHPI
Hasso-Plattner-Institut

In-Memory Data Management (内存数据库管理) (openHPI)

The online course focuses on the management of enterprise data in column-oriented in-memory databases. Latest hardware and software trends led to the development of a new revolutionary technology that enables flexible and lightning-fast analysis of massive amounts of enterprise data.

Self Paced
Self-Paced
In-Memory Data Management (openHPI) OpenHPI
Hasso-Plattner-Institut

In-Memory Data Management (openHPI)

The „In-Memory Data Management" course in 2015 is the fourth iteration of Prof. Hasso Plattner's successful introduction into the inner mechanics of this recent technology. The course focuses on the management of enterprise data in column-oriented in-memory databases. Latest hardware and software trends led to the development of a new revolutionary database technology that enables flexible and lightning-fast analysis of massive amounts of enterprise data.

Self Paced
Self-Paced
Uso de bases de datos con Python (Coursera) Coursera
University of Michigan

Uso de bases de datos con Python (Coursera)

Este curso presentará a los estudiantes los conceptos básicos del lenguaje de consulta estructurado (Structured Query Language, SQL), así como el diseño básico de bases de datos para almacenar datos como parte de una iniciativa de varios pasos para recopilar, analizar y procesar datos. El curso utilizará SQLite3 como base de datos. También crearemos rastreadores web y procesos de visualización y recopilación de datos de varios pasos. Utilizaremos la biblioteca D3.js para realizar la visualización básica de datos.

Nov 9th 2026
5-12 Weeks
Introduction to MongoDB (Coursera) Coursera
MongoDB University

Introduction to MongoDB (Coursera)

"Introduction to MongoDB" guides you through the foundational skills and knowledge you need to get started with MongoDB. Get an introduction to MongoDB Atlas, the developer data platform, and how to create and deploy an Atlas cluster. Discover how MongoDB structures data in documents similar to JSON objects, making it flexible and developer friendly.

Nov 9th 2026
4 Weeks
Introduction to Relational Databases (Coursera) Coursera
Illinois Tech

Introduction to Relational Databases (Coursera)

Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language.

Nov 9th 2026
4 Weeks
Serverless Data Processing with Dataflow: Develop Pipelines (Coursera) Coursera
Google Cloud

Serverless Data Processing with Dataflow: Develop Pipelines (Coursera)

In this second installment of the Dataflow course series, we are going to be diving deeper on developing pipelines using the Beam SDK. We start with a review of Apache Beam concepts. Next, we discuss processing streaming data using windows, watermarks and triggers. We then cover options for sources and sinks in your pipelines, schemas to express your structured data, and how to do stateful transformations using State and Timer APIs.

Nov 16th 2026
3 Weeks
The Data Science of Health Informatics (Coursera) Coursera
Johns Hopkins University

The Data Science of Health Informatics (Coursera)

Health data are notable for how many types there are, how complex they are, and how serious it is to get them straight. These data are used for treatment of the patient from whom they derive, but also for other uses. Examples of such secondary use of health data include population health (e.g., who requires more attention), research (e.g., which drug is more effective in practice), quality (e.g., is the institution meeting benchmarks), and translational research (e.g., are new technologies being applied appropriately).

Nov 2nd 2026
4 Weeks
SQL for Data Science Capstone Project (Coursera) Coursera
University of California, Davis

SQL for Data Science Capstone Project (Coursera)

Data science is a dynamic and growing career field that demands knowledge and skills-based in SQL to be successful. This course is designed to provide you with a solid foundation in applying SQL skills to analyze data and solve real business problems. Whether you have successfully completed the other courses in the Learn SQL Basics for Data Science Specialization or are taking just this course, this project is your chance to apply the knowledge and skills you have acquired to practice important SQL querying and solve problems with data. You will participate in your own personal or professional journey to create a portfolio-worthy piece from start to finish.

Nov 2nd 2026
4 Weeks