Learn Advanced SQL For Oracle Databases

Learn Advanced SQL For Oracle Databases, available at $54.99, has an average rating of 4.45, with 43 lectures, based on 54 reviews, and has 10133 subscribers.

You will learn about Create Views Write Complex SQL Queries Know how to use Analytic functions Know how to use SET operators Retrieve deleted data using Flashback Query This course is ideal for individuals who are Anyone with basic SQL Knowledge or Anyone with basic knowledge of relational database management system It is particularly useful for Anyone with basic SQL Knowledge or Anyone with basic knowledge of relational database management system.

Enroll now: Learn Advanced SQL For Oracle Databases

Summary

Title: Learn Advanced SQL For Oracle Databases

Price: $54.99

Average Rating: 4.45

Number of Lectures: 43

Number of Published Lectures: 43

Number of Curriculum Items: 43

Number of Published Curriculum Objects: 43

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Create Views
Write Complex SQL Queries
Know how to use Analytic functions
Know how to use SET operators
Retrieve deleted data using Flashback Query

Who Should Attend

Anyone with basic SQL Knowledge
Anyone with basic knowledge of relational database management system

Target Audiences

Anyone with basic SQL Knowledge
Anyone with basic knowledge of relational database management system

Learn the advanced SQL skills necessary to design and code complex queries against Oracle databases. Design, code and test the most efficient query to solve a given business problem. Oracle databases are one of the most widely used database systems in the world.

In this course you will have a choice of either using Toad or SQL developer to connect to the oracle database. The course will show you how to setup connection to the database.
This advanced Oracle SQL course covers the design of more complex SQL statements and the strategies available for implementing them, it covers topics like SET operators and Analytic functions. It also introduces you to views because these are useful for hiding the complexity of queries and also can act as a security mechanism

Who is This Course For?

This course is designed for anyone who has some basic SQL knowledge and can write and understand simple SQL Queries. Also knowing the basics of relational database management systems (RDBMS) would be an advantage.

What You Will Learn:

How to Create Views
How to check the structure of a table
How to use Flashback to Rollback Data
How to use Analytic Functions
How to use SET operators to query data
How to set database environment
How to connect to the database
How to write advanced SQL queries

Course Curriculum

Chapter 1: Lab Setup

Lecture 1: Introduction

Lecture 2: Download Oracle Database

Lecture 3: Install Oracle Database

Lecture 4: Unlock Sample HR Schema Account

Lecture 5: Java JDK- Download and Installation

Lecture 6: Oracle SQL Developer Download

Lecture 7: Oracle SQL Developer Installation

Lecture 8: Accessing Oracle SQL Developer

Lecture 9: Download TOAD

Lecture 10: Install TOAD

Lecture 11: Connect Toad To Oracle

Chapter 2: Data Manipulation

Lecture 1: Using Views

Lecture 2: Describing Table Structure

Chapter 3: SET Operators

Lecture 1: What are SET Operators

Lecture 2: Union SET Operator

Lecture 3: Union All SET Operator

Lecture 4: Intersect SET Operator

Lecture 5: Minus SET Operator

Chapter 4: Getting Data Back After Deletion

Lecture 1: Using The Flashback Query

Lecture 2: What are Undo Parameters

Lecture 3: Statement Level Flashback

Lecture 4: Using Session Level Flashback

Lecture 5: Process of Rolling Data back

Lecture 6: Process of Rolling Data back -Continued

Chapter 5: Analytic Functions

Lecture 1: Introduction To Analytic Functions

Lecture 2: How To Write Analytic Functions

Lecture 3: Partition By Clause

Lecture 4: Order By Clause

Lecture 5: Row number Functions

Lecture 6: Rank Function

Lecture 7: Dense Rank Function

Lecture 8: Lead Function

Lecture 9: Lag Function

Lecture 10: First and Last Functions

Lecture 11: ListAgg Function

Lecture 12: Conclusion

Chapter 6: How the Windowing Clause Works

Lecture 1: Introduction

Lecture 2: Working with a Default Windowing Clause

Lecture 3: Using Rows with a Windowing Clause

Lecture 4: Using a Range with a Windowing Clause

Lecture 5: Using Between ..And in a Windowing Clause

Lecture 6: Multiple Windows into your data

Lecture 7: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes
2 stars: 3 votes
3 stars: 11 votes
4 stars: 16 votes
5 stars: 24 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