Williams-Christopher

-- HOW MANY PEOPLE WORK IN THE SALES DEPARTMENT
-- 4
select
	count(e.emp_name)
from employee e
join department d on e.department = d.id
where d.dept_name = 'Sales';
 

-- LIST THE NAMES of EMPLOYEES ASSIGNED TO THE 'PLAN CHRISTMAS PARTY' PROJECT

Williams-Christopher

I don't know that there are ten or more user stories for this app as it won't have user sign-ups or administrators but here we go:

Edit: Now featuring priorities!

1) High - As a user I want to find out what space launches are coming up in the near future.
2) High - As a user I want to see where those launches are happening.
3) High - As a user it might be interesting to see a weather forecast for the launch window.
4) Medium - As a user I want to find out more about the vehicle being launched.
5) Medium - As a user i want to find out more about the space agency/agencies responsible.
6) Medium - As a user I want to find out more about the mission - Why is this launch happening? 

Williams-Christopher

Using three APIs this app will show users upcoming space launches, mark the launch sites on a map, and, if available, provide a weather forecast forecast for the launch window.

APIs to be used:
Launch data: LaunchLibrary -> https://launchlibrary.net/docs/1.3/api.html
Map data: Google Maps -> https://developers.google.com/maps/documentation/javascript/tutorial
Weather data: OpenWeatherMap -> https://openweathermap.org/api

Williams-Christopher

https://apachechef.github.io/portfolio-site/
- or -
https://christopherwilliams.dev/dev/

Williams-Christopher

 https://www.dropbox.com/s/4nsugkie0f3h0mp/CWilliams_PortfolioSketch.pdf

Williams-Christopher

Headline:
Christopher Williams - Fullstack Developer


Mini-biography:
With 18 years in IT helping end-users, managing and deploying servers and network equipment, vendor relations, ERP systems, SQL and management, I'm making the switch to full-stack development. I've had a strong interest in software development since I was a kid and find myself now in a position to do something I want to do and to make it my career. I strive to produce clean, readable code, and faithful implementations of design specs. I enjoy solving problems and practicing constant refinement to make my solutions the best they can be. Aside from development, I love learning, playing my guitar, learning to play the drums, reading on varied topics from cosmology to personal improvement, dabbling with game development, and spending time with my wife and kids.

Projects:
Quiz App

Williams-Christopher

Here's my submission to cap the Interactive Web Applications module.

GitHub Pages: https://apachechef.github.io/Thinkful-Quiz-App/
GitHub Repo: https://github.com/ApacheChef/Thinkful-Quiz-App

Christopher

Williams-Christopher

function getTokens(rawString)
This function accepts a string and returns an array containing all the truthy words in it.
First it takes in a string, forces it to lower case characters, splits the string into an array using a regular expression, creates a new array of truthy items by filtering 'falsy' items from the split array, and finally sorts the resulting array in alpha descending order. Then the array is returned to the calling function.

function mostFrequentWord(text)
This function takes in a string and returns the first word most frequently found in it.
The function first takes the string passed to it and passes it to getTokens(rawString), receiving back an array of strings to process. It then creates an empty object, wordFrequencies, which it checks for the existence of strings from the token array, using bracket notation to add to the wordFrequencies object those words that don't exist (with a count of one) and incrementing by one those words that it finds.

The last portion of the function finds th

Williams-Christopher

What is scope? Your explanation should include the idea of global vs. block scope.
Why are global variables avoided?
Explain JavaScript's strict mode
What are side effects, and what is a pure function?

Scope is an important concept in programming and it refers to where a variable is valid in code and which bits of code can modify its value. With JavaScript, a variable can be valid in the global or block scopes. A variable with global scope is one that is defined outside of a function. Because of this, its value is accessible (and therefore mutable) from anywhere within the JavaScript file where it is defined as well as any other JavaScript files loaded after it. Conversely, a variable declared inside of a function is said to have a block scope and it is only accessible to the code block of that function. It is wise to avoid global variables because they can quickly lead to hard to squash bugs, unintended side effects, and do not support the idea of pure functions.

Side effects are changes to an application 

Williams-Christopher

https://repl.it/@Christopher_W/Creating-arrays-drill

https://repl.it/@Christopher_W/Adding-array-items-drills
Why does this not work?
function addToList(list, item) {
  return list.push(item);
}

https://repl.it/@Christopher_W/Accessing-array-items-drill