Matthew Layne

Marketing Intern at Chartio,
Contributor at Data School

Matthew is a student at Virginia Tech who is majoring in Computer Science. He is excited to use his technical skills in order to help further knowledge in the field of data analytics and Computer Science.


Author of 11 chapters

Copying Data Between Tables

From Learn SQL

Learn to copy data from a table or query into another table using the INSERT command in psql.

How to Create a Copy of a Database in PostgreSQL

From Learn SQL

Learn how to create a copy of a database in postgres using psql.

How to Start a PostgreSQL Server on Mac OS X

From Learn SQL

This article shows how to start a PostgreSQL server using both Homebrew and the potgres app on a Mac.

Importing Data from CSV in PostgreSQL

From Learn SQL

This article outlines how to use psql to import data from csv files.

Using ALTER in PostgreSQL

From Learn SQL

Learn the different potential uses of the ALTER command in PSQL. Add and drop columns from tables. Rename and change schemas and more.

Multicolumn Indexes

From SQL Optimization

This article walks through what multicolumn indexes are, how to make them, and when to use them.

Optimization with EXPLAIN ANALYZE

From SQL Optimization

The EXPLAIN shows the query plan for SQL queries in Postgres. Learn how to interpret the results from EXPLAIN and use it to optimize your SQL queries.

Partial Indexes

From SQL Optimization

Partial indexes are an advanced database optimization technique. Learn how to create Partial Indexes and measure their performance.

Snowflake Optimization

From SQL Optimization

Snowflake is a powerful cloud database. Learn how it optimizes your database automatically, and hot to increase performance manually.


From SQL Optimization

SQL VIEWs allow you to create temporary or permanent references to data. This is a common database optimization technique. Learn more.

What is a Query Plan

From SQL Optimization

Query Plan's are the code that SQL runs on your database. Learn how the query plan works and how to optimize your SQL queries. Learn more

Reviewer of 16 chapters

Running Jupyter Notebook on an EC2 Server


Learn how to run a Jupyter Notebook on an AWS EC2 Server and the advantages of this.

How Regex in SQL Works

From How to Teach People SQL

Learn how Regex works in SQL and how to use it in your queries. See the Regex process visualized in gifs. Learn more.

How CASE WHEN works

From How to Teach People SQL

CASE WHEN is a SQL function that works a lot like IF THEN in other programming languages. Learn to use CASE WHEN in SQL.

How Window Functions work

From How to Teach People SQL

Learn how window functions work by looking at gifs that show the process in slow motion. See every step in SQL animated in slow motion. Learn more.

Confirmation Bias

From Misrepresenting Data

Confirmation bias negatively affects the accuracy of your analysis. Learn how to detect Confirmation Bias and how to avoid this cognitive bias.

Define Experiment Parameters

From Misrepresenting Data

Defining Experiment Parameters improves analysis and increases trust in results that are shared in an organization.

Relative vs Absolute Change

From Misrepresenting Data

Relative and Absolute changes can bias your interpretation of data you are analyzing. Learn to interpret them correctly.

Review Outcomes

From Misrepresenting Data

Review Outcomes of Feature Releases to evaluate their impact and to create institutional knowledge. Learn how to interpret results accurately.

Selection Bias

From Misrepresenting Data

Selection bias negatively affects your analysis. Learn how to detect Selection Bias and how to avoid this cognitive bias.

Statistic vs Distribution

From Misrepresenting Data

Distributions provide much more nuance to the data than a statistic does. Learn how to query to get distributions and then interpret them.

Survivorship Bias

From Misrepresenting Data

Survivorship bias negatively affects your analysis. Learn how to detect Survivorship Bias and how to avoid this cognitive bias.


From Misrepresenting Data

Trend in data can be misleading depending on what time frame you are looking at it. Learn how to accurately interpret trends.

BigQuery Optimization

From SQL Optimization

Learn how BigQuery optimizes your database through specific hardware optimization strategies.


From SQL Optimization

Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. See how indexes work and learn to build indexes with SQL.

Redshift Optimization

From SQL Optimization

Learn how Redshift manages optimization for your cloud data warehouse. Learn when to manually tune the database further for more performance for SQL queries.

Scheduling Modeling

From SQL Optimization

Schedule data modeling tasks to make data easy to query. Learn to use dbt Cloud to model data to optimize your data warehouse. Learn more.