Day 3: Getting Creative

SQL Reporting by Example

Day 1: Joining Tables

SQL Reporting by Example

Orientation: Selecting Data

SQL Reporting by Example

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

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

Threads in Android

Threads and Services

Interacting with Google+ APIs

Google Play Services

Connecting to Play Services

Google Play Services

Interacting with Your API

Google Play Services

Adding Play Services to Your App

Google Play Services

Tablet Time

Android Fragments

Ingredients and Directions

Android Fragments

Managing Fragments

Android Fragments

Introducing Fragments

Android Fragments

The Project

Android Activity Lifecycle

Introducing SharedPreferences

Android Activity Lifecycle

The Activity Lifecycle

Android Activity Lifecycle

Hooking Up the Model to the View

Build a Weather App

Building the Weather UI

Build a Weather App

Working with JSON

Build a Weather App

Concurrency and Error Handling

Build a Weather App

Networking

Build a Weather App

Exploring an API

Build a Weather App

The Rest of the Story

Build an Interactive Story App

Finishing the User Interface

Build an Interactive Story App

The Model-View-Presenter Pattern

Build an Interactive Story App

Intents and Multiple Activities

Build an Interactive Story App

Tuning the User Interface

Build an Interactive Story App

User Input in Android

Build an Interactive Story App

Testing and Debugging

Build a Simple Android App with Java

Improving Our Code

Build a Simple Android App with Java

Basic Android Programming

Build a Simple Android App with Java

Creating the Screen Layout

Build a Simple Android App with Java

Getting Started with Android

Build a Simple Android App with Java

Java Inheritance

Inheritance in Java

Gotchas and Wins

Java Arrays

Iteration

Java Arrays

Creation

Java Arrays

Harnessing the Power of Objects

Java Objects

Meet Objects

Java Objects

Perfecting the Prototype

Java Basics

Getting Started with Java

Java Basics

Using your New Tools

Java Basics

What is Wireframing?

Introduction to Wireframing

Principles of Design

Visual Design Foundations

Elements of Design

Visual Design Foundations

PHP on the Web

PHP Basics

Daily Exercise Program

PHP Basics

Unit Converter

PHP Basics

Getting to Know PHP

PHP Basics

More Association Options

Active Record Associations in Rails

Using Associations in Your App

Active Record Associations in Rails

Active Record Associations

Active Record Associations in Rails

A Route to a Delete Action

Rails Routes and Resources

Routes to Update Actions

Rails Routes and Resources

Routes for Create Actions

Rails Routes and Resources

A Route to a Read Action

Rails Routes and Resources

Rails Resource Index

Rails Routes and Resources

Adding a Model Attribute

Ruby on Rails 5 Basics

Using the Rails Console

Ruby on Rails 5 Basics

Handling Rails Requests

Ruby on Rails 5 Basics

Creating Rails Apps

Ruby on Rails 5 Basics

Finding the Data You Want

SQL Basics

Getting Data from a Database

SQL Basics

Data, Databases and SQL

SQL Basics

Sinatra Finishing Touches

Building Web Apps with Sinatra

Updating Data in Sinatra

Building Web Apps with Sinatra

Adding New Data in Sinatra

Building Web Apps with Sinatra

Sinatra ERB Templates

Building Web Apps with Sinatra

Creating New Sinatra Apps

Building Web Apps with Sinatra

Gems In Depth

Ruby Gems

Ruby Gems

Ruby Gems

Ruby Standard Library: Part 2

Ruby Core and Standard Library

Ruby Standard Library: Part 1

Ruby Core and Standard Library

Ruby Core

Ruby Core and Standard Library

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

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

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

Working with Classes in JavaScript

Object-Oriented JavaScript

Object Basics

Object-Oriented JavaScript

Introduction to Object-Oriented JavaScript

Object-Oriented JavaScript

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

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)

Getting a Handle on the DOM

JavaScript and the DOM (Retiring)

The Browser Environment

JavaScript and the DOM (Retiring)

JavaScript Tools and Workflows

The Landscape of JavaScript

JavaScript is Everywhere

The Landscape of JavaScript

Loop Through Objects

JavaScript Objects

Object Basics

JavaScript Objects

Multidimensional Arrays

JavaScript Arrays

Loop Through Arrays

JavaScript Arrays

Store Multiple Values in an Array

JavaScript Arrays

Working with 'for' Loops

JavaScript Loops

Simplify Repetitive Tasks with Loops

JavaScript Loops

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

Going Further with Grid Layout

CSS Grid Layout

Flexible Sized Grids

CSS Grid Layout

Introducing Grid Layout

CSS Grid Layout

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

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

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

Build an Accessible Form

Accessibility For Web Developers

Introduction To Accessibility

Accessibility For Web Developers

Advanced Selectors

CSS Selectors

Going Further with Attribute Selectors and Pseudo-Classes

CSS Selectors

Selectors - Beyond the Basics

CSS Selectors

Choosing Options

HTML Forms

Organizing Forms

HTML Forms

Form Basics

HTML Forms

Structuring Tables

HTML Tables

Table Basics

HTML Tables

Building a Layout with Flexbox

CSS Flexbox Layout

Flexbox Properties

CSS Flexbox Layout

Understanding Flexbox

CSS Flexbox Layout

Mobile-First CSS Layout

Mobile-First 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

CSS Media Queries

CSS Layout

CSS Layout Techniques

CSS Layout

Box Model Concepts

CSS Layout

The CSS Box Model

CSS Layout

Fundamental Concepts

CSS Basics

Understanding Values and Units

CSS Basics

Basic Selectors

CSS Basics

Getting Started with CSS

CSS Basics

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