Oracle SQL - A Complete Introduction

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.

Created byBen Brumm

Last updated 11/2019

English

What you'll learn

In this course, you will learn how to write basic SQL statements to view data, insert data, update existing data and delete data in a database.

13 sections • 70 lectures • 4h 40m total length

Introduction3:03
An introduction to this course, who I am, and what will be covered.

How to View Data With the SELECT Statement5:38
This lecture demonstrates how to use the SELECT statement to view data.
Selecting Individual Columns5:33
Expansion of the SELECT statement to select individual columns.
Filtering Data with WHERE3:48
How to restrict the rows you are shown using the WHERE clause.
Comparison Operators3:18
How to use different comparison operators in your queries.
Filtering on Partial Values with LIKE4:15
Using the LIKE operator to filter on partial matches for words.
Filtering on Date Values3:35
How to filter your results on date values.
Using Two Filters3:03
How to use two filters in your queries in the WHERE clause.
More Than Two Filters3:54
Using three or more filters in WHERE clauses.
What is NULL?3:49
What is a NULL value and how is it treated in Oracle?
Getting Unique Records with DISTINCT4:21
Using the DISTINCT keyword to find unique records in our queries.
SELECT Quiz

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures to teach you Oracle SQL, covering database topics such as:

The course materials run for approximately 4 hours and are split into multiple sessions.

It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
Avoid paying thousands of dollars for training.
You can also study in your own time!
Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.