TSM_DataMgmt

Lecture

Week 3

Postgres Handles More Than You Think
Don’t Do This
B-Baum
AVL-Baum

Week 4

Install MongoDB Community Edition on Ubuntu

Week 5

“Schema Later” Considered Harmful
Visualization software
Tableau Software
Superset: enterprise-ready web application for data exploration, data visualization and dashboarding
What does Tableau offer that Apache Superset doesn’t?

Rest

Step by Step Guide to Dimensional Data Modeling
Introduction to Dimesional Modelling
Business Intelligence: Building Your First Cube
Create First OLAP Cube in SQL Server Analysis Services
Building Your First Data Cube
Dimensional modeling
OLAP-Würfel
OLAP cube

SQL | DDL, DQL, DML, DCL and TCL Commands

Grundbegriffe der Prädikatenlogik
Prolog – Begriffe, (Literal, Klausel, Prädikat)

Wikipedia

Prädikatenlogik
Literale in der mathematischen Logik
Disjunktionsterm
Prädikat (Logik)

Wikipedia

(de)
Relational algebra (en)
Join (SQL) (de)
Join (SQL) (en)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
CRUD
ACID
NoSQL
Dokumentenorientierte Datenbank

NULL

NULL in SQL: Platzhalter für fehlende Daten

SQL Functions

Substring function overview

Sakila Databas

MySQL Sakila Sample Database
The Sakila Database
github.com/jOOQ/jOOQ/tree/master/jOOQ-examples/Sakila

JOOQ

A Beginner’s Guide to the True Order of SQL Operations

Datenbankenlernen.de – Prof. Dr. Jens Dittrich

Datenbankenlernen.de
13.XX SQL (Playlist)
13.20 Übersicht über Datenbanksysteme: Welches DBMS für was?
13.21a SQL Standards
13.21b SQL Teilsprachen
13.24 SELECT FROM WHERE
13.44 NULL != NULL
13.46 Unteranfragen mit IN, EXISTS, ALL, ANY
13.48 SQL Datentypen

postgresql

postgresql – can’t create database – OperationalError: source database “template1” is being accessed by other users

Documentation

9.20. Aggregate Functions

SELECT DISTINCT, GROUP BY

SQL – select DISTINCT
Is there any difference between GROUP BY and DISTINCT

NoSQL – Graph Databases

Wikipedia

Multi-model database

YouTube

OrientDB – the 2nd generation of (MultiModel) NoSQL by Luigi Dell’Aquila
Michael Hackstein: Multi-Model NoSQL Databases
Building on Multi-Model Databases

Leave a Reply

Your email address will not be published. Required fields are marked *