Advanced Oracle SQL: Learn Advanced SQL Skills

Oracle SQL is packed with advanced functions and features that provides powerful capabilities to build advanced querries
3.4 (13 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.
179 students enrolled
Instructed by Skill Tree IT & Software / Other
$19
$175
89% off
Take This Course
  • Lectures 46
  • Length 4.5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

Oracle SQL is one of the world's most powerful version of the standard SQL language. The advanced capabilities of Oracle SQL will enable you to build advanced SQL statements or queries that can be stored on the database.
Oracle SQL is packed with advanced functions and features that gives the language powerful capabilities. Using these powerful features makes it easier to solve complex query related issues.
This course will give you the knowledge and understanding to confidently build complex queries to solve database related problems faster .
This course will teach you working examples of how to leverage Oracle SQL's powerful built-in functions for fast extraction of complex data and how to use native SQL for procedural processing. Every developer needs to know how to use Oracle SQL to summarize and aggregate data from large tables and how to use powerful features such as the "model" clause to make SQL act as a procedural language.

This course will teach you how the techniques for retrieving Oracle data faster and more elegantly .
This course is designed for those that have some basic knowledge of oracle SQL and Oracle Databases.

Some of the topic covered in this course includes:
• Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Retrieve row and column data from tables.
• Control privileges at the object and system level.
• Create indexes and constraints; alter existing schema objects.
• Write SELECT statements that include queries
• Create Business reports from SQL Statements
• Retrieve row and column data from tables
• Create tables to store data
• Run data manipulation statements (DML)
• Create reports of aggregated data

What are the requirements?

  • Familliarity with data processing concepts and techniques
  • Basic knowledge of SQL Language
  • Basic knowlege of relational database e,g Oracle

What am I going to get from this course?

  • Describe a tables's structure
  • Build advanced sql querries
  • Combine multiple querries into one
  • Create Business reports from SQL querries
  • Create Schema Objects like views
  • Recover data from database using flashback querries
  • Understand and build comples SQL querries
  • Know how to use Oracle SQL Developer
  • Manipulate data in a relational database
  • Write reports using SQL Statements
  • Build knowledge through Hands-on Exercises

What is the target audience?

  • System Analyst
  • Application Developers
  • PL /SQL Developers
  • Business Analysts
  • Developers
  • Data Warehouse Administrator
  • Form Developer
  • Functional Implementer
  • IT Professionals
  • Technology Hobbyist

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
02:27
Oracle 11g Express Download
Preview
04:58
Oracle 11g Installation
Preview
04:47
Unlocking Sample HR Schema Account
05:09
Java Development Kit (Jdk) 8 Download and Installation
05:24
Oracle SQL Developer Download
04:55
Oracle SQL Developer Installation
06:07
Launching Oracle SQL Developer
03:40
Toad For Oracle Download
03:36
Toad For Oracle Installation
04:08
Toad for Oracle quick tour
05:41
Connecting Toad For Oracle to Database
05:21
Section 2: Oracle SQL Analytic Functions
What are Analytic Functions
06:43
Syntax For Using Analytic Functions
04:07
Using the PARTITION BY Clause
08:04
Using the ORDER BY Clause
05:48
Using the Windowing Clause
02:10
ROW_NUMBER FUNCTION
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
Section 3: Viewing and Manipulating Data Using SQL
Viewing data and returning Minimum value
10:12
View data and create a report using SQL
12:57
Using 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
SET Operators Summary
03:31
Section 4: Viewing and Rolling Back Data with Flash Query
Flashback Query
05:18
Undo Parameters
05:11
Viewing data using statement level flashback
08:59
Rolling Back Data Part 1
05:35
Rolling Back Data Part 2
10:57
Session level flashback
06:57
Section 5: Useful SQL COMMANDS
Describe Command
03:18
Sequences
06:34
Syntax for Creating Sequences
04:57
How to use a sequence
07:48
views
11:02
Synonyms
06:05
QUIZ
00:28
Conclusion
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Skill Tree, Skill based learning

We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.

Ready to start learning?
Take This Course