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

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

Additional Scraping Tasks

Scraping Data From the Web

A World Full of Spiders

Scraping Data From the Web

Introducing Data Scraping

Scraping Data From the Web

Writing a Classifier

Machine Learning Basics

Machine Learning Vocabulary

Machine Learning Basics

Introduction to Machine Learning

Machine Learning Basics

Big Data at Netflix

Introduction to Big Data

Where and How Big Data Is Used

Introduction to Big Data

What is Big Data

Introduction to Big Data

The Data Analysis Process

Data Analysis Basics

Getting to Know Your Data

Data Analysis Basics

Introducing Data Analysis

Data Analysis Basics

Design Patterns

Prototyping in the Browser

Page Layout

Prototyping in the Browser

Going Further with Type

Typography for Designers

Laying Out Type

Typography for Designers

Web Typography

Typography for Designers

How to Choose and Use Fonts

Typography for Designers

Introduction to Typography

Typography for Designers

Chrome DevTools Basics

Website Optimization

Combine and Minify Assets

Introduction to Front End Performance Optimization

Optimize Assets

Introduction to Front End Performance Optimization

API Protection

Flask REST API

Resourceful Blueprints

Flask REST API

Gettin' CRUD-y With It

Using Databases in Python

Our Diary App

Using Databases in Python

Meet Peewee

Using Databases in Python

Dice Roller

Object-Oriented Python

Python: Advanced Objects

Object-Oriented Python

Python: Inheritance

Object-Oriented Python

Python: Instant Objects

Object-Oriented Python

Optimization Best Practices

Front End Web Optimization Workflow

Asset Optimization

Front End Web Optimization Workflow

Why Web Performance Matters

Front End Web Optimization Workflow

Testing for Accessibility

Web Accessibility Compliance

Mobile Accessibility

Web Accessibility Compliance

Accessible UI Patterns

Web Accessibility Compliance

Semantic HTML and WAI-ARIA

Web Accessibility Compliance

WCAG 2.0 (and Other Standards)

Web Accessibility Compliance

Access for Everybody

Web Accessibility Compliance

Scrum Artifacts

Scrum Basics

Scrum Events

Scrum Basics

Introducing Scrum

Scrum Basics

What is Agile?

Scrum Basics

Build Your Professional Portfolio

The 5-Step Career Checklist

Use LinkedIn to Grow Your Network

The 5-Step Career Checklist

Film Your Pitch Video

The 5-Step Career Checklist

Character Builder

Flask Basics

Flask Templates

Flask Basics

Welcome to Flask

Flask Basics

Review Your Checklist with an Advisor

The 5-Step Career Checklist

Next Steps

JavaScript Unit Testing

Improving Our Tests

JavaScript Unit Testing

Behavior Driven Development with Mocha & Chai

JavaScript Unit Testing

Express Middleware

User Authentication With Express and Mongo

Sessions and Cookies

User Authentication With Express and Mongo

User Registration and Login

User Authentication With Express and Mongo

Introducing Unit Testing

JavaScript Unit Testing

What is Authentication?

User Authentication With Express and Mongo

Refining the App

React by Example

Building the Application

React by Example

Setting up with Create React App

React by Example

Practice forEach

Practice forEach in JavaScript

React Router and Authentication

React Authentication

Implementing Basic Authentication

React Authentication

Introducing the Authentication Project

React Authentication

How to Critique Design

Design Criticism

InControl Conference

LEGO

Data Cleaning

Preparing Data for Analysis

Understanding Cleaning Data

Preparing Data for Analysis

Python Regular Expressions

Regular Expressions in Python

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

Seaborn Data Visualization Challenges

Intro to Seaborn

Plotting Functions

Intro to Seaborn

Introduction to Seaborn

Intro to Seaborn

What to Test

Unit Testing in Java

How To Test

Unit Testing in Java

Why Test

Unit Testing in Java

The Internet

How the Internet Works

Building a Flashcard App

Vue.js Basics

Sweeping Vues: Loops, Methods, Directives

Vue.js Basics

What a Beautiful Vue!

Vue.js Basics

Introducing Vue

Vue.js Basics

Modular Media Queries

Modular CSS with Sass

Sass Grid System

Modular CSS with Sass

SMACSS and Sass

Modular CSS with Sass

