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
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
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
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 Data Types
PostgreSQL Show Tables
Show tables in PostgreSQL
PostgreSQL Show Databases
Documentation
SELECT DISTINCT, GROUP BY
SQL – select DISTINCT
Is there any difference between GROUP BY and DISTINCT
NoSQL – Graph Databases
OrientDB
Wikipedia
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