Treehouse Festival

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

How to Make Wireframes in Adobe XD

Introduction to Wireframing

How to Make Wireframes in Sketch

How to Make Wireframes in Balsamiq

Introduction to Wireframing

How to Make Wireframes on Paper

Introduction to Wireframing

What is Wireframing?

Introduction to Wireframing

JavaScript Objects and Conditionals

JavaScript Quickstart

JavaScript Arrays and Loops

JavaScript Quickstart

JavaScript Functions

JavaScript Quickstart

Data Types and Variables

JavaScript Quickstart

Principles of Design

Visual Design Foundations

Python: Inheritance

Object-Oriented Python

Python: Instant Objects

Object-Oriented 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

All Together Now

Python Basics

Functions and Looping

Python Basics

Object-Oriented Programming

C# Objects

If Statements

C# Basics

Numbers

C# Basics

Strings

C# Basics

Methods

C# Basics

C# Syntax

C# Basics

Adding and Removing Names

DOM Scripting By Example

Thinking in Components

React Basics (2018)

First Steps in React

React Basics (2018)

Object Basics

Object-Oriented JavaScript

Using your New Tools

Java Basics

Getting Started with Java

Java Basics

Types and Branching

Python Basics

AJAX Concepts

AJAX Basics

Measuring Performance

Introduction to Front End Performance Optimization

Working with jQuery Collections (2017)

jQuery Basics

Understanding jQuery Events and DOM Traversal (2017)

jQuery Basics

Structuring Tables

HTML Tables

Planning for Performance

Introduction to Front End Performance Optimization

Table Basics

HTML Tables

Introduction to SVG

SVG Basics

Introducing jQuery (2017)

jQuery Basics

The Internet

How the Internet Works

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)

Store Inventory Using Modules

Ruby Modules

Include and Extend

Ruby Modules

Ruby Core Modules

Ruby Modules

Ruby Module Basics

Ruby Modules

Input and Output

Build an Address Book in Ruby

Search

Build an Address Book in Ruby

Ruby Class Design

Build an Address Book in Ruby

Blocks Practice

Ruby Blocks

Working With Blocks

Ruby Blocks

Ruby Blocks

Ruby Blocks

Build a Bank Account Class

Ruby Objects and Classes

Ruby Variables and Methods

Ruby Objects and Classes

Ruby Objects and Classes

Ruby Objects and Classes

Build a Simple Contact List

Ruby Loops

Ruby Iteration

Ruby Loops

Ruby Loops

Ruby Loops

Build a Grocery List Program

Ruby Collections

Ruby Hashes

Ruby Collections

Ruby Arrays

Ruby Collections

Ruby Conditionals

Ruby Basics

Ruby Numeric Types

Ruby Basics

Ruby Objects

Ruby Basics

Ruby Strings and Escape Sequences

Ruby Basics

Ruby Syntax

Ruby Basics

The Command Shell

Introduction to the Terminal

Choosing Options

HTML Forms

Organizing Forms

HTML Forms

Building a Layout with Flexbox

CSS Flexbox Layout

Flexbox Properties

CSS Flexbox Layout

Introducing Scrum

Scrum Basics

What is Agile?

Scrum Basics

Playing a Counting Game

Introduction to Algorithms

Introduction to Object-Oriented JavaScript

Object-Oriented JavaScript

Elements of Design

Visual Design Foundations

S3 Storage Service

AWS with S3

Important Skills For Professional Success

Soft Skills

AWS and "The Cloud"

AWS with S3

JavaScript Tools and Workflows

The Landscape of JavaScript

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

Art Direction with the Picture Element

Responsive Images

Image Delivery with Srcset and Sizes

Responsive Images

Finding the Data You Want

SQL Basics

Getting Data from a Database

SQL Basics

JavaScript is Everywhere

The Landscape of JavaScript

What Is WordPress?

What Is WordPress?

Data, Databases and SQL

SQL Basics

Understanding Flexbox

CSS Flexbox Layout

Responsive Patterns

Responsive Layouts

Media Queries

Responsive Layouts

Computer Languages

Computer Basics

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

Getting a Handle on the DOM

JavaScript and the DOM (Retiring)

The Browser Environment

JavaScript and the DOM (Retiring)

The Role of Selectors in JavaScript

CSS Selectors Quickstart

Pseudo-classes and Combinators

CSS Selectors Quickstart

Selector Basics

CSS Selectors Quickstart

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

Debugging HTML and CSS Problems

How to Make a Website

Sharing a Website

How to Make a Website

Responsive Web Design and Testing

How to Make a Website

Adding Pages to a Website

How to Make a Website

Styling Web Pages and Navigation

How to Make a Website

Customizing Colors and Fonts

How to Make a Website

CSS: Cascading Style Sheets

How to Make a Website

Creating HTML Content

How to Make a Website

HTML First

How to Make a Website

Beginning HTML and CSS

How to Make a Website

JavaScript Objects

JavaScript Loops, Arrays and Objects

JavaScript Arrays

JavaScript Loops, Arrays and Objects

Responsive Theory

Responsive Layouts

Telling the Story

Design Thinking

Designing for Your User’s "To-be"

Design Thinking

Machine Learning Vocabulary

Machine Learning Basics

Introduction to Machine Learning

Machine Learning Basics

Hello, GitHub!

GitHub Basics

Adding Power to Functions

Functions in Swift

Functions in Swift

Functions in Swift

Control Flow With Conditional Statements

Swift Collections and Control Flow

Control Flow With Loops

Swift Collections and Control Flow

Dictionaries in Swift

Swift Collections and Control Flow

Introduction to Collections

Swift Collections and Control Flow

Swift Operators

Swift Basics

Swift Types

Swift Basics

JavaScript Loops

JavaScript Loops, Arrays and Objects

Finishing the Game

Introducing JavaScript

Introducing JavaScript

Introducing JavaScript

Demystifying the Portfolio

Building a Portfolio

Meet Python

Python Basics

Using Slack Effectively

Slack for the Techdegree

Introducing Slack for the Techdegree

Slack for the Techdegree

Designing with Patterns

UX Design Patterns (2018 Version)

Understanding your User’s “As-is” Scenario

Design Thinking

Becoming Acquainted with Your User

Design Thinking

Becoming a Design Thinker

Design Thinking

JavaScript Frameworks, Libraries, and Developer Roles

The JavaScript Ecosystem

JavaScript Outside of the Browser

The JavaScript Ecosystem

An Introduction to Swift Programming

Swift Basics

Computer Basics

Computer Basics

Form Basics

HTML Forms

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

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

Introduction to Video Games

How to Make a Video Game

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)

Newbie