Sass and BEM

Modular CSS with Sass

Getting Modular with Mixins and Functions

Modular CSS with Sass

Treehouse Club - CSS

Treehouse Club: CSS

Debugging, Best Practices, and Production

CSS to Sass

Refactoring with Sass

CSS to Sass

Art Direction with the Picture Element

Responsive Images

Image Delivery with Srcset and Sizes

Responsive Images

Welcome to the Treehouse Club

Treehouse Club: HTML

Captioning Video

HTML Video and Audio

Media Basics

HTML Video and Audio

Telling the Story

Intro to Design Thinking

Designing for your User’s "To-be"

Intro to Design Thinking

Understanding your User’s “As-is” Scenario

Intro to Design Thinking

Becoming Acquainted with Your User

Intro to Design Thinking

Becoming a Design Thinker

Intro to Design Thinking

HTTP Methods and Headers

Build a Simple Dynamic Site with Node.js

Creating a Basic Template Engine in Node.js

Build a Simple Dynamic Site with Node.js

Handling Routes in Node.js

Build a Simple Dynamic Site with Node.js

Creating a Simple Server in Node.js

Build a Simple Dynamic Site with Node.js

Practicing Object Basics

Practice Object Basics in JavaScript

Practicing Getters and Setters

Practice Getters and Setters in JavaScript

Practicing Classes

Practice Classes in JavaScript

Checking Out and Returning a Book

Practice Object Interaction

Starting with Some Methods

Practice Object Interaction

The Rough Plan

Practice Object Interaction

React Component Patterns

React Components

Stateful Components and the Effect Hook

React Components

Managing State

React Components

Data Flow

React Components

Build Modular Interfaces with Components

React Components

Making Changes to the DOM

JavaScript and the DOM

Getting a Handle on the DOM

JavaScript and the DOM

The Browser Environment

JavaScript and the DOM

Creating a Command Line Application

Node.js Basics

Handling Errors in Node

Node.js Basics

Getting Data From an API With Node

Node.js Basics

Introduction to Node.js

Node.js Basics

Going Further with Routing

React Router v6 Basics

Navigating, Nesting and Redirecting Routes

React Router v6 Basics

Getting Started with React Router

React Router v6 Basics

Data Eruption

Introduction to Data Visualization with Matplotlib

Chart Toppers

Introduction to Data Visualization with Matplotlib

Getting Started with Data Visualization

Introduction to Data Visualization with Matplotlib

Welcome to Basic Statistics for Data Analysis

Basic Statistics for Data Analysis

Functions in TypeScript

TypeScript Basics

Manipulating Types

TypeScript Basics

Working with (More) Types

TypeScript Basics

Getting Started with TypeScript

TypeScript Basics

Exploring pandas

Introduction to pandas

Meet pandas

Introduction to pandas

Array Programming

Introduction to NumPy

Array Organization

Introduction to NumPy

Meet NumPy

Introduction to NumPy

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

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

Welcome to Basic Math for Data Analysis

Basic Math for Data Analysis

Objects in Action - Immersive Review

Coding Machine

150th Techdegree Peer Review

Code Racer

Mike the Frog

Treehouse Staff

Tools of the Trade

Intro to Data Analysis

Breaking Down Data Analysis

Intro to Data Analysis

Connecting to a Database with SQLAlchemy

Flask with SQLAlchemy Basics

Creating a Basic Website with Flask

Flask with SQLAlchemy Basics

Working with SQLAlchemy

SQLAlchemy Basics

Imposter Syndrome

Imposter Syndrome

Create Function Using Arrow Syntax

Getting Started With ES2015

Using Template Literals

Getting Started With ES2015

Defining Variables With let and const

Getting Started With ES2015

Classes

Introducing ES2015

Objects and New Collection Types

Introducing ES2015

The Cooler Parts of ES2015

Introducing ES2015

ES2015 Basics

Introducing ES2015

Treehouse Club - JavaScript

Treehouse Club: JavaScript

Traversing the DOM

Interacting with the DOM

Managing Packages with NPM

npm Basics

Hello Node.js

npm Basics

CSS Media Queries

CSS Layout

CSS Layout Techniques

CSS Layout

Box Model Concepts

CSS Layout

The CSS Box Model

CSS Layout

Finishing Touches

