Free Oracle SQL Tutorial – Oracle SQL: An Introduction to the most popular database
Learn Oracle SQL and master the six principal clauses of the SELECT statement. This beginner’s course is perfect for those seeking to gain a comprehensive understanding of Oracle SQL. No prior knowledge required. Join now!
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 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.
Who this course is for:
- This beginner’s course is for you if you want to learn about Oracle SQL and the six principal clauses of the SELECT statement.
- If you have already heard about Oracle SQL, and wish to learn more about SQL code, then please have a look at my courses.
User Reviews
Be the first to review “Free Oracle SQL Tutorial – Oracle SQL: An Introduction to the most popular database”
You must be logged in to post a review.
There are no reviews yet.