Retrieve Information using SQL

SELECT

SQL SELECT: learn how to retrieve information from a database.

SQL SELECT – Quiz: test your understanding of the select statement”.

SQL DISTINCT, ORDER BY, COUNT : learn how to eliminates duplicates in the query result, how to count rows and how to order them.

SQL DISTINCT, ORDER BY, COUNT – quiz: test your understanding of the article “SQL DISTINCT, ORDER BY, COUNT “.

WHERE

SQL WHERE condition: learn how to filter the rows you are displaying.

SQL WHERE Condition – Quiz: test your understanding of the article “SQL Where Condition”.

Combining conditions in SQL: learn how to write SQL statements containing more than one conditions.

Combining conditions in SQL – Quiz: test your understanding of the article “Combining conditions in SQL”.

Combining OR and AND in SQL : learn how to OR and AND keywords in the same where clause.

JOIN

SQL INNER JOIN : combine information from several tables using one query.

SQL INNER JOIN – Quiz: test your understanding of the article “SQL INNER JOIN”.

SQL OUTER JOIN : learn other types of joins (left outer join, right outer join).

SQL OUTER JOIN – Quiz: test your understanding of the article “SQL OUTER JOIN”.

GROUP BY

SQL GROUP BY: group lines in a table. This enables you to show total, averages, minimum, maximum averages per group of information.

SQL GROUP BY – Quiz: test your understanding of the article “SQL group by”.

 
Share on: