Skip to content

Instantly share code, notes, and snippets.

View stuttskl's full-sized avatar
🍓

stuttskl

🍓
9 followers · 5 following
  • Seattle, WA
View GitHub Profile
@stuttskl
stuttskl / 01-SQL-Joins.md
Created September 8, 2019 04:42 — forked from Shurlow/01-SQL-Joins.md
SQL Joins Lesson Notes

SQL Joins

Objectives

  • Explain what a Relational Databases is
  • Describe why Relational Databases are useful
  • Diagram 1-to-many & many-to-many relationships with ERDs
  • Create primary and foreign keys on tables
  • Join tables with SQL
  • Use aggregate & group by queries
@stuttskl
stuttskl / rest-express.md
Created September 8, 2019 04:50 — forked from Shurlow/rest-express.md
REST & Express lesson notes

REST & Express

Objectives

  • Describe the concept of resources in relation to REST and APIs
  • Identify RESTful conventions for API routes
  • Explain what express is and why it's useful
  • Build RESTful routes using express

REST

@stuttskl
stuttskl / osu-personal-site-hosting.md
Last active July 19, 2022 04:05

Where do I put my personal webpages?

When your ENGR account is created, a folder called 'public_html' is created as well. This folder is your 'webspace' and anything you put in there will be available to the internet-at-large via the address http://web.engr.oregonstate.edu/~your_engineering_username

What exactly is a public_html folder anyways?

The public_html folder is the web root for your primary domain name.

This means that public_html is the folder where you put all website files which you want to appear when someone types your main domain (the one you provided when you signed up for hosting).

Or put another way, when someone types your domain name into their browser, whatever is in the public_html folder is what will be shown to them.

@stuttskl
stuttskl / using-forever.md
Last active January 23, 2020 02:31

A few things before talking about forever ...

Before explaining the forever package, let's take a step back and learn about something called Node Package Manager, or npm for short. Npm is a command-line utility for interacting with a repository that aids in package installation, version management, and dependency management. There are tons of packages for Node.js, some we will use in this class are: express, express-handlebars, body-parser, mysql and of course, forever. Don't worry too much about these right now. They will be explained in due time.

Once you have a package you want to install, it can be installed with a single command-line command. Thankfully, npm is very simple to use: you only have to run npm install PACKAGE_NAME_HERE, and the specified module will be installed in the current directory under ./node_modules/. Once installed to your node_modules folder, you'll be able to use require() on them just like they were built-ins (we will explore this further in la

@stuttskl
stuttskl / issueTemplate.md
Last active April 30, 2020 02:57

Expected Behavior

Describe the intended behavior

Actual Behavior

Describe the actual behavior you are seeing

Screenshots

@stuttskl
stuttskl / pullRequestTemplate.md
Last active May 4, 2020 17:23

Description

Please include a summary of the change and which issue is fixed. Please also include relevant motivation and context. List any dependencies that are required for this change.

Fixes # (issue)

Type of change