Oracle SQL: An Introduction to the most popular database

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

4.63 (495 reviews)
Udemy
platform
English
language
Databases
category
instructor
Oracle SQL: An Introduction to the most popular database
17,406
students
1.5 hours
content
Dec 2023
last update
FREE
regular price

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.

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.

Content

Introduction

Introduction
Welcome to Udemy

Install Oracle Express Edition and SQL Developer

Download Oracle Express Edition
Install Oracle Express Edition
Download and Install Oracle SQL Developer

Opening Oracle SQL Developer

Connect to Database
Solving the "The network adaptor cannot establish the connection" error

The SELECT, FROM and WHERE clauses

The SELECT and FROM clauses
Renaming fields
Using the AS keyword
Semicolons and comments
The WHERE clause

The GROUP BY, HAVING and ORDER BY clauses

The GROUP BY clause
The HAVING clause, and information about error messages.
The ORDER BY clause
Remembering the order of the clauses
Practice Activity Number 1
Practice Activity Number 1 - The Solution

What's Next?

What should you learn, and resources for you
Bonus video - Learn more, and save money!
Bonus lecture - Here's the link for more
Thank you for watching

Reviews

Tahnee
February 9, 2023
This short course has been so helpful for me. I'm currently a software engineering student and I have been having trouble understanding the structure of select statements. This course broke down the order of the clauses for me that has helped me progress significantly in my college studies!
Gregory
July 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.
Tanushree
October 26, 2020
The course is really helpful for people who are new to SQL. Content is very much helpful to get clear idea.
Rehema
June 9, 2020
So far so good, instructor is explaining every part step by step, that is the best way to learn for me. This has prepared me for the next course where I will learn and be able to take the 1Z0-071 certification. Great instructor, thank you for how you teach.
Digant
May 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
Adriano
May 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.
Dan
March 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.

Charts

Price

Oracle SQL: An Introduction to the most popular database - Price chart

Rating

Oracle SQL: An Introduction to the most popular database - Ratings chart

Enrollment distribution

Oracle SQL: An Introduction to the most popular database - Distribution chart

Related Topics

2543659
udemy ID
9/4/2019
course created date
9/8/2019
course indexed date
Bot
course submited by