Git + SQL
SE Fundamentals
Agile
OOP/Testing
Coding Principles
100

A field in a database table that uniquely identifies each row/record in that table.

What is a Primary Key?

100

The process of planning, creating, testing, and deploying an information system, often abbreviated to four letters.

What is the SDLC (Software Development Life Cycle)?

100

A short, time-boxed period (usually 1-4 weeks) during which a Scrum team works to complete a set amount of work.

What is a Sprint?

100

An error, flaw, or fault in a program that causes it to produce an incorrect or unexpected result.

What is a software defect (or bug)?

100

The principle, abbreviated as KISS, that advises against unnecessary complexity in design.

What is "Keep It Simple, Stupid"?

200

The Git command used to record changes from the staging area to the local repository.

What is git commit?

200

This stage in the Software Development Life Cycle involves translating the project requirements into a blueprint for the system.

What is the design stage?

200

Leader who helps the team follow the Scrum framework, removes hindrances and impediments, and facilitates events.

What is a Scrum Master?

200

This type of testing focuses on individual components or functions of the software in isolation.

What is Unit Testing?

200

An acronym for the four basic functions of persistent storage: makes up the word CRUD

What is Create, Read, Update, and Delete?

300

In Git, this command is used to upload your committed local changes to a remote repository like GitHub.

What is git push?

300

The concept of breaking down a large software system into smaller, independent, and interchangeable components.

What is modularity?

300

This Agile role is responsible for managing the product backlog and maximizing the value of the product.

What is a Product Owner?

300

Used to structure a software program into simple, reusable pieces of code blueprints, which are used to create individual instances of objects.

What is Object-oriented Programming?

300

Coding principle where one divides a program into sections, having each section address its own concern or responsibility.

What is separation of concerns?

400

The fundamental SQL command used to retrieve or "read" data from one or more database tables.

What is SELECT?

400

A requirement that describes how a system performs a function, such as its speed, security, or usability.

What is a non-functional requirement?

400

An agile software development framework that aims to produce higher quality software and higher quality of life for the development team.

What is XP (Extreme Programming)?

400

“Are we building the product right?” - checks if software meets design standards

What is verification?
400

The implied cost of rework caused by choosing an easy, short-term solution now instead of using a better approach that would take longer.

What is technical debt?

500

This command fetches changes from a remote repository and merges them into the current local branch in one step.

What is git pull?

500

Architecture pattern that structures an application as a collection of small services that are independent of each other. Communicates with each other, usually over a network. 

What is microservices?

500

The Agile Manifesto values this over contract negotiation.

What is customer collaboration?

500

Performed by clients to see if the system is satisfactory to their acceptance criteria, and if it’s ready to be deployed.

What is acceptance testing?

500

The process of changing the structure of the existing computer code without changing its external behavior.

What is refactoring?

M
e
n
u