Oracle SQL 11g - Advance

Oracle SQL 11g,General Functions,Views,Database Objects,Controlling User Access, Set Operators, Adv Date Time Functions
3.2 (21 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.
480 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 33
  • Length 7 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 1/2014 English

Course Description

==============================================================

EXTREMELY USEFUL TO UNDERSTAND THE ADVANCE SQL 11g CONCEPTS

===============================================================

At the end of this course, you will get the knowledge of...

How to write SQL queries to access data stored in an Oracle Database schema. Learn to manipulate data and use various types of functions for customizing data output.

You will learn Oracle SQL 11g advance concepts like General functions,Views,Database Objects,Controlling User Access, Set Operators, Adv Date Time Functions,Group By Clause, Sub-queries, Hierarchical Retrieval,Oracle Extensions to DML and DDL Statements

What are the requirements?

  • Windows PC, Good Internet Connectivity and Basic database knowledge

What am I going to get from this course?

  • In this course, you will learn Advanced concepts of SQL 11g Programming Language.

What is the target audience?

  • Beginners
  • Fresh Graduates

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: General Functions
Null Related Functions
Preview
13:04
Encoding and Decoding Functions
10:01
Conditional Expression
10:54
Practical demo on How to use General Functions in SQL Advance
14:45
Quiz
10 questions
Section 2: Views
Introduction to Views
13:03
Advanced Views
18:06
Materialized View
24:44
Practical demo on How to Use Views
12:45
Quiz
10 questions
Section 3: Other Database Objects
Sequence
21:54
Indexes
19:13
Synonyms
07:56
Clusters
14:37
Practical demo on How to use other Database Objects
08:51
Quiz
10 questions
Section 4: Controlling User Access
Access Control, Users, Roles and Privileges
25:52
Granting and Revoking Privileges
15:09
Database Link
06:47
Practical demo on How to Control User Access
12:12
Quiz
9 questions
Section 5: Set Operators
Working with Set Operators
09:18
Practical demo on How to work with SET Operators
05:49
Quiz
5 questions
Section 6: Advanced Date Time Functions
Basic Concepts to understand datetime functions
12:27
Datetime functions
15:30
Practical demo on How to use Advanced date Time Functions
08:54
Quiz
9 questions
Section 7: Enhancements to Group BY Clause
Advanced Concepts - Group by Clause
09:44
Use of GROUPING Conceps
08:28
Practical demo on how to use Enhancements to Group By Clause
06:59
Quiz
5 questions
Section 8: Advanced Subqueries
Multiple-Column Subquery, Scalar Subquery
07:05
Correlated Subquery, The EXISTS Operator and the WITH Clause
12:05
Practical demo how to use Advanced Sub-Queries
08:05
Quiz
8 questions
Section 9: Hierarchical Retrieval
Fundamentals of Hierarchical Queries
12:01
Practical demo on how to use Hierarchical Retrieval
03:52
Quiz
5 questions
Section 10: Oracle 9i Extensions to DML and DDL Statements
Multitable INSERT Statements
13:51
External tables and Creating INDEX with CREATE TABLE Statement
13:06
Practical demo on how to use Oracle extensions to DML and DDL Statements
09:24
Quiz
8 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Parallel Branch Inc, Academy Of Technical Courses, Grow Your Skills Today

We offer courses in specialized technology domains that are well aligned with market trends, geared towards enabling gainful careers and are affordable. Parallel Branch is an interactive approach to e-learning and a perfect way to Jump Start your career.

In today’s job market, it’s important to have the skills to match current needs and to stay on par with technological advances. The flexible, affordable and high-quality online technical courses at Parallel Branch provide the opportunity for you to learn the skills you need to move ahead and stay there.

Ready to start learning?
Take This Course