Contributors

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.

Matthew Layne's Picture

Social

Author of 17 chapters

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

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.

Export to CSV with \copy

From Learn SQL

This article discusses how to export data from psql to a csv file using the copy commands

PostgreSQL Generate_Series

From Learn SQL

This article outlines how to use PostgreSQL's Generate_Series() function

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 Replace Nulls with 0s in SQL

From Learn SQL

This article talks about how to use the UPDATE statement to clean data.

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.

Meta commands in PSQL

From Learn SQL

This article talks about what meta commands are and provides a list of some common examples.

Outputting Query Results to Files with \o

From Learn SQL

This article discusses how to use the o meta command to output to a text file

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.

Views

From SQL Optimization

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

AND OR Boolean Logic

From Learn SQL

This post goes into detail on how Boolean logic works and how Boolean logic can be molded with truth tables

Reviewer of 17 chapters

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.

Using Jupyter Notebooks

From

This article walks through the basics of using a Jupyter notebook. It covers how to load data, create a notebook, and begin using that notebook.

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 Avoid 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 Avoid Misrepresenting Data

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

Relative vs Absolute Change

From Avoid Misrepresenting Data

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

Review Outcomes

From Avoid 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 Avoid 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 Avoid 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 Avoid Misrepresenting Data

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

Trends

From Avoid 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.

Indexing

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.

Running Jupyter Notebook on an EC2 Server

From

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