SQL 101
What does SQL stand for
Structured Query Language
The return when there is no data there
Null
Hitting the CAPS button on your keyboard will not ruin your query because SQL is NOT
What is case sensitive
Window in which features will be set
What is a timeline
Common type of responsibility assignment matrix that defines involvement of stakeholders, personal and units in a project
What is a RACI
Use this to narrow your data
What is AND
This is a text data of a fixed length in which all records have to be the specified length
What is a CHAR
The two categories of "Order By"
DESC (Desending) and ASC (Ascending)
Capabilities that the product will provide, paired to product releses
What is features
Total projected net benefits divided by the cost of inverstmet
What is Return on investment (ROI)
Use this to make your search more broad
What is OR
This is numerical data with decimals
What is a float
The command for greater than or equal to
>=
DOUBLE JEOPARDY
To communicate effectively, Strong Persistency, Ability to understand new business processes, Ability to be comfortable with the unknown
Flow Objects, Data, Connecting Objects, Swimlanes and Artifacts are elements of
What is a Business Process Diagram
* or %
This is numerical data without decimals
What is an integer
End a SQL requirement with this
;
Formally authorizes the existence of a project; establishes scope, context / rational, and creates record of its initiation.
What is a charter
A intelligent and well organized person responsible for delivery of a project, often works extra hours and maybe even lacks joy in their coffee. Usually teams up with a BA.
What is a PM
When grouping you will need to use this instead of WHERE
What is HAVING
This text data is when length in text column can be any length up to the maximum length
What is VARCHAR
When using SUM(QTY) you can not forget this or an error will occur
What is Group By
The process of verifying that different software modules, external APIs, databases and 3rd party systems exchange data as expected when combined
What is integration testing
Use HTTP methods explicitly. Be stateless. Expose directory structure-like URIs. Transfer XML, JavaScript Object Notation or Both
What is a RESTful Service