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

Building Database Applications in PHP (Coursera) Coursera
University of Michigan

Building Database Applications in PHP (Coursera)

In this course, we'll look at the object oriented patterns available in PHP. You'll learn how to connect to a MySQL using the Portable Data Objects (PDO) library and issue SQL commands in the the PHP language. We'll also look at how PHP uses cookies and manages session data. You'll learn how PHP avoids double posting data, how flash messages are implemented, and how to use a session to log in users in web applications.

Nov 9th 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
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!

Nov 23rd 2026
5-12 Weeks
Exploiting and Securing Vulnerabilities in Java Applications (Coursera) Coursera
University of California, Davis

Exploiting and Securing Vulnerabilities in Java Applications (Coursera)

In this course, we will wear many hats. With our Attacker Hats on, we will exploit Injection issues that allow us to steal data, exploit Cross Site Scripting issues to compromise a users browser, break authentication to gain access to data and functionality reserved for the ‘Admins’, and even exploit vulnerable components to run our code on a remote server and access some secrets.

Nov 9th 2026
4 Weeks
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
Health Information Technology Fundamentals (Coursera) Coursera
Johns Hopkins University

Health Information Technology Fundamentals (Coursera)

In this course you will receive an overview of the health IT ecosystem and the types of technologies IT support staff interact with the most. You will be introduced to the role of electronic health records (EHRs), clinical decision support, telemedicine, patient portals, and medical devices. We’ll cover common examples of how disruptions in these technologies can impact ongoing operations and routine clinical workflow. Although there is an interconnectedness to some aspects of healthcare, there are also limitations in data sharing. We want you to walk away from this course with an understanding of the family of technologies and tools that are critical in healthcare operations.

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
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.

Nov 23rd 2026
3 Weeks
Data Visualization with Advanced Excel (Coursera) Coursera
PwC

Data Visualization with Advanced Excel (Coursera)

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek.

Nov 9th 2026
4 Weeks