# TSM_BusAn

Tibble Data Format in R: Best and Modern Way to Work with Your Data

The Workspace

R for Data Science

## Wikipedia

Statistik
Stochastik
Mathematische/induktive Statistik (beurteilende Statistik)
Deskriptive Statistik (beschreibende Statistik)
Grundgesamtheit (Population! Gesamterhebungsumfang)
Schätztheorie
Schätzfunktion
Schätzmethode (Schätzverfahren)

## R

### Verteilungen

#### Diskrete

Poisson-Verteilung
Bernoulli-Verteilung (Null-Eins-Verteilung)
Binomialverteilung

#### StatQuest with Josh Starmer

StatQuest: Logistic Regression in R

#### DataCamp

R tutorial – Learn R Programming

## Week 2

• Samplr Size totally obscured
• Variability not visible
• Statistical evidence
• Statistical significance
• Statistical relevance
• Statistical inference
• Confidence Intervals
• Statistical hypothesis testing, Null-Hypothesis
• p-Values

Wilcoxon-Mann-Whitney-Test (Rank Sum Test)
Kruskal-Wallis-Test, H-Test, (Rank Sum Test)
Hypothese (Statistik)
Null hypothesis
Informal inferential reasoning
MathsNZ Students – 3.10 – Formal Inference

How To… Perform the Mann-Whitney U Test (By Hand)

### Boxplot

Khan Academy – Boxplot – Wiederholung
Wikipedia – Box-Plot
Box plot
Konfidenzintervall, Vertrauensintervall, Vertrauensbereich und Erwartungsbereich
Confidence interval
Boxplot erstellen, Median, unteres/oberes Quartil, Minimum, Maximum | Mathe by Daniel Jung

## Week 3

• categorical perdictor
• distribution
• deviation
• Gauss / not Gauss
• Residual plots

## MESOSworld – Methodological Education for the Social Sciences (Universität Zürich)

Lerninhalte

#### Bivariate Verteilungen

Regressionsanalyse

## Steve Brunton – Intro to Data Science

Intro to Data Science

• Intro to Data Science: Overview
• Intro to Data Science: Historical Context
• Intro to Data Science: What is Data Science?
• Intro to Data Science: Answering Questions with Data
• Intro to Data Science: The Nature of Data
• Machine Learning Overview
• Machine Learning Goals
• Machine Learning and Cross-Validation
• Types of Machine Learning 1
• Types of Machine Learning 2
• Artificial Intelligence
• Neural Network Overview
• Neural Network Architectures
• Neural Networks and Deep Learning
• Neural Networks: Caveats
• Digital Twins
• Data Visualization: Overview
• Data Visualization: Types of Data
• Data Visualization: Storytelling with Data

# Lecture

### Week 3

CTE in SQL

#### 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 13

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

# Rest

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

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

### NULL

NULL in SQL: Platzhalter für fehlende Daten

### SQL Functions

Substring function overview

### Sakila Databas

#### JOOQ

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

### postgresql

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

#### Documentation

9.20. Aggregate Functions

# NoSQL – Graph Databases

Demo Database

#### Wikipedia

Multi-model database

# Windows 10 Boot-Manager (Safe Mode / Abgesicherter Modus)

bootrec /fixmbr
bootrec /fixboot
bootrec /scanos
bootrec /rebuildbcd

msconfig
diskpart

bcdedit /set {default} safeboot minimal
bcdedit /set {default} safeboot network
bcdedit /set {default} safeboot minimal.
bcdedit /set {default} safebootalternateshell yes

bcdedit /deletevalue {default} safeboot


# JavaSE 4, …, 9 Features

javaTpoint Java Tutorial

# JavaSE 4, …, 9 Features

### Java 9 Features

Interface Private Methods
Try-With Resources
Anonymous Classes
SafeVarargs Annotation
Collection Factory Methods
Process API Improvement
Version-String Scheme
JShell (REPL)
Module System
Control Panel
Stream API Improvement
Underscore Keyword

### Java 8 Features

Lambda Expressions
Method References
Functional Interfaces
Stream API
Stream Filter
Base64 Encode Decode
Default Methods
forEach() method
Collectors class
StringJoiner class
Optional class
JavaScript Nashorn
Parallel Array Sort
Type Inference
Parameter Reflection
Type Annotations
JDBC Improvements

### Java 7 Features

Binary Literals
Switch with String
Multi Catch
Try with Resources
Type Inference
Numeric Literals
JDBC

Assertion
For-each Loop
Varargs
Static Import
Autoboxing
Enums
Annotations
Generics

# JavaSE 4, …, 8 Features

### JavaSE 8 Features

Java 8 Date/Time API (Java 8)
Lambda Expressions (Java 8)
Method References (Java 8)
Functional Interfaces (Java 8)
Stream (Java 8)
Base64 Encode Decode (Java 8)
Default Methods (Java 8)
forEach method(Java 8)
Collectors(Java 8)
StringJoiner(Java 8)
Optional class (Java 8)
Nashorn JavaScript (Java 8)
Parallel Array Sorting (Java 8)
Type Inference (Java 8)
Method Parameter Reflection (Java 8)
Type annotations and repeating annotations (Java 8)
Java JDBC Improvements (Java 8)
Java IO Improvement (Java 8)
Java Concurrency Improvement (Java 8)

### JavaSE 7 Features

String in switch statement (Java 7)
Binary Literals (Java 7)
The try-with-resources (Java 7)
Caching Multiple Exceptions by single catch (Java 7)
Underscores in Numeric Literals (Java 7)

### JavaSE 6 Features

Instrumentation (premain method) (Java 6)

### J2SE 5 Features

For-each loop (Java 5)
Varargs (Java 5)
Static Import (Java 5)
Autoboxing and Unboxing (Java 5)
Enum (Java 5)
Covariant Return Type (Java 5)
Annotation (Java 5)
Generics (Java 5)

### J2SE 4 Features

Assertion (Java 4)