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
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
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.
Instructor Details
- 4.5 Rating
577 Reviews
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.
More courses by Phillip Burton
PL-300 certification prep: Microsoft Power BI Data Analyst (2026)
4.6 (38,841 Reviews)
Provider: Udemy
Time: 30.3h
$18.99
70-461, 761: Querying Microsoft SQL Server with T-SQL course (2026)
4.6 (18,624 Reviews)
Provider: Udemy
Time: 28.7h
$22.99
Salesforce Tableau Data Analyst/Specialist Desktop Cert Prep (2026)
4.7 (15,238 Reviews)
Provider: Udemy
Time: 15.7h
$22.99
PL-900 prep: Microsoft Power Platform Fundamentals (2026)
4.7 (15,071 Reviews)
Provider: Udemy
Time: 11h
$99.99
SQL Server Integration Services (SSIS) - An Introduction (2026)
4.6 (11,116 Reviews)
Provider: Udemy
Time: 3.9h
$13.99
Microsoft Excel - Improve your skills quickly (2024)
4.6 (9,076 Reviews)
Provider: Udemy
Time: 1.6h
Free
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100