Enhancing Design with CSS

Styling Images

Enhancing Design with CSS

Styling Boxes

Enhancing Design with CSS

Styling Text

Enhancing Design with CSS

Fundamental Concepts

CSS Basics

Understanding Values and Units

CSS Basics

Basic Selectors

CSS Basics

Getting Started with CSS

CSS Basics

Mobile-First CSS Layout

Mobile-First CSS Layout

Introduction to SQLAlchemy

SQLAlchemy Basics

Timezones

Dates and Times in Python (2014)

Math Quiz App

Dates and Times in Python (2014)

Dates and Times

Dates and Times in Python (2014)

Creating a Memory Game

Basic Object-Oriented Python

Emulating Built-ins

Basic Object-Oriented Python

Welcome to OOP

Basic Object-Oriented Python

Technical Interview Prep: Basic Python

Technical Interview Prep: Python Basics

Buggy Logs

Write Better Python

You as a Mentee

Getting Started as a Mentee

Cleaner Code

Write Better Python

Practice Functions

Practice Creating and Using Functions in Python

Treehouse Festival 2021

Exterminator

100 Days of Code

React Router and Authentication

React Authentication (2019)

Implementing Basic Authentication

React Authentication (2019)

Introducing the Authentication Project

React Authentication (2019)

Get Involved in Open Source

GitHub Basics

Create a Web Presence on GitHub

GitHub Basics

Working on a Team

GitHub Basics

Working By Yourself

GitHub Basics

Hello, GitHub!

GitHub Basics

Validating Data

REST API Validation with Express

The Importance of Data Validation

REST API Validation with Express

Retrieve Related Data in Sequelize Queries

Data Relationships with SQL and Sequelize

Create Related Data Using Sequelize Models

Data Relationships with SQL and Sequelize

Data Relationships in Sequelize

Data Relationships with SQL and Sequelize

Understand Data Relationships

Data Relationships with SQL and Sequelize

Refactoring and Modularizing a REST API

REST APIs with Express

Create, Read, Update, Delete

REST APIs with Express

Managing Data and Asynchronous Code

REST APIs with Express

Getting to Know REST APIs

REST APIs with Express

Getting the REST You Need 2

Introduction to REST APIs

Performing CRUD Operations

Using SQL ORMs with Node.js

Defining Models

Using SQL ORMs with Node.js

Getting Started with Sequelize

Using SQL ORMs with Node.js

Asynchronous Code in Express

Asynchronous Code in Express

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

Going Further with Routing

React Router 4 Basics

Navigating, Nesting and Redirecting Routes

React Router 4 Basics

Getting Started with React Router

React Router 4 Basics

Treehouse Festival (December 2020)

React Component Patterns

React Components (2018)

Stateful Components and Lifecycle Methods

React Components (2018)

Managing State and Data Flow

React Components (2018)

Build Modular Interfaces with Components

React Components (2018)

Stateful Components

React Basics (2018)

Introducing Props

React Basics (2018)

Thinking in Components

React Basics (2018)

First Steps in React

React Basics (2018)

Serving Static Files in Express

Express Basics

Applying Express Knowledge

Express Basics

Middleware

Express Basics

Deeper into Routing with Express

Express Basics

Using Templates with Express

Express Basics

Getting Started with Express

Express Basics

Updating and Uninstalling Packages with npm

npm Basics (retiring)

Installing Packages with npm

npm Basics (retiring)

What is npm?

npm Basics (retiring)

Creating a Command Line Weather Application

Node.js Basics 2017

Handling Errors in Node

Node.js Basics 2017

Getting Data From an API With Node

Node.js Basics 2017

Introduction to Node.js

Node.js Basics 2017

JavaScript Frameworks, Libraries, and Developer Roles

The JavaScript Ecosystem

JavaScript Outside of the Browser

The JavaScript Ecosystem

GET and POST Requests in a Browser

HTTP Basics

Introduction to HTTP

HTTP Basics

Adding the Game Logic

Object-Oriented JavaScript: Challenge

Making the Game Interactive

Object-Oriented JavaScript: Challenge

Rendering the Game

Object-Oriented JavaScript: Challenge

Building Constructor Methods and Generating Objects

Object-Oriented JavaScript: Challenge

Introducing 'Four in a Row'

