John Grillo

John Grillo

Hillsboro, OR
Open to Work

John Grillo is a graduate from Pacific University in Forest Grove. John Grillo college degrees in International Relations and Media arts with accompanying dual minors in Business Administration and Japanese.

30,241

Total Points

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

Skills & Experience

  • Company

    Grillo Resources, LLC

  • Job Title

    Business Owner & Lead Developer

  • Spoken Languages

    • Japanese
    • English
    • Mandarin
  • Awards

    • National Career Readiness Certificate Silver

374 Achievements

  • Set Operations
  • Joining Table Data with SQL
  • Table Relationships
  • Database Keys
  • Database Normalization
  • Orientation: Selecting Data
  • Hierarchy and Layout
  • Writing Copy
  • Creating and Modifying Database Tables
  • Searching Names
  • Sorting Algorithms
  • Merge Sort and Linked Lists
  • The Merge Sort Algorithm
  • Building a Linked List
  • Recursion and Space Complexity
  • Algorithms in Code
  • Time Complexity
  • Playing a Counting Game
  • Exploring Arrays
  • Dockerize a Web App
  • Managing Images and Containers
  • Building Images Using Dockerfiles
  • Fundamentals of Docker
  • Docker Use Cases
  • Pipelines
  • Practical Jenkins
  • How Jenkins Works
  • Common Attacks and Defenses
  • Hello Internet!
  • Security in Practice
  • Regular Expressions
  • Principles of Design
  • Elements of Design
  • Efficiency!
  • Common Commands
  • Directories and Files
  • The Command Shell
  • What is the MailChimp API
  • Java Maps
  • Java Lists
  • Interfaces in Java
  • Generics in Java
  • How to Critique Design
  • Exploring the Java Collections Framework
  • Error Checking
  • Conditional Formatting
  • Pivot Tables
  • LOOKUP Functions
  • Branches on Git Hosting Services
  • Remote Branches
  • Merging
  • Branches
  • Security: Solutions
  • Security: Concerns
  • Introducing IntelliJ and Unpacking Packages
  • Java Inheritance
  • Getting the REST You Need 2
  • The Data Analysis Process
  • Getting to Know Your Data
  • Introducing Data Analysis
  • GitHub and Other Remote Repositories
  • Managing Committed Files
  • First Commits
  • Team Collaboration in Figma
  • Prototyping Designs in Figma
  • Introducing Figma
  • Design Patterns
  • Page Layout
  • The Design Solution
  • The Design Problem
  • Design Principles
  • What is Product Design?
  • Telling the Story
  • Designing for Your User’s "To-be"
  • Understanding your User’s “As-is” Scenario
  • Becoming Acquainted with Your User
  • Becoming a Design Thinker
  • Exploration
  • Discovery
  • Get Involved in Open Source
  •  Create a Web Presence on GitHub
  •  Working on a Team
  • Working By Yourself
  • Hello, GitHub!
  • Organizing Data
  • Getting There
  • Gotchas and Wins
  • Iteration
  • Creation
  • Delivering the MVP
  • Creating the MVP
  • Harnessing the Power of Objects
  • Meet Objects
  • Perfecting the Prototype
  • Using your New Tools
  • Getting Started with Java
  • Lists, Code, Links and Images
  • Understanding Markdown
  • Scrum Artifacts
  • Scrum Events
  • Introducing Scrum
  • What is Agile?
  • 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
  • GET and POST Requests in a Browser
  • Introduction to HTTP
  • S3 Storage Service
  • AWS and "The Cloud"
  • Getting the REST You Need
  • Moving Beyond the Blog
  • Finding Business
  • Creating Content
  • Introduction to Blogging
  • Installing WordPress Locally
  • What Is WordPress?
  • Next Steps
  • Financing Our Company
  • Selling Your Product
  • Marketing Your Product
  • Product Market Fit
  • Practicing Data Visualization in Excel
  • Chart Formatting and Layout
  • When To Use What Type of Chart
  • Introduction To Data Visualization
  • Art Direction with the Picture Element
  • Image Delivery with Srcset and Sizes
  • Captioning Video
  • Media Basics
  • Going Further with HTML
  • Images, Text and Links
  • Structuring Your Content
  • Getting Started With HTML
  • Rehearsal and Delivery
  • Creating and Refining
  • Preparing to Present
  • Big Data at Netflix
  • Where and How Big Data Is Used
  • What is Big Data
  • Build a Spreadsheet
  • Spreadsheet Best Practices
  • Spreadsheet Functions & Formulas
  • Getting Started With Spreadsheets
  • Introducing Spreadsheets
  • MASH JavaScript
  • MASH CSS
  • MASH HTML
  • Treehouse Club - JavaScript
  • Treehouse Club - CSS
  • Welcome to the Treehouse Club
  • Discovery
  • Protecting and Sharing Your Work
  • Licensing
  • Fair Use and Public Domain
  • Getting Started with Copyright
  • Business Plan for Freelance Business
  • Business Plan Basics
  • The Internet
  • WWW
  • Computer Languages
  • Computer Basics
  • Testing for Accessibility
  • Mobile Accessibility
  • Accessible UI Patterns
  • Semantic HTML and WAI-ARIA
  • WCAG 2.0 (and Other Standards)
  • Access for Everybody
  • Improving the Application Code
  • Editing and Filtering Names
  • Adding and Removing Names
  • Traversing the DOM
  • Responding to User Interaction
  • Making Changes to the DOM
  • Getting a Handle on the DOM
  • The Browser Environment
  • Ruby Loops
  • Build a Grocery List Program
  • Ruby Hashes
  • Ruby Arrays
  • Ruby Logical Operators
  • Ruby Control Structures
  • Ruby Operators
  • Ruby Methods
  • Ruby Numbers (Ruby Basics)
  • Ruby Strings (Ruby Basics)
  • How Ruby Works
  • Workflows
  • Working With Remote Repositories
  • Merging
  • Branches
  • Getting Started With Git
  • Why Version Control Matters
  • Building a Layout with Flexbox
  • Flexbox Properties
  • Understanding Flexbox
  • Handling Errors When Manipulating Data
  • Deleting Data from a Database
  • Updating Data in a Database
  • Adding Data to a Database
  • Date and Time Functions
  • Aggregate and Numeric Functions
  • Working with Text
  • Ordering, Limiting and Paging Results
  • Combine and Minify Assets
  • Optimize Assets
  • Measuring Performance
  • Planning for Performance
  • Web Apps
  • Websites
  • Introduction
  • Creating an SVG
  • Introduction to SVG
  • Chrome DevTools Basics
  • Advanced Selectors
  • Going Further with Attribute Selectors and Pseudo-Classes
  • Selectors - Beyond the Basics
  • Positioning Page Content
  • CSS Layout Project
  • AJAX and APIs
  • Page Layout with the Float Property
  • Controlling Layout with CSS Display Modes
  • Getting Started with CSS Layout
  • Limiting Results in Queries
  • jQuery and AJAX
  • Programming AJAX
  • AJAX Concepts
  • Quiz Practice Project
  • Prototypal Inheritance
  • Constructor Functions & Prototypes
  • Introduction to Methods
  • Responsive Patterns
  • Media Queries
  • Responsive Theory
  • Traversing and Manipulating the DOM with JavaScript
  • Selecting Elements and Adding Events with JavaScript
  • JavaScript and the DOM
  • Creating a Simple Drawing Application
  • Creating a Password Confirmation Form
  • Creating a Mobile Drop Down Menu
  • Finding the Data You Want
  • Getting Data from a Database
  • Data, Databases and SQL
  • DNS Basics
  • Creating a Simple Lightbox
  • Creating a Spoiler Revealer
  • Securing and Maintaining a MySQL Database
  • SQL Calculating, Aggregating and Other Functions
  • Joining Relational Data Between Tables in SQL
  • Graphic Basics
  • Manipulating Schema with SQL
  • Creating Tables and Manipulating Data with SQL
  • Using Relationship Tables
  • Filtering Input for Queries
  • Reading Data from Databases with SQL
  • Introduction to jQuery
  • Installing MySQL Server and MySQL Workbench
  • Introduction to Data, Databases and SQL
  • Creating Home Page Assets
  • Applying Effects
  • JavaScript Objects
  • JavaScript Arrays
  • How to Draw in Illustrator
  • Querying the Database
  • Connecting to MySQL
  • JavaScript Loops
  • JavaScript Functions
  • JavaScript Conditional Statements
  •  Adding Color and Type
  • JavaScript Numbers
  • Website Basics
  • JavaScript Variables
  • Creating an Icon
  • Introducing JavaScript
  • Forms
  • Tables
  • Objects
  • Links
  • Text
  • Lists
  • Introduction
  • Installing Programs
  • Environment and Redirection
  • Advanced Sass Concepts
  • Console Processes
  • Console Users and Permission
  • Moving Around in the Console
  • Speeding up Workflow With Sass
  • Variables, Mixins, and Extending Selectors
  • Getting Started with Sass
  • JavaScript Objects
  • JavaScript Functions
  • JavaScript Arrays
  • JavaScript Numbers
  • JavaScript Strings
  • Introduction Variables
  • Functions
  • Objects and Arrays
  • Control Structures
  • Basics
  • Designing with the Latest Features
  • Introduction to Illustrator
  • Basic Layout
  • Fundamental Concepts
  • The Box Model
  • Understanding Values and Units
  • Basic Selectors
  • Getting Started with CSS
  • Moving Forward with UX
  • Tools UXers Use
  • How UXers Think
  • What Do User Experience Designers Do?
  • What is User Experience (UX)?
  • Finalizing the Project
  • Case Studies and Examples
  • The Brand Identity Design Process
  • Introduction to Brand Identity
  • Better SEO Through Tools
  • Better SEO Through Code
  • Better SEO Through Content
  • Introduction to SEO
  • The Logo Sprint
  • Logo Design 101
  • Workflow Basics
  • Slices & Save for Web
  • Vector Shapes
  • Masks Basics
  • Type Tools
  • Layer Basics
  • Workspace Basics
  • Custom Media Players
  • Captioning Video
  • Media Basics
  • Design Foundations Final
  • Becoming a Problem Solver
  • Understanding Aesthetics
  • Introduction to Design
  • Color Theory
  • Principles
  • Elements
  • Grid Layout
  • Flexbox Layout
  • Positioning Schemes
  • Float Layout
  • Display Modes
  • Media Queries
  • CSS Animations
  • Transitions and Transforms
  • Gradients
  • Flexbox and Multi-Column Layout
  • Web Typography
  • Backgrounds and Borders
  • CSS Box Model
  • Text, Fonts, and Lists
  • Values and Units
  • Advanced Selectors
  • Selectors
  • Getting Started with CSS
  • Structuring Tables
  • Table Basics
  • Choosing Options
  • Organizing Forms
  • Form 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
  • CSS: Cascading Style Sheets
  • Creating HTML Content
  • HTML First
  • Beginning HTML and CSS
  • Newbie