A quick tour of the six principal clauses of the SELECT statement.
Free tutorial
Created by Phillip Burton
English
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.
Requirements
- No knowledge of Oracle SQL at all is needed.
- You need to know how to use a computer, including installing programs.
- This is a free course – you have nothing to lose!
- Why not have a look at the curriculum below and see what you can learn? If you already know this information, then please see my other courses.
Description
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.
Show less
Course content
6 sections • 22 lectures • 1h 33m total lengthCollapse all sections
Introduction3 lectures • 3min
- Introduction01:39
- Welcome to Udemy00:35
- Do you want auto-translated subtitles in more languages?01:11
Install Oracle Express Edition and SQL Developer3 lectures • 17min
- Download Oracle Express Edition08:20
- Install Oracle Express Edition04:02
- Download and Install Oracle SQL Developer04:14
Opening Oracle SQL Developer2 lectures • 7min
- Connect to Database04:14
- Solving the “The network adaptor cannot establish the connection” error02:37
The SELECT, FROM and WHERE clauses5 lectures • 29min
- The SELECT and FROM clauses08:59
- Renaming fields06:30
- Using the AS keyword02:18
- Semicolons and comments04:55
- The WHERE clause05:56
The GROUP BY, HAVING and ORDER BY clauses6 lectures • 25min
- The GROUP BY clause07:19
- The HAVING clause, and information about error messages.05:29
- The ORDER BY clause04:12
- Remembering the order of the clauses02:28
- Practice Activity Number 100:22
- Practice Activity Number 1 – The Solution04:56
What’s Next?3 lectures • 14min
- What should you learn, and resources for you05:33
- Thank you for watching00:40
- Bonus lecture07:26