Udemy

Oracle SQL: An Introduction to the most popular database

Name: Oracle SQL: An Introduction to the most popular database
Availability: InStock
Rating: 4.5 (574 reviews)

4.5(574)18k students

Korshub's take

Oracle SQL From Zero: Install, Query, Understand

This is a brief, practical introduction to Oracle SQL for people with no prior database experience. It is not affiliated with or endorsed by Oracle — this is independent, hands-on instruction covering the free tools you need to get started.

What You'll Learn

Installing Oracle Express Edition (the backend engine that does the work) and Oracle SQL Developer (the front-end for sending queries and viewing results), both free
Renaming fields with the AS keyword, plus semicolon and comment conventions

The SELECT Statement's Six Clauses

SELECT — which fields to retrieve
FROM — the data source
WHERE — filtering rows by criteria
GROUP BY — aggregating results into summaries
HAVING — further summarizing grouped data
ORDER BY — ordering the final results

The course closes with pointers to further learning resources, ranging from free to paid, for continuing beyond the basics.

Who it's for: absolute beginners — no prior SQL or database knowledge is assumed.

About this course

This course is a brief presentation of Oracle SQL.

Please note: This course is not affiliated with, endorsed by, or sponsored by Oracle.

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 SQL Developer is the front engine, which allows you to send queries and see the results.

We'll then look at the SELECT statement 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 FROM clause shows the data source.
The WHERE clause filters it down, based on criteria you choose.
The GROUP BY clause aggregates (sums, count, min, max) it together, creating a summary.
The HAVING clause can summarise it further.
The ORDER BY 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.