Object-Oriented JavaScript: Challenge

Reformatting User Input

Regular Expressions in JavaScript

Validating a Form with Regular Expressions

Regular Expressions in JavaScript

Regular Expressions

Regular Expressions in JavaScript

Build an Accessible Form

Accessibility For Web Developers

Introduction To Accessibility

Accessibility For Web Developers

The Role of Selectors in JavaScript

CSS Selectors Quickstart

Pseudo-classes and Combinators

CSS Selectors Quickstart

Selector Basics

CSS Selectors Quickstart

Multidimensional Arrays

JavaScript Arrays

Loop Through Arrays

JavaScript Arrays

Store Multiple Values in an Array

JavaScript Arrays

Loop Through Objects

JavaScript Objects

Object Basics

JavaScript Objects

Working with 'for' Loops

JavaScript Loops

Simplify Repetitive Tasks with Loops

JavaScript Loops

Installing Sass and Setting up the Project

CSS to Sass

Treehouse Festival

Principles of Design

Visual Design Foundations

Elements of Design

Visual Design Foundations

Combining Array Methods

JavaScript Array Iteration Methods

Array Manipulation

JavaScript Array Iteration Methods

Array Iteration

JavaScript Array Iteration Methods

Exploring Async/Await

Asynchronous Programming with JavaScript

Understanding Promises

Asynchronous Programming with JavaScript

Asynchronous JavaScript with Callbacks

Asynchronous Programming with JavaScript

What is Asynchronous Programming?

Asynchronous Programming with JavaScript

Programming AJAX

AJAX Basics

AJAX Concepts

AJAX Basics

Callbacks and the DOM

Callback Functions in JavaScript

Callbacks with Timers

Callback Functions in JavaScript

Introduction to Callback Functions

Callback Functions in JavaScript

Getters and Setters

Object-Oriented JavaScript

100th Techdegree Peer Review

Working with Classes in JavaScript

Object-Oriented JavaScript

Object Basics

Object-Oriented JavaScript

Introduction to Object-Oriented JavaScript

Object-Oriented JavaScript

50th Techdegree Peer Review

Going Further with Grid Layout

CSS Grid Layout

Flexible Sized Grids

CSS Grid Layout

Introducing Grid Layout

CSS Grid Layout

5 Star Techdegree Reviewer

25th Techdegree Peer Review

10th Techdegree Peer Review

5th Techdegree Peer Review

Keyframe and Line Drawing Animations

Animating SVG with CSS

Transitions and Transforms

Animating SVG with CSS

Creating an SVG

SVG Basics

Introduction to SVG

SVG Basics

Improving the Application Code

DOM Scripting By Example

Editing and Filtering Names

DOM Scripting By Example

Adding and Removing Names

DOM Scripting By Example

Using a jQuery Carousel

Using jQuery Plugins

Add a Sticky Navigation Bar

Using jQuery Plugins

Introducing jQuery Plugins

Using jQuery Plugins

1st Techdegree Peer Review

Arrow Functions

JavaScript Functions

Pass Information Into Functions

JavaScript Functions

Create Reusable Code with Functions

JavaScript Functions

The Math Object

JavaScript Numbers

Working with Numbers

JavaScript Numbers

Making Decisions in Your Code with Conditional Statements

JavaScript Basics

Working With Strings

JavaScript Basics

Storing and Tracking Information with Variables

JavaScript Basics

Hello, JavaScript!

JavaScript Basics

Finishing the Game

Introducing JavaScript

Introducing JavaScript

Introducing JavaScript

Add Reusable Logic to Your Sass

Sass Basics

Write Smart and Efficient CSS with Sass

Sass Basics

Improve Your Workflow with Sass

Sass Basics

Getting Started with Sass

Sass Basics

GitHub and Other Remote Repositories

Introduction to Git

Managing Committed Files

Introduction to Git

First Commits

Introduction to Git

Common Commands

Introduction to the Terminal

Directories and Files

Introduction to the Terminal

The Command Shell

Introduction to the Terminal

Adding 3D Effects with CSS

CSS Transitions and Transforms

Getting Started with CSS Transforms

CSS Transitions and Transforms

Transition Timing Functions and Delays

CSS Transitions and Transforms

Getting Started with CSS Transitions

CSS Transitions and Transforms

Structuring Tables

