yan qingsong

yan qingsong

Member Since May 20, 2016

15,282

Total Points

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

192 Achievements

  • Securing and Maintaining a MySQL Database
  • SQL Calculating, Aggregating and Other Functions
  • Joining Relational Data Between Tables in SQL
  • Manipulating Schema with SQL
  • Creating Tables and Manipulating Data with SQL
  • Reading Data from Databases with SQL
  • Installing Programs
  • Environment and Redirection
  • Installing MySQL Server and MySQL Workbench
  • Introduction to Data, Databases and SQL
  • Traversing and Manipulating the DOM with JavaScript
  • Selecting Elements and Adding Events with JavaScript
  • JavaScript and the DOM
  • Lists
  • Text
  • Introduction
  • Finding the Data You Want
  • Getting Data from a Database
  • Data, Databases and SQL
  • Express Middleware
  • Get Involved in Open Source
  •  Create a Web Presence on GitHub
  • Sessions and Cookies
  • User Registration and Login
  • What is Authentication?
  •  Working on a Team
  • Working By Yourself
  • Hello, GitHub!
  • Workflows
  • Working With Remote Repositories
  • Merging
  • Branches
  • Getting Started With Git
  • Why Version Control Matters
  • Creating and Editing Data in a MEAN App
  • Setting Up MongoDB
  • Going MEAN with Angular
  • Going MEAN with Express
  • Introduction to MEAN
  • Introducing jQuery Plugins
  • Updating and Uninstalling Packages with npm
  • Installing Packages with npm
  • What is npm?
  • Completing and Testing the API
  • Communicating with Mongo Through Mongoose
  • Modeling Data for the API
  • Building API Routes in Express
  • Building a REST Service
  • Go Further With Mongo
  • Working With Collections
  • Understanding MongoDB
  • Getting Started with MongoDB
  • Doing More with Express
  • Serving Static Files in Express
  • Using Templates with Express
  • The Request and Response Objects in Express
  • Developing Express Apps Like a Boss
  • Getting Started with Express
  • Creating a Simple Drawing Application
  • Building a Command Line Application
  • Introduction to Node.js
  • Creating a Password Confirmation Form
  • Creating a Mobile Drop Down Menu
  • Creating a Simple Lightbox
  • Creating a Spoiler Revealer
  • JavaScript Objects
  • JavaScript Arrays
  • JavaScript Loops
  • Fundamental Concepts
  • Designing with the Latest Features
  • Basic Layout
  • The Box Model
  • Understanding Values and Units
  • Broadcasting
  • Takin' Names
  • Console Processes
  • Console Users and Permission
  • Visual Format Language
  • Auto Layout in Code
  • Moving Around in the Console
  • Styling Web Pages and Navigation
  • Adding a New Web Page
  • Make It Beautiful with CSS
  • HTML: The Structural Foundation of Web Pages and Applications
  • Getting Familiar with HTML and CSS
  • Trait Collections
  • Inequalities, Content and Priorities
  • Generics with Swift 2 - Beyond Basics
  • Generics with Swift 2
  • Introduction to jQuery
  • JavaScript Functions
  • JavaScript Conditional Statements
  • Adding Sound Effects
  • Refactoring the Model
  • Creating the User Interface Programmatically
  • Creating a Story
  • Navigating Through an Adventure
  • JavaScript Numbers
  • JavaScript Variables
  • Delegation in iOS
  • Introduction to Delegates
  • Memory Management in Swift 2
  • Extensions and Protocols
  • Value Semantics, Type Methods and Inheritance
  • Introducing JavaScript
  • Differentiating Between Objects
  • Class Inheritance
  • Classes
  • Complex Data Structures
  • Asynchronous Error Handling
  • Closures in Cocoa Touch
  • Building Standard Library Functions
  • Closure Expressions
  • First Class Functions
  • Object Initialization in Swift 2
  • Properties in Swift 2
  • Function Parameters
  • Control Flow With Loops
  • Swift Dictionaries
  • Introduction to Collections
  • Swift Operators
  • Swift Types
  • An Introduction to Swift Programming
  • Enhancing the Networking Stack
  • URLs and Parameter Encoding
  • Introduction to UITableView
  • API Protection
  • Resourceful Blueprints
  • Making Strong Users
  • Introduction to HTTP
  • Building Custom Filters
  • Building Custom Tags
  • Template Tags and Filters
  • Final Details
  • Django Templates
  • Model Administration
  • What a View
  • Say Hello to Django
  • The Lambda Lambada
  • Functional Workhorses
  • Functional Rules
  • Python Regular Expressions
  • Gettin' CRUD-y With It
  • Our Diary App
  • Meet Peewee
  • Basic Selectors
  • Getting Started with CSS
  • GET and POST Requests in a Browser
  • Getting the REST You Need
  • Character Builder
  • Timezones
  • Math Quiz App
  • Flask Templates
  • Welcome to Flask
  • Dates and Times
  • Implementing a Forecast Client
  • Protocol Oriented Networking
  • Fetching Data From the Web
  • Modeling Forecast Data
  • Buggy Logs
  • Customizing Colors and Fonts
  • The Constraint Equation
  • A History Lesson
  • Cleaner Code
  • Cleaner Code
  • CSS: Cascading Style Sheets
  • Creating HTML Content
  • HTML First
  • Beginning HTML and CSS
  • Dungeon Game
  • Tuples
  • Dictionaries
  • Slices
  • Lists Redux
  • Letter Game App
  • Number Game App
  • Shopping List App
  • Logic in Python
  • UIKit Dynamics
  • Python Data Types
  • View Controller Transitions
  • Gestures
  • What is an API?
  • Downloading Data with NSURLSession
  • Collection Views
  • Python For Beginners
  • Hack-n-Slash
  • Python Inheritance
  • Python Objects
  • Getting Oriented - Object-Oriented, That Is
  • Designing and Starting the App
  • Newbie