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

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
Introduction to Software, Programming, and Databases (Coursera) Coursera
IBM

Introduction to Software, Programming, and Databases (Coursera)

There are many types of software and understanding software can be overwhelming. This course aims to help you understand more about the types of software and how to manage software from an information technology (IT) perspective. This course will help you understand the basics of software, cloud computing, web browsers, development and concepts of software, programming languages, and database basics.

Aug 17th 2026
5-12 Weeks
Mainframes (openHPI) OpenHPI
Hasso-Plattner-Institut

Mainframes (openHPI)

Kaum jemand kennt sie. Und dennoch hat man täglich mit ihnen zu tun. Wer an einem Bankautomaten Geld abhebt, wer einen Flug bucht, wer mit der Deutschen Bahn unterwegs ist: Immer arbeiten im Hintergrund Mainframes, welche die wirklich entscheidende Arbeit verrichten und dafür sorgen, dass alles sicher und ohne Datenverlust vonstatten geht. Mehr als 70 Prozent der Global 500 arbeiten mit diesen Großrechnern.

Self Paced
Self-Paced
Computing for Data Analysis (edX) EdX
Georgia Institute of Technology,GTx

Computing for Data Analysis (edX)

A hands-on introduction to basic programming principles and practice relevant to modern data analysis, data mining, and machine learning. The modern data analysis pipeline involves collection, preprocessing, storage, analysis, and interactive visualization of data. In the course, you’ll see how computing and mathematics come together.

Aug 24th 2026
13-24 Weeks
Building Web Applications in Django (Coursera) Coursera
University of Michigan

Building Web Applications in Django (Coursera)

In this course, you will learn how Django communicates with a database through model objects. You will explore Object-Relational Mapping (ORM) for database access and how Django models implement this pattern. We will review the Object-Oriented (OO) pattern in Python. You will learn basic Structured Query Language (SQL) and database modeling, including one-to-many and many-to-many relationships and how they work in both the SQL and Django models. You will learn how to use the Django console and scripts to work with your application objects interactively.

Aug 10th 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.

Aug 10th 2026
4 Weeks
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
Importing Data in the Tidyverse (Coursera) Coursera
Johns Hopkins University

Importing Data in the Tidyverse (Coursera)

Getting data into your statistical analysis system can be one of the most challenging parts of any data science project. Data must be imported and harmonized into a coherent format before any insights can be obtained. You will learn how to get data into R from commonly used formats and harmonizing different kinds of datasets from different sources. If you work in an organization where different departments collect data using different systems and different storage formats, then this course will provide essential tools for bringing those datasets together and making sense of the wealth of information in your organization.

Aug 10th 2026
4 Weeks
Big Data Analysis with Scala and Spark (Scala 2 version) (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Scala 2 version) (Coursera)

Manipulating big data distributed over a cluster using functional concepts is rampant in industry, and is arguably one of the first widespread industrial uses of functional ideas. This is evidenced by the popularity of MapReduce and Hadoop, and most recently Apache Spark, a fast, in-memory distributed collections framework written in Scala. In this course, we'll see how the data parallel paradigm can be extended to the distributed case, using Spark throughout.

Aug 17th 2026
4 Weeks
Getting Started with Apache Cassandra (Coursera) Coursera
Whizlabs

Getting Started with Apache Cassandra (Coursera)

The “Getting Started with Cassandra” course is designed to help you gain knowledge of the Cassandra database system. You will learn architecture as well as how to design, build and use Cassandra databases. This training course helps you develop your skills and knowledge in Cassandra. Cassandra is a NoSQL database that has the traits of a distributed, open-source, and decentralized database or storage system. It can support the management of excessively massive amounts of structured data without a single point of failure, thereby resulting in the provision of highly available services.

Aug 17th 2026
3 Weeks
Web Application Development: Basic Concepts (Coursera) Coursera
University of New Mexico

Web Application Development: Basic Concepts (Coursera)

This is the first course in a Coursera Specialization track involving Web Application Architectures. This course will give you the basic background, terminology and fundamental concepts that you need to understand in order to build modern full stack web applications. A full stack web developer is familiar with each "layer" of the software technologies involved in a web application, including data modeling and database technologies, the web server environment and middleware components, network protocols, the user interface and basic visual design and user interaction concepts.

Aug 17th 2026
5-12 Weeks
Cloud Data Security (Coursera) Coursera
University of Minnesota

Cloud Data Security (Coursera)

This course gives learners an opportunity to explore data security in the cloud. In this course, learners will: dive into the data services offered by cloud providers and compare their security features; analyze a data breach and trace it back to the vulnerability that made it possible; learn about database injection and aggregation attacks; follow the life cycle of a data item and its relationship to privacy and integrity; associate modern privacy requirements with US and European laws.

Aug 10th 2026
4 Weeks