Oracle SQL 11g - Advance
4.0 (31 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.
576 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL 11g - Advance to your Wishlist.

Add to Wishlist

Oracle SQL 11g - Advance

Oracle SQL 11g,General Functions,Views,Database Objects,Controlling User Access, Set Operators, Adv Date Time Functions
4.0 (31 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.
576 students enrolled
Last updated 1/2014
English
English
Current price: $10 Original price: $20 Discount: 50% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • In this course, you will learn Advanced concepts of SQL 11g Programming Language.
View Curriculum
Requirements
  • Windows PC, Good Internet Connectivity and Basic database knowledge
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

Who is the target audience?
  • Beginners
  • Fresh Graduates
Students Who Viewed This Course Also Viewed
Curriculum For This Course
33 Lectures
06:46:31
+
General Functions
4 Lectures 48:44

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
+
Views
4 Lectures 01:08:38
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
+
Other Database Objects
5 Lectures 01:12:31
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
+
Controlling User Access
4 Lectures 01:00:00
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
+
Set Operators
2 Lectures 15:07
Working with Set Operators
09:18

Practical demo on How to work with SET Operators
05:49

Quiz
5 questions
+
Advanced Date Time Functions
3 Lectures 36:51
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
+
Enhancements to Group BY Clause
3 Lectures 25:11
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
+
Advanced Subqueries
3 Lectures 27:15
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
+
Hierarchical Retrieval
2 Lectures 15:53
Fundamentals of Hierarchical Queries
12:01

Practical demo on how to use Hierarchical Retrieval
03:52

Quiz
5 questions
+
Oracle 9i Extensions to DML and DDL Statements
3 Lectures 36:21
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
About the Instructor
Parallel Branch Inc
3.8 Average rating
1,161 Reviews
10,936 Students
32 Courses
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.