davethemaker

Tag: sql

  • Visualizing SQL data

    I worked with data analysis using Panda, matplotlib and more during my studies at UW, but subsequently focused on cloud infrastructure and securing resources. Building out my database and SQL skills, I’m coming full circle to using visualization to better understand data- this is helpful in all sorts of ways! Here are some links to…

  • Postgres: ER diagram > DB tables

    In this posting, I’m going to detail the steps that I took to successfully complete an exercise, where a ficticious company has given requirements for its operations, reflected by an ER diagram. My mission is to translate that into a technical solution, creating a Postgres database, complete with tables, to meet those requirements. Let’s get…

  • 3 Ways to Create MySQL Database Table

    In the past year, I’ve been building skills in working with a computer instance- configuration, placing it within a network, working with Linux and the command line, but it’s only now that I’m building a really important piece for application architecture- building a database. In this post, I’m going to create a database table for…