lizTheDeveloper

How to Think About Data Model and Schema in Postgres

Introduction

When working with databases like Postgres, understanding how to design your data model and schema is crucial. This lesson will guide you through the key considerations and questions to ask yourself.

Key Concepts

Tables

• What is it?: A table is a collection of related data held in a structured format.

lizTheDeveloper

What is a Kanban Board?

A Kanban board is a visual tool that helps you manage tasks, projects, and workflows. It consists of columns that represent different stages of a process and cards that represent tasks.

Why Use a Kanban Board?

• Visibility: See the status of all tasks at a glance.
• Efficiency: Move tasks through stages to focus on what's important.
• Collaboration: Team members can easily pick up tasks and know their responsibilities.

How to Create a Kanban Board

1. Identify Columns: Common columns are 'To Do', 'In Progress', and 'Done'.

lizTheDeveloper

title

cool body paragraph

• lists
• are
• cool
• too

lizTheDeveloper

adsfwdfadsfsdf

lizTheDeveloper

1. why does the sun shine
you answer here
3. why is the sky blue
youre answer ehre

lizTheDeveloper

Leverage agile frameworks to provide a robust synopsis for high level overviews 🎉. Iterative approaches to corporate strategy foster collaborative thinking to further the overall value proposition. Organically grow the holistic world view of disruptive innovation via workplace diversity and empowerment.

This Sprint:

• Header alignment 🦋
• New account signup broken? 🚨
• Verify emails bouncing 🚨
• Chatbot won't respond 🐛
• Links don't always display hover text 🐞
• Some links are missing in some user contexts 🐛

lizTheDeveloper

Deploying Files

Today's exercise will teach you how to actually deploy your work to a hosting provider, so that you can show it to the world!

There are two providers we'll use, you can pick.

• Surge
• Paperplane

If you're comfortable with the command line, pick Surge. Otherwise, you can host files with Dropbox and Paperplane.

lizTheDeveloper

Timers and Events

This set of exercises has you create programs that are actually interactive! You'll take in user input in the form of button clicks and mouse clicks, and you'll use forms and timers.

In jQuery, you can add a click event handler like so:

$("something").click(function(event) {})

In "vanilla" JavaScript, you can do it like this:

lizTheDeveloper

Ro Sham Bo Game Project

This is one of the choices for the final projects for this course.

How to Get Started

For this project, we are going to create a browser-based, single-player version of Rock Paper Scissors.

• The "computer" should pick a random move each turn.
• Keep a score counter somewhere on the page.

lizTheDeveloper

Map Project

This is one of the choices for the final projects for this course.

This project is a pattern you've seen before in many websites- anywhere that deals with physical locations. We're also using a vendor library to show the map.

How to Get Started

First, pick something you'd like to create a map for. Maybe it's places you have visited, maybe your favorite reading spots, maybe your favorite pubs. In any case, you need an item that has location data associated with it. If your item doesn't really have location data, or you probably won't want to view all the items on a map at once, you might want to look at the Collection Detail View Project.