Advanced Oracle SQL

Advanced Oracle SQL, available at $44.99, has an average rating of 4.25, with 37 lectures, based on 93 reviews, and has 498 subscribers.

You will learn about Use more advanced concepts and functionality in Oracle SQL to write and improve their queries. This course is ideal for individuals who are Developers who work with Oracle SQL and want to understand more than the basics It is particularly useful for Developers who work with Oracle SQL and want to understand more than the basics.

Enroll now: Advanced Oracle SQL

Summary

Title: Advanced Oracle SQL

Price: $44.99

Average Rating: 4.25

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Developers who work with Oracle SQL and want to understand more than the basics

Target Audiences

Developers who work with Oracle SQL and want to understand more than the basics

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Oracle Express Download and Install

Lecture 3: SQL Developer Download

Lecture 4: Set Up Database Tables

Chapter 2: Subqueries

Lecture 1: Subquery Review

Lecture 2: Subquery Options

Lecture 3: Updating Data with a Subquery

Lecture 4: Inserting Data using a Subquery

Lecture 5: Deleting Data using a Subquery

Chapter 3: Other Database Objects

Lecture 1: Synonyms

Lecture 2: Sequences

Lecture 3: Indexes

Lecture 4: Index Examples

Lecture 5: Temporary Tables

Lecture 6: Introduction to the Data Dictionary

Lecture 7: Useful Data Dictionary Queries

Chapter 4: Views

Lecture 1: Overview of Views

Lecture 2: Inserting and Updating Data in Views

Lecture 3: Materialized Views

Lecture 4: Inline Views

Lecture 5: View Options

Chapter 5: Hierarchical Queries

Lecture 1: What is a Hierarchical Query?

Lecture 2: Writing a Hierarchical Query

Lecture 3: LEVEL Pseudocolumn

Lecture 4: START WITH and ORDER BY

Lecture 5: More Hierarchical Query Keywords

Chapter 6: WITH Clause

Lecture 1: The WITH clause

Lecture 2: Recursive WITH Clause

Lecture 3: Hierarchical Concepts

Lecture 4: SEARCH and SET Options

Lecture 5: Cycle Clause

Chapter 7: Dates and Times

Lecture 1: Timezone Concept

Lecture 2: Date and Time Functions

Lecture 3: Interval Data Types

Chapter 8: Transactions

Lecture 1: Overview of Transactions

Lecture 2: COMMIT and ROLLBACK

Lecture 3: Conclusion

Instructors

Ben Brumm
IT Software Consultant

Rating Distribution

1 stars: 3 votes
2 stars: 0 votes
3 stars: 13 votes
4 stars: 33 votes
5 stars: 44 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu