Day 3: Getting Creative

SQL Reporting by Example

Day 2: Advanced Selecting

SQL Reporting by Example

Day 1: Joining Tables

SQL Reporting by Example

Orientation: Selecting Data

SQL Reporting by Example

Subqueries

Querying Relational Databases

Set Operations

Querying Relational Databases

Joining Table Data with SQL

Querying Relational Databases

Table Relationships

Querying Relational Databases

Database Keys

Querying Relational Databases

Database Normalization

Querying Relational Databases

Date and Time Functions

Reporting with SQL

Aggregate and Numeric Functions

Reporting with SQL

Working with Text

Reporting with SQL

Ordering, Limiting and Paging Results

Reporting with SQL

Practicing Data Visualization

Data Visualization Foundations

Line and Area Charts, Scatter Plots, and Maps

Data Visualization Foundations

Bar Charts, Histograms, and Pie Charts

Data Visualization Foundations

Data Visualization Fundamentals

Data Visualization Foundations

Practicing Data Visualization in Excel

Data Visualization with Excel

Chart Formatting and Layout

Data Visualization with Excel

When To Use What Type of Chart

Data Visualization with Excel

Introduction To Data Visualization

Data Visualization with Excel

The Data Analysis Process

Data Analysis Basics

Getting to Know Your Data

Data Analysis Basics

Treehouse Club - JavaScript

Treehouse Club: JavaScript

Treehouse Club - CSS

Treehouse Club: CSS

Welcome to the Treehouse Club

Treehouse Club: HTML

WWW

How the Web Works

The Internet

How the Internet Works

Computer Languages

Computer Basics

Computer Basics

Computer Basics

Introducing Data Analysis

Data Analysis Basics

Build a Spreadsheet

Spreadsheet Basics

Spreadsheet Best Practices

Spreadsheet Basics

Spreadsheet Functions & Formulas

Spreadsheet Basics

Getting Started With Spreadsheets

Spreadsheet Basics

Introducing Spreadsheets

Spreadsheet Basics

Writing a Classifier

Machine Learning Basics

Machine Learning Vocabulary

Machine Learning Basics

Introduction to Machine Learning

Machine Learning Basics

Introducing Large Language Models

Introducing Large Language Models

Scrum Artifacts

Scrum Basics

Scrum Events

Scrum Basics

Introducing Scrum

Scrum Basics

What is Agile?

Scrum Basics

Handling Errors When Manipulating Data

Modifying Data with SQL

Deleting Data from a Database

Modifying Data with SQL

Updating Data in a Database

Modifying Data with SQL

Adding Data to a Database

Modifying Data with SQL

Finding the Data You Want

SQL Basics

Getting Data from a Database

SQL Basics

Data, Databases and SQL

SQL Basics

Buggy Logs

Write Better Python

Cleaner Code

Write Better Python

Iterating and Packing with Dictionaries

Introducing Dictionaries

Introducing Dictionaries

Introducing Dictionaries

Sequence Operations

Python Sequences

Sequence Iterations

Python Sequences

Packing and Unpacking

Functions, Packing, and Unpacking

Getting Info In and Out of Functions

Functions, Packing, and Unpacking

Introduction to Functions

Functions, Packing, and Unpacking

Getting to Know Tuples

Introducing Tuples

Build an Application

Introducing Lists

Using Lists

Introducing Lists

Meet Lists

Introducing Lists

Practice Functions

Practice Creating and Using Functions in Python

All Together Now

Python Basics

Functions and Looping

Python Basics

Types and Branching

Python Basics

Meet Python

Python Basics

Newbie