icorson3

# requires pry, parser, and ast gems
#
# Running:
#
#  # running on an individual file (or pass multiple file names in)
#  ruby-rewrite --load 'insert_ruby_params_keyword.rb' -m spec/controllers/api/songs_controller.rb
#
#  # running on all the file individually. note: if a pry gets triggered you'll see it, but it won't give you
#. # control of the terminal, you'll need to use the previous command on the filed that fails.

icorson3

Week One - Module 3 Recap

Fork this respository. Answer the questions to the best of your ability. Try to answer them with limited amount of external research. These questions cover the majority of what we've learned this week (which is a TON!).

Note: When you're done, submit a PR.

1. What is json, what does it stand for, and why is it important?
2. What kind of object is JSON in Ruby? How do we know it's JSON?
3. What's the difference between joins and includes in ActiveRecord?
4. What's an API?

icorson3

Ilana: https://github.com/icorson3/advanced_enums

icorson3

Personal Branding - Week 1/Module 1

• Create/update Linkedin
• Create/update Resume (creddle.io is a good resource)
• Have two Turing peers review (2 for Linkedin, 2 for Resume) and send feedback via Slack by Thursday 12/1
• Update Linkedin and Resume based on feedback
• Include peer feedback in the body of the email and attach resume as a PDF
• Send Linkedin and Resume to Meg via email (mstewart@turing.io) by Friday 12/2 (midnight)

icorson3

<?xml version="1.0" encoding="utf-8" ?>
<!-- SQL XML created by WWW SQL Designer, https://github.com/ondras/wwwsqldesigner/ -->
<!-- Active URL: http://ondras.zarovi.cz/sql/demo/ -->
<sql>
<datatypes db="mysql">
	<group label="Numeric" color="rgb(238,238,170)">
		<type label="Integer" length="0" sql="INTEGER" quote=""/>
	 	<type label="TINYINT" length="0" sql="TINYINT" quote=""/>
	 	<type label="SMALLINT" length="0" sql="SMALLINT" quote=""/>
	 	<type label="MEDIUMINT" length="0" sql="MEDIUMINT" quote=""/>

icorson3

1. fix any axe violations on my turing arcade website.
2. add the alt text to any where that i can.
3. research color contrasts and how to avoid these violations.

icorson3

• I plan to attend startup week. Especially some of the diversity and mental health panels.
• I would like to write about turing and our role in the community and how I feel about the Denver community as it stands.

icorson3

List 5 companies you might want to apply for:

2 companies you think you'd like to work for 2 companies you don't really want to work for but that have a job posting somewhere you'd like to live 1 dream company (BaseCamp, Funny or Die, Github... somewhere it's hard to get hired but wouldn't that be cool, eh?) Don't say which is which though - just list 5.

For each company, answer the following questions:

CA Technologies

icorson3

From Colin Working with Ilana was great. She had a very head on approach, and also made sure to assert herself on difficult tasks. It's clear she feels comfortable with rails and ruby and is really showing her knowledge. I think she should continue on this path as much as she can to progress. I feel at times she maybe too eager to be the project manager, which can be a huge strength in some groups, or could potentially create friction in others. In no way did that create friction in ours, but maybe something to keep in mind. Overall I'd be very happy to work with Ilana again. By all means, she has proven she's becoming an excellent dev, and especially with the emphasis on TDD on other great practices.

From Robbie This was the first project at Turing I got to work with Ilana on. I think Ilana really grew during this project by taking on responsibility for features even if she knew she was not comfortable with the topics. One thing I saw happen a couple times was when Ilana got frustrated with working on some

icorson3

What's the total revenue for all items? select sum(revenue) from items; What's the average revenue for all items? select avg(revenue) from items; What's the minimum revenue for all items? select min(revenue) from items; What's the maximum revenue for all items? select max(revenue) from items; What the count for items with a name? select count(name) from items; What else can you pass to count and still get 5 as your result? select count(items) from items; Return all main courses. Hint: What ActiveRecord method would you use to get this? select items from items where(course = 'main'); Return only the names of the main courses. select name from items where(course = 'main'); Return the min and max value for the main courses. select max(revenue), min(revenue) from items where(course = 'main'); What's the total revenue for all main courses? select sum(revenue) from items where(course = 'main');