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

Introduction to Blockchain for Financial Services (Coursera) Coursera
INSEAD

Introduction to Blockchain for Financial Services (Coursera)

In this first course of the specialization, we will discuss the limitations of the Internet for business and economic activity, and explain how blockchain technology represents the way forward. After completing this course, you will be able to explain what blockchain is, how it works, and why it is revolutionary. You will learn key concepts such as mining, hashing, proof-of-work, public key cryptography, and the double-spend problem.

Jul 27th 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
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
Microsoft Azure SQL (Coursera) Coursera
Microsoft

Microsoft Azure SQL (Coursera)

In this course, you will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure. You will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. You will learn you'll learn about SQL. You'll see how it's used to query and maintain data in a database, and the different dialects that are available.

Jul 27th 2026
2 Weeks
La recherche documentaire (Coursera) Coursera
École Polytechnique

La recherche documentaire (Coursera)

Ce cours vise principalement à permettre aux étudiants d’identifier les sources pertinentes dans un domaine donné, leur apprendre à construire un état de l’art et à évaluer les sources, en particulier celles en accès libre sur Internet. Il cherche également à optimiser la recherche documentaire en incitant les étudiants à tirer le meilleur parti des outils et requêtes d’interrogation des bases de données. A l'issue de ce cours, ils devront être capables de construire et alimenter une bibliographie ordonnée, ainsi que de citer convenablement leurs sources pour éviter le plagiat.

Aug 3rd 2026
3 Weeks
Foundations of marketing analytics (Coursera) Coursera
ESSEC Business School

Foundations of marketing analytics (Coursera)

Who is this course for? This course is designed for students, business analysts, and data scientists who want to apply statistical knowledge and techniques to business contexts. For example, it may be suited to experienced statisticians, analysts, engineers who want to move more into a business role, in particular in marketing. You will find this course exciting and rewarding if you already have a background in statistics, can use R or another programming language and are familiar with databases and data analysis techniques such as regression, classification, and clustering. However, it contains a number of recitals and R Studio tutorials which will consolidate your competences, enable you to play more freely with data and explore new features and statistical functions in R.

Jul 27th 2026
5-12 Weeks
Big Data Analysis Deep Dive (Coursera) Coursera
Alibaba Cloud Academy

Big Data Analysis Deep Dive (Coursera)

The job market for architects, engineers, and analytics professionals with Big Data expertise continues to increase. The Academy’s Big Data Career path focuses on the fundamental tools and techniques needed to pursue a career in Big Data. This course includes: data processing with python, writing and reading SQL queries, transmitting data with MaxCompute, analyzing data with Quick BI, using Hive, Hadoop, and spark on E-MapReduce, and how to visualize data with data dashboards. Work through our course material, learn different aspects of the Big Data field, and get certified as a Big Data Professional!

Aug 3rd 2026
5-12 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.

Jul 27th 2026
4 Weeks
Introduction to Clinical Data Science (Coursera) Coursera
University of Colorado System

Introduction to Clinical Data Science (Coursera)

This course will prepare you to complete all parts of the Clinical Data Science Specialization. In this course you will learn how clinical data are generated, the format of these data, and the ethical and legal restrictions on these data. You will also learn enough SQL and R programming skills to be able to complete the entire Specialization - even if you are a beginner programmer. While you are taking this course you will have access to an actual clinical data set and a free, online computational environment for data science hosted by our Industry Partner Google Cloud.

Jul 27th 2026
4 Weeks