A quick tour of the six principal clauses of the SELECT statement.
This course is a brief presentation of Oracle SQL. We will install a version of Oracle Express Edition and Oracle SQL Developer for free. We’ll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY). Following this, we’ll look at what else you need to know, and resources (which range from FREE to very expensive) which will help you to learn it…
What you’ll learn
Either Download and Install Oracle Express Edition and Oracle SQL Developer on your computer - for free
Write your own SELECT statements.
Learn the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.
Get an easy way to remember the order of these clauses.
Find out what more you need to know, and resources in how to learn it.