HTML Tables

Table Basics

HTML Tables

Using Slack Effectively

Slack for the Techdegree

Introducing Slack for the Techdegree

Slack for the Techdegree

JavaScript Objects and Conditionals

JavaScript Quickstart

JavaScript Arrays and Loops

JavaScript Quickstart

JavaScript Functions

JavaScript Quickstart

Data Types and Variables

JavaScript Quickstart

JavaScript Tools and Workflows

The Landscape of JavaScript

JavaScript is Everywhere

The Landscape of JavaScript

Iterating and Packing with Dictionaries

Introducing Dictionaries

Introducing Dictionaries

Introducing Dictionaries

Sequence Operations

Python Sequences

Finding the Data You Want

SQL Basics

Getting Data from a Database

SQL Basics

Data, Databases and SQL

SQL Basics

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

All Together Now

Python Basics

Functions and Looping

Python Basics

Types and Branching

Python Basics

Meet Python

Python Basics

Measuring Performance

Introduction to Front End Performance Optimization

Planning for Performance

Introduction to Front End Performance Optimization

Building Forms With Bootstrap

Bootstrap Basics

Using Bootstrap Components

Bootstrap Basics

Responsive Layouts With the Bootstrap Grid

Bootstrap Basics

Getting to Know Bootstrap 4

Bootstrap Basics

Working with jQuery Collections (2017)

jQuery Basics

Understanding jQuery Events and DOM Traversal (2017)

jQuery Basics

Introducing jQuery (2017)

jQuery Basics

Advanced Selectors

CSS Selectors

Going Further with Attribute Selectors and Pseudo-Classes

CSS Selectors

Selectors - Beyond the Basics

CSS Selectors

Traversing the DOM

JavaScript and the DOM (Retiring)

Responding to User Interaction

Interacting with the DOM

Making Changes to the DOM

JavaScript and the DOM (Retiring)

Exploration

Web Design Process

Discovery

Web Design Process

Getting a Handle on the DOM

JavaScript and the DOM (Retiring)

The Browser Environment

JavaScript and the DOM (Retiring)

JavaScript Objects

JavaScript Loops, Arrays and Objects

JavaScript Arrays

JavaScript Loops, Arrays and Objects

JavaScript Loops

JavaScript Loops, Arrays and Objects

Choosing Options

HTML Forms

Organizing Forms

HTML Forms

Form Basics

HTML Forms

Building a Layout with Flexbox

CSS Flexbox Layout

Flexbox Properties

CSS Flexbox Layout

Understanding Flexbox

CSS Flexbox Layout

Responsive Patterns

Responsive Layouts

Media Queries

Responsive Layouts

Responsive Theory

Responsive Layouts

Positioning Page Content

CSS Layout Basics

CSS Layout Project

CSS Layout Basics

Page Layout with the Float Property

CSS Layout Basics

Controlling Layout with CSS Display Modes

CSS Layout Basics

Getting Started with CSS Layout

CSS Layout Basics

JavaScript Functions

JavaScript Basics (Retired)

JavaScript Conditional Statements

JavaScript Basics (Retired)

JavaScript Numbers

JavaScript Basics (Retired)

JavaScript Variables

JavaScript Basics (Retired)

Introducing JavaScript

JavaScript Basics (Retired)

Fundamental Concepts

CSS Basics (2014)

Designing with the Latest Features

CSS Basics (2014)

Basic Layout

CSS Basics (2014)

The Box Model

CSS Basics (2014)

Understanding Values and Units

CSS Basics (2014)

Basic Selectors

CSS Basics (2014)

Getting Started with CSS

CSS Basics (2014)

Going Further with HTML

HTML Basics

Images, Text and Links

HTML Basics

Structuring Your Content

HTML Basics

Getting Started With HTML

HTML Basics

Adding a New Web Page

Introduction to HTML and CSS (2016)

Make It Beautiful with CSS

Introduction to HTML and CSS (2016)

HTML: The Structural Foundation of Web Pages and Applications

Introduction to HTML and CSS (2016)

Getting Familiar with HTML and CSS

Introduction to HTML and CSS (2016)

Meet Objects

Java Objects

Perfecting the Prototype

Java Basics

Using your New Tools

Java Basics

Getting Started with Java

Java Basics

Newbie