💻
SEIFXR10ANZ - Content
  • SEiFXR10ANZ
  • Python Cheatsheet
    • Basics
    • Control Flow
    • Lists
    • Dictionaries
    • Functions
    • Modules
    • Other Things
  • Week 1
    • Day 1: Intros, Installs, & Command Line
      • Installation (MacOS)
      • Installation (Windows WSL2)
      • CLI
        • Lab
          • Hungry For More?
      • Homework
    • Day 2: Git and HTML
      • Introduction to Git
        • Lab
      • Introduction to HTML
        • Lab
  • Day 3: CSS and JS
    • Introduction to CSS (Cascading Style Sheets)
      • Lab
    • Introduction to JS (JavaScript)
      • Lab - Movie Release Date
      • Lab - JS Conditionals
      • Lab - HFM Conditionals
    • Homework
  • Week 2
    • Day 1: Creating Elements & Arrays
      • Creating Elements
        • Lab
      • Arrays
        • Lab
      • Homework
    • Day 2: Functions and Event handlers
      • Functions
        • 💻Lab
      • Homework
  • Day 3: Loops and Event Handling
    • Loops
      • 💻Lab
    • Event Handlers
      • 💻Lab
    • Homework
  • week 3
    • Day 1: JS Objects
      • Lab
      • Homework
  • Day 2: Functions and Event Handlers review
    • Functions review
      • 💻Lab
    • Event handlers review
      • 💻Lab
  • Day 3: More HTML & CSS
    • Semantic Sectioning HTML Tags
    • Lab: Recipe
    • Block & Inline Elements
    • Box Model
    • Lab: Brook & Lyn
    • Lab: Wendy Bite
    • Homework
  • Week 4
    • Day 1: Introduction to Flexbox
      • Guide to Flexbox
      • 💻Lab: Flexbox Froggy
      • 💻Lab: Flexible Flexboxes
      • Homework
  • Day 2: CSS Selectors and Grid layouts
    • CSS Selectors
    • CSS Combinators
    • CSS Grid guide
    • 💻Lab: Grid garden
    • 💻Lab: Sartres List
  • WEEK 5
    • Day 1: JS Revision & DOM Intro
      • Lab: JS Revision
      • Document Object Model (DOM)
      • DOM Traversal
        • Lab: DOM Traversal
    • Day 2: DOM recap and Introduction to Form elements
      • DOM methods
      • 💻Lab: Pet Adoption Agency
      • Forms in HTML
      • 💻Lab: Tennis Signup
    • Day 3: Form events, CSS transitions and modes of passing variables
      • Form events
      • 💻Lab 1: Bad Password Generator
      • Modes of passing variables
      • CSS transitions
      • HTML data attributes
      • 💻Lab 2: Dino discovery
  • Week 6
    • Day 1: DOM Manipulation Revision and Markdown
      • DOM Manipulation Revision/Cheat Sheet
        • Lab: Duck Hunt
      • Markdown
        • Lab: Markdown
      • Homework 1: Dots Game
      • Homework 2: github.com
  • Day 2: Project 1 kickoff
    • Project #1: The Game
  • Week 7
    • Day 1: Intro to Python
      • Python
      • Installation
      • Lab 1: 99 Bottles
      • Lab 2: Eliza
      • Bonus Exercise
    • Day 2: More Python
      • Lab 1: Python Lists
      • Lab 2: Python Dicts
      • Bonus Exercise
      • Homework: Counting File Types
    • Day 3: Functions, HTTP, Flask
      • Lab 1: Supermarket
      • HTTP
      • Intro to Flask Part 1
      • Lab 2: Frasier
      • Intro to Flask Part 2
      • Lab 3: 99 Bottles
      • Homework: Emergency Kitten
  • WEEK 8
    • Day 1: HTML forms using a web server
      • Review client-server architecture
      • HTML forms in flask
      • HTML templates
      • 💻Lab 1: Airline Baggage Checker
      • Homework
  • Day 2: Template inheritance and APIs
    • Template inheritance
    • APIs, what are they?
    • 💻Lab: Dog breeds
  • Day 3: Cookies and Flask revision
    • HTTP Cookies
    • 💻Lab: Open Movie Database - Part 1
    • Loops with Jinja
    • 💻Homework: Open Movie Database - Part 2
  • Week 9
    • Day 1: SQL
      • PostgreSQL Installation
      • Intro to SQL & PostgreSQL
      • Lab: Library DB
      • BONUS Lab: Employees DB
      • Homework
    • Day 2: SQL aggregation and working with Python
      • Aggregation and ordering operators
      • Code along: Using Python with a SQL database
  • Day 3: CRUD Operations using Flask and DB
    • 💻Lab 1: Food Truck - Stage 1
    • 💻Food Truck - Stage 2
  • Week 10
    • Day 1: Python Checkpoint & MVC
      • Python Checkpoint
      • Model View Controller
      • Lab: Food Truck - Stage 3
  • Day 2: User sessions in Flask
    • Introduction to sessions
    • 💻Lab: Food Truck - Stage 4
    • Homework
  • Day 3: Secure Password Storage & OOP
    • 💻Food Truck MVC
    • Storing Passwords Securely
    • 💻Lab: Food Truck - Stage 5
    • OOP & Classes
    • 💻Lab: OOP Monkeys
    • 💯BONUS Lab: Food Truck - Stage 6
    • Homework
  • Week 11
    • Day 1: SQL Relationships & JOINs
      • SQL Relationships
      • 💻Chirpy
      • SQL JOINs
      • 💻Lab - SQL Library
      • Lab: Food Truck Stage 7
      • Project 2: Full-Stack App
  • Week 12
    • Cloudinary & Flask
  • WEEK 13
    • Day 1: Unit 3 Intro & JS Recap
      • Node.js & Express
      • MPA/SPA
      • Lab: City Pix
      • Lab: JS Errors
    • Day 2: Callbacks & Asynchronous code
      • Callbacks and Asynchronous code
      • Lab: Horses
      • Lab: Pixel Art
      • Homework
    • Day 3: Destructuring, spread, rest, & AJAX
      • Destructuring Assignment
      • Lab: Destructuring Assignment
      • Spread & Rest
      • Lab: Spread & Rest
      • AJAX
      • Lab: AJAX Movies
      • Homework/Lab: AJAX & APIs
  • Week 14
    • Day 1: Promises & Intro to Express
      • Promises
      • Intro to Express
      • Lab: Emergency Compliment
      • Lab: Calculator
      • Homework
  • Day 2: Building RESTful APIs in Express
    • Lab: Poke Express
  • Day 3: Postgresql and serving static assets with Express
    • 💻Lab: Scavenger Hunt - Stage 1
  • WEEK 15
    • Day 1: Build out Create, Update and Delete capabilities
      • 💻Lab: Implement an API to create challenges
      • 💻Lab: Add delete and edit capabilities
      • Cache headers
    • Day 2: Middlewares and Nodejs modules
      • Express middleware guide
      • Homework: Setup for next class
  • WEEK 16
    • Day 1: Sign up and login (without sessions)
      • 💻Lab: Integrate sign up with API
      • 💻Lab: Build a login page and integrate it
    • Day 2
      • Env Vars
      • Express Sessions
      • Lab: Scavenger Hunt Stage 4b
      • JavaScript Modules
    • Project 3
  • Week 17
    • Day 1: Testing
      • Introduction to Testing
      • Code Along
      • Lab 1: Library TDD
    • Day 2: Git branching and workflows
      • 💻Lab: Git branches
      • Project 3: Full-stack SPA JavaScript Application
  • Week 19
    • Day 1: React, JSX, Components, Props
      • Intro to React
      • JSX
      • vite
      • Components
      • Lab: Static Dashboard
      • Props
      • Homework: Floor Plan
    • Day 2: Rendering lists, Conditional rendering
      • Codealong: Sharknado
      • Rendering Lists
      • Lab: Dog Breeds
      • Conditional Rendering
      • Lab: Fancy Florist
      • Homework: Weather Forecast
    • Day 3: Events, State, useState
      • Events
      • State & useState Hook
      • Lab: Theme Switcher
      • Lab: Collapsible
      • Unidirectional Data Flow & Lifting State Up
      • Lab: Gallery
      • Homework: Traffic Lights
  • Week 20
    • Day 1: Complex State, Immutable Updates, Forms
      • Complex Objects in State
      • Lab: Immutable Update Patterns
      • Forms
      • Homework: Feedback Form
    • Day 2: useEffect, API Integration
      • useEffect
      • Lab: Norris
      • Homework: YaTodo
    • Day 3: React Router, Netlify
      • React Router
      • A Website Part 1
      • A Website Part 2
      • Netlify
      • Homework: YaTodo
  • Week 21
    • Day 1: useContext
      • useContext
      • Lab: Tooter
    • Day 2: Styling React
      • Options for Styling React Apps
      • CSS Modules
      • Component Libraries
      • Lab: Tooter
    • Day 3: Testing React
      • Testing Stack
      • Lab: React Testing
      • Homework: Tooter
  • Week 22
    • Day 1: JS Classes
      • JavaScript Classes
      • Lab: Bank Account
    • Day 2: React Class Components
      • React Class Components
      • Lab: ReAmp Part 1
      • Lifecycle Methods
      • Lab: ReAmp Part 2
    • Day 3: Data Structures & Algorithms
      • Lab: Big-O
      • Lab: Recursion
      • Lab: Management Trees
  • Week 23
    • Project 4
    • Day 1: Accessibility
      • a11y Slides
      • Lab: React Accessible Tabs
Powered by GitBook
On this page

Was this helpful?

  1. Week 11

Day 1: SQL Relationships & JOINs

PreviousHomeworkNextSQL Relationships

Last updated 2 years ago

Was this helpful?

SQL Relationships
💻Chirpy
SQL JOINs
💻Lab - SQL Library
Lab: Food Truck Stage 7
Project 2: Full-Stack App