Topic outline


TEST SYLLABUS Propositional logic
 Conditions
 Loops
 Variables
 Arrays, lists, dictionaries (hash)
 Functions
 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
 Expectation
 Gaussian distribution
 Stochastic independence
 Probability of independent events
 Law of large numbers
 Central limit theorem
 Conditional distribution and conditional expectation
 Linear regression.
TEST TEXTBOOKS 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. McGrawHill
 Introductory statistics, Ross S.M., ELSEVIER ACADEMIC PRESS, 4^{th} ed., 2017, ISBN: 9780128043172,0128043172
 Think Python 2nd Edition by Allen B. Downey.
TEST EXAMPLESQ: What is the result of the following query?
SELECT name, surname
FROM students
WHERE mean > 25A1: 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.