TSM_DataMgmt

An Animated Guide: Knowing SQL Internal Processes makes SQL Easy, makes SQL easy
WHERE-Klausel im Detail

Lecture

Week 3

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

CTE in SQL

What is the difference between tree depth and height?
Height, Depth and Level of a Tree

Nested set model
Nested Sets
Jede Menge Bäume

Storing hierarchical data: Materialized Path
Trees in SQL: Nested Sets and Materialized Path
Nested Sets and Materialized Path SQL Trees
Trees in SQL : an approach based on materialized paths and normalization for MySQLTrees in SQL : an approach based on materialized paths and normalization for MySQL
Materialized Path in PostgreSQL

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?

Week 6

What is the difference between scale-out versus scale-up (architecture, applications, etc.)?

Week 8

Assoziationsanalyse | Video Based Learning
Apriori-Algorithmus | Business Intelligence | Unsupervised Learning
Frequent Pattern (FP) growth Algorithm for Association Rule Mining
Apriori algorithm with complete solved example to find association rules
data mining fp growth | data mining fp growth algorithm | data mining fp tree example | fp growth

Week 9

ID3
C4.5
Decision tree learning
Decision Tree Classification in R

Week 11

K – Means Clustering – Fun and Easy Machine Learning
Hierarchical Clustering – Fun and Easy Machine Learning

Week 13

Minimal Viable Search using Postgres
Unscharfe Suche, Levenshtein-Distanz, N-Grammen, Soundex
PostgreSQL Full Text Search and Trigram Confusion
Victor Lavrenko – Search Engine

MapReduce – Computerphile
PostgreSQL Full Text Search and Trigram Confusion
13.68 MapReduce, Verarbeitung eines MapReduce Jobs auf einem Cluster Victor Lavrenko – Search Engine
Apache Hadoop
MapReduce

Heaps’ law
Zipf’s law

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
Codd’s 12 rules

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

PostgreSQL Data Types
PostgreSQL Show Tables
Show tables in PostgreSQL
PostgreSQL Show Databases

Documentation

9.20. Aggregate Functions

SELECT DISTINCT, GROUP BY

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

NoSQL – Graph Databases

OrientDB

Demo Database

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

WEKA

Weka 3: Machine Learning Software in Java
Weka Wiki
WEKA API Tutorial: How to use WEKA in JAVA

Leave a Reply

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