Oliver Jiang

Oliver Jiang

Member Since January 28, 2012
Open to Work

14,123

Total Points

Points are earned whenever you take an important action on Treehouse.
Learn more about when and how points are earned.

Skills & Experience

183 Achievements

  • Covering Your Bases
  • Be Assertive!
  • What Is Testing?
  • Working with SQLAlchemy
  • Subqueries
  • Set Operations
  • Joining Table Data with SQL
  • Table Relationships
  • Database Keys
  • Database Normalization
  • Date and Time Functions
  • Aggregate and Numeric Functions
  • Working with Text
  • Ordering, Limiting and Paging Results
  • Introduction to SQLAlchemy
  • Creating and Modifying Database Tables
  • Handling Errors When Manipulating Data
  • Deleting Data from a Database
  • Updating Data in a Database
  • Adding Data to a Database
  • Finding the Data You Want
  • Getting Data from a Database
  • Data, Databases and SQL
  • Creating a Memory Game
  • Emulating Built-ins
  • Welcome to OOP
  • Python Regular Expressions
  • Timezones
  • Math Quiz App
  • Dates and Times
  • Buggy Logs
  • Cleaner Code
  • Dice Roller
  • Python: Advanced Objects
  • Python: Inheritance
  • Python: Instant Objects
  • Iterating and Packing with Dictionaries
  • Introducing Dictionaries
  • Sequence Operations
  • Sequence Iterations
  • Packing and Unpacking
  • Getting Info In and Out of Functions
  • Introduction to Functions
  • Getting to Know Tuples
  • Python Sets
  • Python Tuples
  • Python Dictionaries
  • Python Slices
  • Python Lists
  • Build an Application
  • Using Lists
  • Meet Lists
  • All Together Now
  • Functions and Looping
  • Types and Branching
  • Meet Python
  • Introduction to MEAN
  • Using Angular's Built-in Directives
  • Controllers and Scope
  • Getting Started with Angular
  • Introducing Sketch
  • Recording a Voice Memo
  • Tying It All together
  • Diving Deeper
  • Memory, Arrays and Loops, Oh My!
  • Getting Oriented - Object-Oriented, That Is
  • Two-stage Object Creation
  • What Are Design Patterns?
  • Swift 2.0 Protocols
  • Objects and Optionals
  • Introduction to Optionals
  • Introduction to Enumerations
  • Refactoring Our Code (objc)
  • What is User Experience (UX)?
  • Color Theory
  • Principles
  • Elements
  • Building the Master and Detail Views (objC)
  • Start menu and App Icon
  • Sound Design
  • Managing Playlist Data (objC)
  • Animating and Saving Sprites
  • Designing Characters and a Scene
  • Introduction to Game Design
  • Building a Music Library Model (objc)
  • Working With Multiple View Controllers (ObjC)
  • Deploying to a Device (ObjC)
  • Debugging Our App (ObjC)
  • Improving Our User Interface (ObjC)
  • Creating a Data Model (ObjC)
  • Views and View Controllers (ObjC)
  • Getting Started with Xcode (ObjC)
  • Immersive Examples
  • Scope and Loops
  • More Operators
  • Operators and Conditionals
  • Data Types and Variables
  • Intro to Objective-C
  • Structs as Data Models
  • View Controllers and Views
  • Getting Started with iOS Development
  • Differentiating Between Objects
  • Class Inheritance
  • Classes
  • Complex Data Structures
  • Function Parameters
  • Functions in Swift 2.0
  • Control Flow with Conditional Statements
  • Control Flow With Loops
  • Swift Dictionaries
  • Introduction to Collections
  • Swift Operators
  • Swift Types
  • An Introduction to Swift Programming
  • Installing a Ruby Development Environment
  • Displaying Our Weather Data
  • Data Modeling With Structures
  • Concurrency
  • Pulling Data From the Web
  • Building a Music Library and Playlists (Swift)
  • Using a Navigation Controller With Segues (Swift)
  • Working With Multiple View Controllers (Swift)
  • Deploying to a Device
  • Debugging Our App
  • Improving Our User Interface
  • Using a Data Model
  • Views and View Controllers
  • Getting Started with Xcode
  • Swift Value vs Reference Types
  • Swift Properties
  • Swift Inheritance
  • Swift Classes and Objects
  • Swift Structs and their Methods
  • Swift Structs
  • Swift Enums and their Methods
  • Swift Enums
  • Swift Optionals
  • Swift Parameters and Tuples
  • Swift Functions
  • Control Flow
  • Collections
  • Operators
  • Types
  • Variables and Constants
  • Implementing Custom Login and Sign Up Screens
  • Retrieving and Viewing Data from Parse.com
  • Capturing Photo and Video Using UIImagePickerController
  • Relating Users in Parse.com
  • Using Parse.com as a Backend and Adding Users
  • Designing and Starting the App
  • Storyboards
  • Blocks and Categories
  • Share Your Creation
  • Animate This
  • Shaking Things Up
  • Making It Pretty
  • Learning the Language
  • Getting Started with iPhone
  • Your First App
  • Mastery Challenge
  • CSS
  • Framework Foundations
  • Printing
  • Page Layout
  • Box Model
  • Text Code Challenge
  • Text
  • Data Types
  • Selector Code Challenge
  • Selectors
  • Introduction
  • HTML Master
  • HTML
  • Forms
  • Tables Challenge
  • Tables
  • Objects
  • Links
  • List Challenge
  • Lists
  • Text
  • Introduction
  • Newbie