Lesson 004: Foreign Key Constraints

Introduction In the previous post I covered inserting data into a PostgreSQL table; and we used the Lesson_003 files in the learning-data-science GitHub repository to insert data into the dom_study table. In this post, Lesson 004, we’ll create 2 more tables, set up foreign key constraints, and insert data into the 2 tables. Since dataContinue reading “Lesson 004: Foreign Key Constraints”

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 002: Creating Tables in PostgreSQL

Introduction In the previous post I introduced PostgreSQL schemas, and we used the Lesson_001 files in the learning-data-science GitHub repository to create a schema for organizing domain tables. In this post, Lesson 002, we’ll create a sequence and a data table, and add column comments. Since data analysis and management are best learned by doing,Continue reading “Lesson 002: Creating Tables in PostgreSQL”

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”

Creating a PostgreSQL Database

Introduction In the previous post I introduced the learning-data-science GitHub repository, defined forking a repository, and provided instructions for forking the learning-data-science repository and cloning it to your computer. In this post, we’ll install pgAdmin and PostgreSQL, and create a database. Since data analysis and management are best learned by doing, the objective of thisContinue reading “Creating a PostgreSQL Database”

Learning Data Science

Introduction In the previous post I covered branches and basic merging in Git. In this post I’ll introduce readers to a GitHub repository that we’ll be using for this and future posts to facilitate learning, and then you’ll fork the repository and clone the forked repository to your computer. Since data analysis and management areContinue reading “Learning Data Science”

Version Control: Branches & Merging

Introduction In the previous post I covered reverting and viewing differences in Git. In this post, the last in a 5 part series on version control, I’ll be instructing readers in using branches and merging in Git. Since version control and data management are best learned by doing, the objective of this and future postsContinue reading “Version Control: Branches & Merging”

Version Control: File Management

Introduction In the previous post I presented a quick start guide for getting up and running with version control. In this post, the third in a 5 part series on version control, I’ll be instructing readers on managing files using Git and GitHub. Since version control and data management are best learned by doing, theContinue reading “Version Control: File Management”

Getting Started with Version Control

Introduction In the previous post I provided an overview of version control for managing computer files. In this post, the second in a 5 part series on version control, I’ll be instructing readers on how to get started with version control. Since version control and data management are best learned by doing, the objective ofContinue reading “Getting Started with Version Control”

Version Control: An Overview

Introduction In the last post I provided an overview of databases and data management systems. This post is the first in a 5 part series on version control. The objective of this post is to provide an overview of version control for managing code. This is in preparation for using version control in future postsContinue reading “Version Control: An Overview”