3.45 out of 5
3.45
23 reviews on Udemy

Learn Advanced SQL For Oracle Databases

Hands-On Advanced SQL Skills For Oracle Databases
Instructor:
Bluelime Learning Solutions
1,813 students enrolled
English [Auto]
Create Views
Write Complex SQL Queries
Know how to use Analytic functions
Know how to use SET operators
Retrieve deleted data using Flashback Query

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.

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

Lab Setup

1
Introduction
2
Download Oracle Database
3
Install Oracle Database
4
Unlock Sample HR Schema Account
5
Java JDK- Download and Installation
6
Oracle SQL Developer Download
7
Oracle SQL Developer Installation
8
Accessing Oracle SQL Developer
9
Download TOAD
10
Install TOAD
11
Connect Toad To Oracle

Data Manipulation

1
Using Views
2
Describing Table Structure

SET Operators

1
What are SET Operators
2
Union SET Operator
3
Union All SET Operator
4
Intersect SET Operator
5
Minus SET Operator

Getting Data Back After Deletion

1
Using The Flashback Query
2
What are Undo Parameters
3
Statement Level Flashback
4
Using Session Level Flashback
5
Process of Rolling Data back
6
Process of Rolling Data back -Continued

Analytic Functions

1
Introduction To Analytic Functions
2
How To Write Analytic Functions
3
Partition By Clause
4
Order By Clause
5
Row number Functions
6
Rank Function
7
Dense Rank Function
8
Lead Function
9
Lag Function
10
First and Last Functions
11
ListAgg Function
12
Conclusion

How the Windowing Clause Works

1
Introduction
2
Working with a Default Windowing Clause
3
Using Rows with a Windowing Clause
4
Using a Range with a Windowing Clause
5
Using Between ..And in a Windowing Clause
6
Multiple Windows into your data
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
3.5
3.5 out of 5
23 Ratings

Detailed Rating

Stars 5
5
Stars 4
9
Stars 3
6
Stars 2
3
Stars 1
0
7ed9f7acdbe13d2a1231b7bf76ce716b
Course available for 2 days
30-Day Money-Back Guarantee

Includes

4 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW