Learn Advanced SQL For Oracle Databases
3.9 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
477 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Advanced SQL For Oracle Databases to your Wishlist.

Add to Wishlist

Learn Advanced SQL For Oracle Databases

Hands-On Advanced SQL Skills For Oracle Databases
3.9 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
477 students enrolled
Last updated 2/2017
English
Current price: $10 Original price: $135 Discount: 93% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
Requirements
  • You should have a sample database and connection to the database.We 'll cover this in section one of this course
Description

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


Who is the target audience?
  • Anyone with basic SQL Knowledge
  • Anyone with basic knowledge of relational database management system
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 42 Lectures Collapse All 42 Lectures 04:10:28
+
Lab Setup
11 Lectures 50:00



Unlock Sample HR Schema Account
05:09

Java JDK- Download and Installation
05:24

Oracle SQL Developer Download
04:55

Oracle SQL Developer Installation
06:07

Accessing Oracle SQL Developer
03:40

Download TOAD
03:36

Install TOAD
04:08

Connect Toad To Oracle
05:21
+
Data Manipulation
2 Lectures 14:20
Using Views
11:02

Describing Table Structure
03:18
+
SET Operators
5 Lectures 17:29
What are SET Operators
04:35

Union SET Operator
05:23

Union All SET Operator
02:53

Intersect SET Operator
02:50

Minus SET Operator
01:48
+
Getting Data Back After Deletion
6 Lectures 42:57
Using The Flashback Query
05:18

What are Undo Parameters
05:11

Statement Level Flashback
08:59

Using Session Level Flashback
06:57

Process of Rolling Data back
05:35

Process of Rolling Data back -Continued
10:57
+
Analytic Functions
12 Lectures 01:12:46
Introduction To Analytic Functions
06:43

How To Write Analytic Functions
04:07

Partition By Clause
08:04

Order By Clause
05:48

Row number Functions
09:26

Rank Function
06:04

Dense Rank Function
05:57

Lead Function
06:43

Lag Function
03:37

First and Last Functions
08:56

ListAgg Function
06:14

Conclusion
01:07
+
How the Windowing Clause Works
6 Lectures 52:56
Introduction
08:06

Working with a Default Windowing Clause
10:52

Using Rows with a Windowing Clause
11:25

Using a Range with a Windowing Clause
07:36

Using Between ..And in a Windowing Clause
09:35

Multiple Windows into your data
05:22
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
960 Reviews
24,032 Students
61 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.