Oracle SQL: An Introduction to the most popular database

Name: Oracle SQL: An Introduction to the most popular database
Rating: 4.5 (574 reviews)

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

Last updated 12/2024

English

English [Auto],

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.

6 sections • 23 lectures • 1h 29m total length

Introduction1:39
Explore Oracle SQL basics by learning the six essential clauses: select, from, where, group by, having, and order by, using Oracle Express Edition and Oracle SQL Developer, with guided practice.
Welcome to Udemy0:35
Welcome to Udemy2:40
Master Udemy video controls for this Oracle SQL course, including play/pause, speed, volume, subtitles, and video quality, while exploring course content, resources, notes, Q&A, and announcements.
Do you want auto-translated subtitles in more languages?1:11

Download Oracle Express Edition8:20
Install Oracle database express edition, choosing 11g, 12c, or 18c based on your system. If you have a 32-bit machine, use 11g; otherwise download from Oracle with license sign-in.
Install Oracle Express Edition4:02
Install Oracle database express edition 18c by running setup, configuring prerequisites, and setting a password for sys and pdb admin accounts, completing the backend installation.
Download and Install Oracle SQL Developer4:14
Install the Oracle SQL Developer front end to access Oracle's back end, choosing 64-bit with JDK or 32-bit with a separate JDK, then extract and run the application.

Connect to Database4:14
Create a new local database connection in the Oracle development environment, enter username and password, set the DPA role, test, save the password, and color-code the connection for quick identification.
Solving the "The network adaptor cannot establish the connection" error2:37
Diagnose and fix the network adaptor could not establish the connection error in Oracle SQL by checking the listener status and restarting the listener.

The SELECT and FROM clauses8:59
Explore the Oracle SQL select statement, built from select, from, where, group by, having, and order by, and learn to print results, fetch all rows, and select specific columns.
Renaming fields6:30
Explore renaming fields in Oracle SQL by querying the data dictionary's col$ table, using quoted and non quoted identifiers, and understanding how to handle spaces and underscores.
Using the AS keyword2:18
Explore how the as keyword optionally renames columns in a select statement and how quoted versus non-quoted identifiers determine the new column names in Oracle SQL.
Semicolons and comments4:55
Understand why semicolons are essential in Oracle SQL and avoid errors. Explore single-line and multi-line comments with -- and /* */, plus the Ctrl+/ keyboard shortcut.
The WHERE clause5:56
Use the where clause to filter rows, showing how original column names must be used, how equality works, and how sorting and temporary filters affect results.

The GROUP BY clause7:19
Group by name to consolidate identical names, count occurrences with an aggregation, alias the results using as, and follow the rule that non-aggregated columns must appear in the group by.
The HAVING clause, and information about error messages.5:29
Demonstrate the HAVING clause as a post-group filter for aggregate results, compare it to where, and cover common error 904 (invalid identifier) and its resolution.
The ORDER BY clause4:12
Sorts the final result set with the order by clause after from, group by, and having. Order by renamed fields or aliases; use desc to sort descending and resolve ties.
Remembering the order of the clauses2:28
Remember the order of SQL clauses: select, from, where, group by, having, order by; this left-to-right pattern helps avoid common aggregation and non-aggregated column mistakes.
Practice Activity Number 10:22
Practice Activity Number 1 - The Solution4:56
Practice activity reinforces sql basics by building a select statement from a table, using where and order by, applying aliases, and explains group by and having placement with descending order.

What should you learn, and resources for you5:33
Explore Oracle University options, including ISEE 0071 exam details and core topics such as relational database concepts, where clause, joins, subqueries, and group by having.
Thank you for watching0:40
Recap the course highlights and practice with Oracle express edition and Oracle SQL Developer, covering the select statement and six principal clauses: select, from, where, group by, having, order by.
Bonus Lecture SQL0:17

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.

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.

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.