mindmap
root((Entry-Level
Data Engineer))
(SQL Mastery)
Basic to Advanced Queries
Data Modeling
Performance Tuning
Competency | Skills | Description |
---|---|---|
Technical Expertise | Coding, debugging, code quality, technical trade-offs | Demonstrates high-level proficiency in programming languages and frameworks, regularly writes and reviews code, makes decisions on technical trade-offs, and understands system security and performance implications. |
Problem Solving | Debugging, critical thinking, technical decision-making | Regularly identifies, analyzes, and resolves complex technical issues, prioritizes technical debt management, and makes pragmatic decisions on when to focus on essential features versus additional refinements. |
Criteria | 4 Points | 3 Points | 2 Points | 1 Point |
---|---|---|---|---|
Creativity | The project demonstrates exceptional creativity and originality in its concept and execution. It showcases unique ideas and innovative approaches to manipulating and presenting data in the terminal. | The project exhibits a good level of creativity, with some original ideas and approaches to data manipulation and presentation in the terminal. | The project shows some creative elements but lacks originality in its concept and execution. The data manipulation and presentation in the terminal are somewhat conventional. | The project lacks creativity and originality. It relies heavily on basic concepts and lacks innovative approaches to data manipulation and presentation in the terminal. |
Technical Efficiency | The code is highly efficient, well-organized, and optimized. It effectively utilizes JavaScript concepts such as data types, data structures, functions, loops, boolean logic, an |
- Given the user is on the "New Robot" page
- When the user fills in the robot details including:
Name Weight Date Constructed Color Body Type Abilities Robot1 500 2024-03-21 Red Slicer Laser Cutter (10), Heat Ray (8), Shield Generator (5) - And the user submits the form
- Then the robot should be successfully added to the system
Here is a technical requirements document that a Product Owner could create after gathering requirements from the owner of a pizza parlor:
Pizza Palace is a popular pizza shop that currently takes all orders manually. The owner wants to implement an online ordering system to make ordering more efficient.
Here is an expanded menu display section with more details on potential pizza, salad, and pasta ingredients:
Menu Display
This application allows users to join book clubs, review books, and track book club meetings. The ERD can show relationships like which user has read which book, reviews written by users for different books, and the schedule of book club meetings for various books.
Description: Allow new users to register to the book club application.
- Given a visitor wants to join the book club,
When they fill out and submit the registration form with their username and email,
Then their account should be created and saved to the Users table.
- What are the ramification of having an invalid value for a foreign key?
- If you replaced the word "click" with the word "change" in your event listeners, what would happen?
- Can you clearly articulate how an event listener works in the browser? If so, write it down and explain during your vocab review. If you can't use Google or GenAI to deepen your understanding.
- Why do you need the
if
statement in each of your event listeners? - Why is it important to have a foreign key on the Order objects instead of storing the word "Coffee" or "Cookie"?
- Can you explain what the value of
event.target
is? - What is the purpose of the
return database.orders => (order => ({...order})
, instead of just doingreturn database.orders
? - Can you explain what caused the
cannot read properties of undefined yada yada
when you first ran the project?
Description: Users should be able to view a list of all available pets.
Given a user accesses the web application
When they navigate to the 'Available Pets' section
Then they should see a list of pets currently available for adoption, including details like name, age, and type.
#!/bin/bash | |
current_shell=$(echo $SHELL) | |
if [ $current_shell == "/bin/bash" ]; then | |
echo -e "\n\n\n" | |
echo "@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@" | |
echo "@@ @@" | |
echo "@@ Change Needed: Switch to zsh @@" | |
echo "@@ This change might require your computer password. @@" | |
echo "@@ @@" |