Data Analyst with SQL

Understanding Data Visualization

• 01. Visualizing distributions
• 02. Visualizing two variables
• 03. The color and the shape
• 04. 99 problems but a plot ain't one of them

Introduction to Statistics

• 05. Summary Statistics
• 06. Probability and distributions
• 07. More Distributions and the Central Limit Theorem
• 08. Correlation and Hypothesis Testing

Introduction to SQL

• 09. Relational Databases
• 10. Querying

Intermediate SQL

• 11. Selecting Data
• 12. Filtering Records
• 13. Aggregate Functions
• 14. Sorting and Grouping

Joining Data in SQL

• 15. Introducing Inner Joins
• 16. Outer Joins, Cross Joins and Self Joins
• 17. Set Theory for SQL Joins
• 18. Subqueries

Data Manipulation in SQL

• 19. We'll take the CASE
• 20. Short and Simple Subqueries
• 21. Correlated Queries, Nested Queries, and Common Table Expressions
• 22. Window Functions

PostgreSQL Summary Stats and Window Functions

• 23. Introduction to window functions
• 24. Fetching, ranking, and paging
• 25. Aggregate window functions and frames
• 26. Beyond window functions

Functions for Manipulating Data in PostgreSQL

• 27. Overview of Common Data Types
• 28. Working with DATE/TIME Functions and Operators
• 29. Parsing and Manipulating Text
• 30. Full-text Search and PostgresSQL Extensions

Exploratory Data Analysis in SQL

• 31. What's in the database?
• 32. Summarizing and aggregating numeric data
• 33. Exploring categorical data and unstructured text
• 34. Working with dates and timestamps

Data-Driven Decision Making in SQL

• 35. Introduction to business intelligence for a online movie rental database
• 36. Decision Making with simple SQL queries
• 37. Data Driven Decision Making with advanced SQL queries
• 38. Data Driven Decision Making with OLAP SQL queries

Data Communication Concepts

• 39. Storytelling with Data
• 40. Preparing to communicate the data
• 41. Structuring written reports
• 42. Building compelling oral presentations

Project: When Was the Golden Age of Video Games?

• The ten best-selling video games
• Missing review scores
• Years that video game critics loved
• Was 1982 really that great?
• Years that dropped off the critics' favorites list
• Years video game players loved
• Years that both players and critics loved
• Sales in the best video game years