Skip to content

Instantly share code, notes, and snippets.

View rogerwschmidt's full-sized avatar

Roger Schmidt rogerwschmidt

View GitHub Profile

Installing postgres, DDL, and ERD Instructor Notes

Objectives

  • Install postgres
  • Explain what a Relational Database Management System is and why it is useful
  • List, Create and drop databases
  • Create database tables
  • Explain what Entity Replationship Diagram is, and why it is useful
  • Create an ERD
DROP TABLE IF EXISTS employments_resumes;
DROP TABLE IF EXISTS employments;
DROP TABLE IF EXISTS resumes;
DROP TABLE IF EXISTS users;
-- create users table
CREATE TABLE users (
id serial PRIMARY KEY,
first_name varchar(50),

Ajax and promises instructor notes

Objectives

  • Trace the request/response cycle
  • Explain how asynchronous behavior occurs in the request/response cycle
  • Write ajax requests
  • Explain the two promise methods, and how to use them

What is the path of the request/response cycle

Serve Data To Clients Part 2 Instructor Notes

Objectives

  • Create custom middleware
  • Define what middleware is
  • Create a substack middleware
  • Use error handling in express
  • Add the body-parser middleware
  • POST data to a server

Serve Data to Clients Instructor Notes

Objectives

  • Describe what an API is
  • Explain why APIs' are useful
  • List and explain HTTP methods
  • Build a CRUD API in Express

What is an API?

File system and asynchronous behavior

Objectives

  • Explain what asynchronous behavior is and why it is important.
  • Use the file system library asynchronously

What is asynchronous behavior is and why is it important?

print 1
print 2

this and OOP Instructor Notes

Objectives

  • Create a model that includes properties, and actions that on the properties (get/set)
  • Create a simple class with only a constructor
  • Explain what a class is and why they are useful
  • Add methods to a class
  • Explain why getters and setters are useful, and add getters and setters to a class
  • Explain what a static method is, and add a static method to a class

Code collaboration Instructor Notes

Objectives

  • Explain what github Organizations are, and why they are useful
  • Create a github organization, and add a repo
  • Collaborate using a Github Organization
  • Use upstreams to keep your repo up to date with the organization repo

What are Github Organizations are and why they are useful?

Recursion Instructor Notes

Objectives

  • Describe what recursion is
  • Enumarate the two parts of a recursive function
  • Convert from iteration to recursive

What is recursion?

  • With your table, create a definition of what recursion is.