elyhess

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.

elyhess

Game Statistics

• highest_total_score
• lowest_total_score
• percentage_home_wins
• percentage_visitor_wins
• percentage_ties
• count_of_games_by_season
• average_goals_per_game Average number of goals scored in a game across all seasons including both home and away goals (rounded to the nearest 100th) Float
• average_goals_by_season Average number of goals scored in a game organized in a hash with season names (e.g. 20122013) as keys and a float representing the average number of goals in a game for that season as values (rounded to the nearest 100th) Hash

elyhess

Project Feedback

Directions

1. For every partner you have, make a copy of this gist
2. Fill out the copied gists with feedback for each group project partner (one gist per partner)
3. Send us your feedback for each partner using the form posted in slack/assignment tracker (one submission per partner)
4. Individually slack your partners the link of the gist you filled out for them
5. Spend some time reviewing your partner’s feedback that they sent you
6. Get on a video call with your partner(s) for the in person partner retro to discuss feedback.

elyhess

Mod 0

1. When you've worked towards a goal in the past, what systems or tools have been helpful for you in accomplishing that goal? How could you adapt those same systems/tools to use while at Turing?

I have found that I am most successful in achieving my goals when I have systems in place for staying organized, receiving feedback, and taking care of myself.

I always keep a written planner, as I feel that writing things down helps me remember deadlines more effectively. During my previous role as a production director I found that it was absolutely necessary to familiarize myself with an event several weeks before the day of show to ensure that every logistical detail was accounted for and ready-to-go the day of. At Turing, I feel that this will be especially important. I plan to familiarize myself with the content of the course well ahead of time, and use my planner to ensure that I am always up-to-speed and on track.

I have found that receiving feedback regularly on my music projects has been a real

elyhess

Read two of the following articles/videos (we recommend all of them!) and reflect on these questions: why are we talking about empathy at a software development school? how can you develop the "skill" of empathy? and why should you care?

• "Why is Empathy Important for Design"
• "The Surprising (Nontechnical) Skill You Need to Succeed in Tech", The Muse
• "Why Aren't We More Compassionate?", TED Talk (Daniel Goleman)
• "Can you teach people to have empathy?", BBC (Jun 29, 2015)
• "Three Kinds of Empathy", Daniel Goleman
• ["The Importance of Empathy in Our Services-Centric, People-Oriented Economy"](http://blogs.wsj.com/cio/2015/10/09/the-importance-of

elyhess

Intermission Reflections

1. Please list the top 3-5 industries and companies you'll pursue in your job search as of right now.

• Product
• Startup
• Crypto
• Music

2. Why did you pick the industries/companies that you listed above? How do they relate to the values and goals you have for yourself in your job search?

• I'm super interested in industries that have potential to change peoples lives. I really want a job that I can devote my life to and feel good about the things I create/work on at the end of the day. Crypto is the industry that interests me the most, have been invested in what crypto stands for since the beginning and believe in its potential to become maintstream in the coming years.
• I'm also super interested in the music industry. Having previously come from a music production background, this is a field I could see myself engaging in with regard to web development.

elyhess