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.
This course is a brief presentation of Oracle SQL.
We will install a version of Oracle Express Edition and Oracle SQL Developer for free.
The Oracle Express Edition is the back engine, which does all of the work.
Oracle SQLDeveloper is the front engine, which allows you to send queries and see the results.
We'll then look at the SELECTstatement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).
The SELECT clause says what fields you want to retrieve.
The FROMclause shows the data source.
The WHERE clause filters it down, based on criteria you choose.
The GROUPBYclause aggregates (sums, count, min, max) it together, creating a summary.
The HAVING clause can summarise it further.
The ORDERBY clause then orders the results.
As part of this, we'll be looking at how you can rename fields in a query, how you can use the AS keyword, and semicolons and comments.
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.
No prior knowledge is required - just a willingness to learn.
See you on the course.
