Basic SQL
SQL Symbols
SQL Operators
SQL Clauses & Statements
Let's Talk More In Depth About SQL
100

This is a standard language that can be used to effectively insert, search, update, and delete database records.

What is SQL?

100
These symbols mean greater than or equal to?
What is >= ?
100
This word joins two conditions in the where line.
What is and?
100

This statement is used to fetch data from a database.

What is Select?

100

This doesn't allow you to work at scale or impose structure on data.

What is Excel?

200

This is a set of column(s) that is used to uniquely identify the record in a table.

What is a key?

200
This symbol means a wildcard.
What is %?
200
This operator stands for equal to.
What is =?
200

This word specifies the tables from which the query extracts data.

What is From?

200

This is a collection of data that is organized as a set of formally-described tables and is the most popular type in the market.

What is a relational database?

300
This symbol brings back all the rows and columns.
What is *?
300
This symbol means less than.
What is < ?
300
These operators bring back a range of values.
What is between and?
300

This word limits the data brought back.

What is Where?

300

This is a very broad term, but it generally refers to non-relational database management systems. These systems usually have query languages of their own, but they may also support SQL queries.

What is NoSQL?

400

This is a column (also known as a field) in a database table that is made up of values generated by the database.

What is an ID?

400
These symbols go around a list of values with the in operator.
What is ( ) parantheses?
400
This operator searches for a pattern of letters.
What is like?
400

This statement goes through conditions and returns a value when the first condition is met (like an IF-THEN-ELSE statement)

What is Case When?

400

This is a concept that an organization can apply as part of its information architecture to ensure that everyone in the organization uses the same data when making business decisions.

What is SSOT?

500
This symbol ends a SQL statement.
What is ; ?
500
These symbols mean not equal.
What is != ?
500
This operator gives a list of values.
What is in?
500

This rounds a timestamp to the interval you need.

What is DATE_TRUNC?

500

If you’re writing a query to display names and city of salesman, who belong to the city of Paris (from the table ‘salesman’) this query would include three statements.

What is SELECT name, city FROM salesman WHERE city='Paris';?

M
e
n
u