This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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? |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://apachechef.github.io/portfolio-site/ | |
- or - | |
https://christopherwilliams.dev/dev/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://www.dropbox.com/s/4nsugkie0f3h0mp/CWilliams_PortfolioSketch.pdf |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
NewerOlder