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.
Social
- LinkedIn: Matthew Layne
Author of 17 chapters
What is a Query Plan
From SQL OptimizationQuery 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 SQLLearn to copy data from a table or query into another table using the INSERT command in psql.
Export to CSV with \copy
From Learn SQLThis article discusses how to export data from psql to a csv file using the copy commands
PostgreSQL Generate_Series
From Learn SQLThis article outlines how to use PostgreSQL's Generate_Series() function
How to Create a Copy of a Database in PostgreSQL
From Learn SQLLearn how to create a copy of a database in postgres using psql.
How to Replace Nulls with 0s in SQL
From Learn SQLThis article talks about how to use the UPDATE statement to clean data.
How to Start a PostgreSQL Server on Mac OS X
From Learn SQLThis 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 SQLThis article outlines how to use psql to import data from csv files.
Meta commands in PSQL
From Learn SQLThis article talks about what meta commands are and provides a list of some common examples.
Outputting Query Results to Files with \o
From Learn SQLThis article discusses how to use the o meta command to output to a text file
Using ALTER in PostgreSQL
From Learn SQLLearn 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 OptimizationThis article walks through what multicolumn indexes are, how to make them, and when to use them.
Optimization with EXPLAIN ANALYZE
From SQL OptimizationThe 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 OptimizationPartial indexes are an advanced database optimization technique. Learn how to create Partial Indexes and measure their performance.
Snowflake Optimization
From SQL OptimizationSnowflake is a powerful cloud database. Learn how it optimizes your database automatically, and hot to increase performance manually.
Views
From SQL OptimizationSQL 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 SQLThis 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 OptimizationSchedule 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
FromThis 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 SQLLearn 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 SQLCASE 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 SQLLearn 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 DataConfirmation 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 DataDefining Experiment Parameters improves analysis and increases trust in results that are shared in an organization.
Relative vs Absolute Change
From Avoid Misrepresenting DataRelative and Absolute changes can bias your interpretation of data you are analyzing. Learn to interpret them correctly.
Review Outcomes
From Avoid Misrepresenting DataReview Outcomes of Feature Releases to evaluate their impact and to create institutional knowledge. Learn how to interpret results accurately.
Selection Bias
From Avoid Misrepresenting DataSelection bias negatively affects your analysis. Learn how to detect Selection Bias and how to avoid this cognitive bias.
Statistic vs Distribution
From Avoid Misrepresenting DataDistributions 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 DataSurvivorship bias negatively affects your analysis. Learn how to detect Survivorship Bias and how to avoid this cognitive bias.
Trends
From Avoid Misrepresenting DataTrend 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 OptimizationLearn how BigQuery optimizes your database through specific hardware optimization strategies.
Indexing
From SQL OptimizationIndexing 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 OptimizationLearn 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
FromLearn how to run a Jupyter Notebook on an AWS EC2 Server and the advantages of this.
