Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Lab Setup|
Download Oracle DatabasePreview
Install Oracle DatabasePreview
Unlock Sample HR Schema Account
Java JDK- Download and Installation
Oracle SQL Developer Download
Oracle SQL Developer Installation
Accessing Oracle SQL Developer
Connect Toad To Oracle
|Section 2: Data Manipulation|
Describing Table Structure
|Section 3: SET Operators|
What are SET Operators
Union SET Operator
Union All SET Operator
Intersect SET Operator
Minus SET Operator
|Section 4: Getting Data Back After Deletion|
Using The Flashback Query
What are Undo Parameters
Statement Level Flashback
Using Session Level Flashback
Process of Rolling Data back
Process of Rolling Data back -Continued
|Section 5: Analytic Functions|
Introduction To Analytic Functions
How To Write Analytic Functions
Partition By Clause
Order By Clause
Row number Functions
Dense Rank Function
First and Last Functions
|Section 6: How the Windowing Clause Works|
Working with a Default Windowing Clause
Using Rows with a Windowing Clause
Using a Range with a Windowing Clause
Using Between ..And in a Windowing Clause
Multiple Windows into your data
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.