Skip to content
UdemySQLPaid courseBeginner level

Oracle SQL: An Introduction to the most popular database (Udemy.com)

A quick tour of the six principal clauses of the SELECT statement.

Created by: Phillip Burton

Last updated December 2024

icon
What you will 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.

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.5 out of 5higher than 48% of them
  • Reviews577#197 of 389 by number of reviews
  • Length1.5 hoursshorter than 91% of them
  • Last updatedDecember 2024more recently than 62% of them

icon
Course Description

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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Phillip Burton

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 1,000,000 students and more than 60 video courses, including over a dozen Bestseller courses.

My courses include Microsoft Power BI and Fabric, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. The majority of my courses align with the requirements for official certifications from Microsoft, Oracle, and Tableau - so with a bit of practice, you could enter the exam or assessment and put it on your CV or resume.

I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

icon
More courses by Phillip Burton

$18.99

$22.99

$22.99

$99.99

$13.99

Free

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.5

577 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Gregory Fant DSc PhD on 7/30/2022

This was a good overview to Oracle SQL: Introduction. SELECT-FROM-WHERE-GROUP BY-HAVING-ORDER BY I practiced with my own dataset within Oracle APEX and did the same exercises. Very useful to see the lessons using data that is meaningful to me. Thanks.

By Simon John Lazare on 1/11/2022

I have a Mac and can't install the Oracle database.

By Ravi NarayanSingh on 1/17/2021

its good ,it is described the basic fundamental of SQL function query and also easy to understand .

By Tanushree Patra on 10/26/2020

The course is really helpful for people who are new to SQL. Content is very much helpful to get clear idea.

By Chanty Smith on 9/26/2020

An excellent refresher course for all users and a great foundation course for beginners.

By Kevin Golden on 8/20/2020

The course is a little elementary for me but a refresher of the basics can be good.

By Cansu Kalkan on 8/5/2020

It is a great course for beginners! In my opinion, the more practices the more good.

By Digant Jani on 5/26/2020

It was beautiful course. Just It was sometimes more Monotonic when going inside deep understanding. But overall good Introduction to the ORACLE SQL

By Adriano Rodrigues de Araujo on 5/3/2020

Nao esperava um curso sem legendas em portugues; pois a legenda oficial era na mesma lingua do instrutor do curso de oracle e assim prejudicando o entendimento dos aspectos tecnicos e idioma na pronuncia.

By Dan A North on 3/29/2020

Excellent as usual, and a great refresher for an RDBMS I've not worked with in several years. Thank you sir. The only concern I noted was with the closed captions. It did not translate Mr. Burton's statements well at all on my system, so I turned it off.

Showing all 10 reviews on CourseDuck

Read all 577 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100