- Propositional logic
- Arrays, lists, dictionaries (hash)
- Tables of relational databases
- Select From Where (1 table)
- Internal Join
- External Join.
- Measures of central tendency
- Measures of dispersion
- Contingency tables
- Linear correlation
- Random variables
- Probability function, density function and cumulative distribution function
- Gaussian distribution
- Stochastic independence
- Probability of independent events
- Law of large numbers
- Central limit theorem
- Conditional distribution and conditional expectation
- Linear regression.
- Database System Concepts. Avi Silberschatz, Henry F. Korth, S. Sudarshan
- Introduction to the Theory of Statistics. Alexander M. Mood, Franklin A. Graybill, Duane C. Boes. McGraw-Hill
- Introductory statistics, Ross S.M., ELSEVIER ACADEMIC PRESS, 4th ed., 2017, ISBN: 978-0-12-804317-2,0128043172
- Think Python 2nd Edition by Allen B. Downey.
Q: What is the result of the following query?
SELECT name, surname
WHERE mean > 25
A1: All names and surnames of the students with a mean greater than 25.
A2: All names and surnames of the students with a mean greater than or equal to 25.
A3: All data of the students with a mean greater than 25.
A4: All data of the students with a mean greater than or equal to 25.
A5: All names and surnames, without duplicates, of the students with a mean greater than 25.
A6: All names and surnames, without duplicates, of the students with a mean greater than or equal to 25.
Q: You have to compare the dispersion of the two variables X and Y in a population. Which of the following measures can be reasonably compared?
A1: Second moments of X and Y, with X and Y having different means.
A2: Variances of X and Y, regardless of their means.
A3: Mean squared errors of X and Y about zero, if their means are not zero.
A4: Coefficients of variation of X and Y, when at least one of the two variables has the mean equal to zero.
A5: Mean and median of X with mean and median of Y.