Advanced Oracle SQL
4.5 (46 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
263 students enrolled

Advanced Oracle SQL

Learn advanced Oracle SQL skills to take your SQL development to the next level
4.5 (46 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
263 students enrolled
Created by Ben Brumm
Last updated 7/2018
English
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Use more advanced concepts and functionality in Oracle SQL to write and improve their queries.
Course content
Expand all 37 lectures 04:19:28
+ Introduction
4 lectures 27:00

Find out more about what this course is about and what you'll learn.

Preview 07:26

Learn how to download and install Oracle Express on your own computer, to allow you to run SQL queries.

Preview 05:38

Learn how to download Oracle's SQL Developer application to run queries on the database.

SQL Developer Download
09:07

This video explains how to set up the tables needed for this course.

Preview 04:49
+ Subqueries
5 lectures 53:02

This video provides an overview and explanation of subqueries.

Subquery Review
16:30

Learn what the different options are when it comes to using subqueries.

Subquery Options
13:43

Learn how to update data with a subquery.

Updating Data with a Subquery
11:42

Learn how to insert data using a subquery.

Inserting Data using a Subquery
07:39

Learn how to delete data using a subquery.

Deleting Data using a Subquery
03:28
+ Other Database Objects
7 lectures 55:57

Learn what a synonym is and how to use it.

Synonyms
12:43

Learn what a sequence is and how they can help you.

Sequences
09:27

Learn what an index is and what it is used for.

Indexes
10:34

See some examples of indexes as explained in the previous lesson.

Index Examples
07:22

Learn what a temporary table is and how to use it.

Temporary Tables
08:07

What is the data dictionary, and how can you use it to improve your queries?

Introduction to the Data Dictionary
04:18

This video explains some useful data dictionary queries.

Useful Data Dictionary Queries
03:26
+ Views
5 lectures 42:02

An overview of what views are.

Overview of Views
07:30

Learn how to insert and update data in a view.

Inserting and Updating Data in Views
09:36

Learn what a materialized view is and how to use it.

Materialized Views
08:59

Learn what an inline view is and how to use it.

Inline Views
05:03

Learn all about view options and what they can be used for.

View Options
10:54
+ Hierarchical Queries
5 lectures 28:12

Learn what a hierarchical query is and what they are used for.

What is a Hierarchical Query?
02:35

Learn how to write a hierarchical query

Writing a Hierarchical Query
07:49

Learn what the LEVEL keyword does in a hierarchical query.

LEVEL Pseudocolumn
05:27

Learn all about the START WITH and ORDER BY keywords.

START WITH and ORDER BY
04:49

Learn about many different hierarchical query keywords.

More Hierarchical Query Keywords
07:32
+ WITH Clause
5 lectures 26:31

Learn what the WITH clause is.

The WITH clause
07:11

Find out what a recursive WITH clause is.

Recursive WITH Clause
04:40

Learn about different hierarchical concepts in a WITH clause.

Hierarchical Concepts
05:06

Learn what the SEARCH and SET operators are in a WITH clause.

SEARCH and SET Options
04:27

Learn about the CYCLE clause in a WITH clause.

Cycle Clause
05:07
+ Dates and Times
3 lectures 16:47

Understand what the timezone concept is in Oracle.

Timezone Concept
07:18

An explanation of different date and time functions in Oracle.

Date and Time Functions
04:30

Learn what the interval data types are in Oracle.

Interval Data Types
04:59
+ Transactions
3 lectures 09:57

Learn what a transaction is in Oracle.

Overview of Transactions
03:48

Learn about the COMMIT and ROLLBACK keywords.

COMMIT and ROLLBACK
04:54

The conclusion to this course.

Conclusion
01:15
Requirements
  • An understanding of basic SQL concepts
Description

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:

  • Insert, update, and delete using subqueries
  • Hierarchical queries and what they are used for
  • Synonyms, indexes, and other database objects
  • The WITH clause and why it's so useful
  • Timezones and transactions
  • And more!

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

Who this course is for:
  • Developers who work with Oracle SQL and want to understand more than the basics