Andrew Showalter

Andrew Showalter

Member Since December 29, 2013
Open to Work

14,028

Total Points

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

Skills & Experience

  • Spoken Languages

    • English
    • Spanish

179 Achievements

  • Vulnerabilities: Configuration, Components, and Logging
  • Vulnerabilities: Authentication, Access, and Sensitive Data
  • Maintaining Secure Web Apps
  • Protecting Data and Keeping Attackers Out
  • Why Protect Your Web Apps
  • Vulnerabilities:  Injection, XSS, CSRF
  • The OWASP Top 10 Explained
  • Component Lifecycle
  • Designing Dataflow
  • Stateful Components
  • Thinking in Components
  • First Steps in React
  • Native WordPress Customizer Options
  • Overview of the WordPress Customizer
  • Setting Up Your Local Environment for Spring Development
  • Installing Sass and Setting up the Project
  • GET and POST Requests in a Browser
  • Introduction to HTTP
  • Getting the REST You Need
  • Understanding MongoDB
  • Getting Started with MongoDB
  • Constructor Functions & Prototypes
  • Using a jQuery Carousel
  • Add a Sticky Navigation Bar
  • Introducing jQuery Plugins
  • Creating a Simple Drawing Application
  • Creating a Mobile Drop Down Menu
  • Creating a Simple Lightbox
  • Finishing Your WordPress Theme
  • Adding a Blog to a WordPress Theme
  • Custom Homepage Templates in WordPress
  • Custom Post Type Templates
  • JavaScript Objects
  • JavaScript Arrays
  • Building Out WordPress Navigation
  • Building Page Templates in WordPress
  • The WordPress Loop
  • JavaScript Loops
  • WordPress Header and Footer Templates
  • Working with CSS and JS in WordPress Themes
  • JavaScript Functions
  • JavaScript Conditional Statements
  • Starting a WordPress Theme
  • JavaScript Numbers
  • More Advanced PHP for WordPress
  • PHP Basics for WordPress
  • Introduction to PHP for WordPress
  • Basic Android Programming
  • Creating the Initial Screen Layout
  • The WordPress Codex
  • WordPress Plugin Best Practices
  • Widgets and Custom Menus
  • Custom Post Types and Fields
  • Customizing WordPress Themes
  • WordPress Themes
  • Installing Wordpress
  • Getting Started with Android
  • JavaScript Variables
  • Introducing JavaScript
  • Database Security
  • Queries & Results
  • Getting Started with PDO
  • Contact Forms & Mailers
  • Slim and Templates
  • Introduction to Methods
  • PHP Internal Functions
  • PHP Returns & Closures
  • PHP Functions Basics
  • PHP Loops
  • PHP Conditionals
  • PHP Datatypes
  • PHP Data & Structure
  • PHP Getting Started
  • AJAX and APIs
  • Dependency Management
  • jQuery and AJAX
  • Introduction to Node.js
  • Creating a Simple Server in Node.js
  • Autoloading and Composer
  • Creating a Password Confirmation Form
  • Tools for Testers
  • How To Test Our Code
  • AngularJS MVC Frameworks
  • Using your New Tools
  • Creating a Spoiler Revealer
  • Introduction to jQuery
  • Getting Started with Java
  • Starting Right with PHP Best Practices
  • Selectors
  • Limiting Results in Queries
  • Using Relationship Tables
  • Filtering Input for Queries
  • Selecting Elements and Adding Events with JavaScript
  • JavaScript and the DOM
  • Querying the Database
  • Connecting to MySQL
  • Getting Started with CSS
  • 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
  • Variables and Constants
  • Reading Data from Databases with SQL
  • Installing MySQL Server and MySQL Workbench
  • Introduction to Data, Databases and SQL
  • Paginating a List: Model and View
  • Paginating a List: Controller
  • Adding Search: Model
  • Adding Search: Controller & View
  • Refactoring the Codebase
  • Simple PHP Application: Wrapping Up The Project
  • JavaScript Objects
  • JavaScript Functions
  • Laravel Getting Started
  • Working with PHP Functions
  • Integrating With Paypal
  • Listing Inventory Items
  • Adding a Contact Form
  • Creating the Menu and Footer
  • Chrome DevTools Basics
  • Getting Started with PHP
  • Forms
  • Tables
  • Objects
  • Links
  • Lists
  • Text
  • Introduction
  • Functions
  • Objects and Arrays
  • Control Structures
  • Basics
  • Debugging HTML and CSS Problems
  • Sharing a Website
  • Responsive Web Design and Testing
  • Adding Pages to a Website
  • Styling Web Pages and Navigation
  • Customizing Colors and Fonts
  • Connecting WordPress Plugins with 3rd Party APIs
  • Building a WordPress Plugin Settings Page
  • CSS: Cascading Style Sheets
  • How WordPress Plugins Work
  • Creating HTML Content
  • HTML First
  • Beginning HTML and CSS
  • Cleaning URLs with Rewrite Rules
  • Programming AJAX
  • AJAX Concepts
  • Objects, Classes, and Variables
  • Ruby Basics
  • Installing a Ruby Development Environment
  • Better SEO Through Tools
  • Better SEO Through Code
  • Better SEO Through Content
  • Introduction to SEO
  • Cleaning URLs with Subfolders
  • Integrating Validation Errors
  • JavaScript Arrays
  • JavaScript Numbers
  • PHP Inheritance & Interfaces
  • PHP Properties & Methods
  • PHP Objects and Classes
  • JavaScript Strings
  • Content Strategy with WordPress
  • Local WordPress Development
  • Introduction Variables
  • Workflows
  • Merging
  • Working With Remote Repositories
  • Branches
  • Getting Started With Git
  • Why Version Control Matters
  • Installing Programs
  • Environment and Redirection
  • Console Processes
  • Console Users and Permission
  • Moving Around in the Console
  • Newbie