History of sequel
It was the FULL original name for the SQL language, developed at IBM in the 1970s.
What is Structured English Query Language?
It is the SQL keyword used to retrieve data from a database.
What is SELECT?
It is the operator used to compare two values for equality.
What is "="?
It is the SQL clause used to filter rows that meet a specified condition.
What is WHERE?
Often described as a black box that takes an input, performs a calculation, and returns a value.
What is a function?
SQL was originally developed at which major technology company in the 1970s?
What is IBM?
It is the SQL feature that allows you to rename columns or tables in a query result without altering the actual database schema.
What is an alias?
It is the operator used to combine two conditions so that both must be true.
What is AND?
t is the default sort order when ORDER BY is used without specifying ASC or DESC.
What is ascending order (ASC)?
It is the function used to extract a specific portion of a string.
What is SUBSTRING()? (or SUBSTR())
It is the version of SQL that Oracle published commercially.
What is Oracle Database Version 2?
It is the keyword that ensures only unique values are returned in the results.
What is DISTINCT?
It is the operator used to check if a column contains a NULL value.
What is IS NULL?
It is the operator used to check if a column’s value matches a specific pattern with wildcards like % and _.
What is LIKE?
It is the function used to return the current system date and time.
What is NOW()? (or CURRENT_TIMESTAMP)
Edgar Codd created the research for relational models. But they are the ones who created SQL at IBM.
Who are Donald Chamberlin and Raymond Boyce?
These are mandatory clauses in a SELECT statement.
What is a "SELECT and FROM statement"?
It is the operator used to test if a column’s value is within a specific range.
What is BETWEEN?
It is the clause used to filter the results of aggregate functions such as COUNT or SUM.
What is HAVING?
It is the function that allows conditional logic in SQL, returning different values based on whether a condition is true or false.
What is CASE?
SQL became an official ANSI standard in this year, marking its recognition as the industry’s database language.
What is 1986?
This type of naming convention is not recommended by the SQL Style Guide
What is CamelCase?
It is the order of precedence for arithmetic operators.
What is "(), /, *, -, +"?
It is the default position of NULL values when sorting in ascending order in most SQL databases.
What is at the end of the result set?
It is the function that returns a specified value if the expression is NULL.
What is COALESCE()? (or NVL() in Oracle)