Welcome to Dr. Wells Publishing

Home to the Elfinwood Data Science Blog and other ramblings.

Latest from the Blog

Lesson 003: Inserting Data into a Table

Introduction In the previous post I introduced PostgreSQL sequences, tables, and columns; and we used the Lesson_002 files in the learning-data-science GitHub repository to create a table for storing metadata about scientific studies. In this post, Lesson 003, we’ll insert data into the dom_study table that we created in the previous post. Since data analysisContinue reading “Lesson 003: Inserting Data into a Table”

Lesson 001: Creating a Schema

Introduction In the previous post we installed pgAdmin and PostgreSQL, and created a database. In this post, Lesson 001 of Learning Data Science, we’ll discuss database schemas and create a new schema in my_first_database. Since data analysis and management are best learned by doing, the objective of this and future posts is to get readersContinue reading “Lesson 001: Creating a Schema”

Get new content delivered directly to your inbox.

Copyright © 2020, Aaron Wells