Advanced Oracle SQL

Name: Advanced Oracle SQL
Rating: 4.4 (107 reviews)

Learn advanced Oracle SQL skills to take your SQL development to the next level

Created byBen Brumm

Last updated 7/2018

English

What you'll learn

Use more advanced concepts and functionality in Oracle SQL to write and improve their queries.

8 sections • 37 lectures • 4h 19m total length

Introduction7:26
Find out more about what this course is about and what you'll learn.
Oracle Express Download and Install5:38
Learn how to download and install Oracle Express on your own computer, to allow you to run SQL queries.
SQL Developer Download9:07
Learn how to download Oracle's SQL Developer application to run queries on the database.
Set Up Database Tables4:49
This video explains how to set up the tables needed for this course.

Subquery Review16:30
This video provides an overview and explanation of subqueries.
Subquery Options13:43
Learn what the different options are when it comes to using subqueries.
Updating Data with a Subquery11:42
Learn how to update data with a subquery.
Inserting Data using a Subquery7:39
Learn how to insert data using a subquery.
Deleting Data using a Subquery3:28
Learn how to delete data using a subquery.

Synonyms12:43
Learn what a synonym is and how to use it.
Sequences9:27
Learn what a sequence is and how they can help you.
Indexes10:34
Learn what an index is and what it is used for.
Index Examples7:22
See some examples of indexes as explained in the previous lesson.
Temporary Tables8:07
Learn what a temporary table is and how to use it.
Introduction to the Data Dictionary4:18
What is the data dictionary, and how can you use it to improve your queries?
Useful Data Dictionary Queries3:26
This video explains some useful data dictionary queries.

What is a Hierarchical Query?2:35
Learn what a hierarchical query is and what they are used for.
Writing a Hierarchical Query7:49
Learn how to write a hierarchical query
LEVEL Pseudocolumn5:27
Learn what the LEVEL keyword does in a hierarchical query.
START WITH and ORDER BY4:49
Learn all about the START WITH and ORDER BY keywords.
More Hierarchical Query Keywords7:32
Learn about many different hierarchical query keywords.

Do you know the basics of Oracle SQL?

Already know how to write a SELECT statement or INSERT data into a table?

There's plenty more to learn about Oracle SQL, and this is the course to take.

Take your Oracle SQL skills to the next level by enrolling in this Advanced Oracle SQL, which follows on from my Introduction to Oracle SQL course.

You'll learn more advanced concepts, at an easy-to-follow pace, including:

Watch the promo video for this course for more information, and then enrol i this course!