Page Comparison

Database Systems Concepts & Design

• Database concepts

• Database models

• Database management

Intro to Relational Databases

• Data and tables

• Elements of SQL

• Python DB-API

• Deeper into SQL

SQL for Data Analysis

• SQL basics

• SQL joins

• SQL aggregations

• Subqueries and temp tables

• SQL data cleansing

• Window functions

Intro to Statistics

• Visualizing relationships in data

• Probability

• Estimation

• Outliers and normal distribution

• Inference

• Regression

Statistics

• Introduction to statistics and methods

• Describing data

• Normal distribution analysis

• Foundations of inferential statistics

• Comparing means

• Correlation, regression and non-parametrics

Data Analysis and Visualization

• Programming in R

• Data analysis

• Regression

Data Analysis with R

• What is exploratory data analysis (EDA)?

• R basics

• Explore one variable

• Explore two variables

• Explore many variables

• Diamonds and price prediction

Data Visualization in Tableau

• Data visualization fundamentals

• Design principles

• Creating visualizations with Tableau

• Telling stories with Tableau