samlandfried

Intermediate SQL Workshop

• Run psql
• You may need to run CREATE DATABASE intermediate_sql;
• To exit this shell, you can run CTRL d

Create tables

Let's create some tables in the database.

samlandfried

Setting Group Expectations

Group Member Names: Danny Radden, Jonathan Kidd, Maria Stenquist, Sam Landfried

1. When are group members available to work together? What hours can each group member work individually? Are there any personal time commitments that need to be discussed?

Check Google Calendar project

Group: After class - 7 pm Maria: Birthday on Saturday. Wants to meet mornings.

samlandfried

Sessions, Cookies, and Flashes

1. If we didn't have cookies and sessions, what would happen?

• We wouldn't be able to persist anything that didn't exist in our database. We'd be at the mercy of the stateless model

1. What is a cookie?

• An insecure hash like object that persists data across sessions.

1. What's the difference between a cookie and a session?

• A session's data is serialized making it more difficult to manipulate its contents

1. What's serialization and how does it come into play with sessions?

• Serialization protects the contents of a session object. It requires a special key to deserialize it. The key is held by the Rails app.

samlandfried

Group Expectations

Group Member Names:

Project Manager:

Defining the Relationship (DTR) Questions:

1. When are group members available to work together? What hours can each group member work individually? Are there any personal time commitments that need to be discussed? B: Team collab daily ends at 6:30.

samlandfried

Turing School Prework

Task A- Practice Typing:

• screenshots of scores will be posted in comments

Task B- Algorithmic Thinking & Logic:

• screenshots of completed sections will be posted in comments

Task C- Create your Gist: