Complete Oracle SQL Course > Miscellaneous

Common Table Expressions in Oracle SQL

15.9k

Learner's Ratings

4.3

Overall Rating

  • 70%
  • 9%
  • 13%
  • 4%
  • 4%

Reviews

H
Harsh ojha
4

how can we get or know dbi user

A
Aditya Jadhav
5

good platfrom , good teacher,

R
Ravi Kanhere
5

very very knowledgeable

R
Ravi Kanhere
5

it is very useful for new learner's and other's also and i will thanks to LearnVern team & trainer's

B
Bhmani Hirali
5

Super coching

A
Arvind Ramrao Doiphode
5

WHR TO FIND NOTES.....?

V
Vaibhav Shinde
5

AMAZING STUFF

S
Sagar K
5

very helpfull Thank you sir

M
mayank sharma
5

sqlplus not install

B
Balram Gupta
5

sql plus not install

Show More
Recommended Courses
Course Content

  1. Introduction to the Course: Oracle SQL
    4m 6s

  1. Overview of Data
    14m 11s
  2. Need of DBMS
    16m 5s
  3. History of Oracle Database
    7m 39s
  4. ACID Properties
    8m 17s

  1. Oracle Database Connection
    25m 14s

  1. Types of SQL Statements
    17m 54s
  2. Table Creation in Oracle SQL
    21m 9s
  3. Create Table Statement Practical in Oracle SQL
    17m 11s
  4. SQL Data Types
    26m
  5. Constraints in Oracle SQL
    22m 35s
  6. Table Grants in Oracle SQL
    11m 44s
  7. Table Grants Statement Practical in Oracle SQL
    5m 52s
  8. Comments in Oracle SQL
    7m 37s
  9. Comments Statement Practical in Oracle SQL
    6m 28s
  10. Alter Table in Oracle SQL
    9m 18s
  11. Alter Table Constraint Practical in Oracle SQL
    38m 12s
  12. Drop Table in Oracle SQL
    10m 31s
  13. Tablespace and Datafiles in Oracle SQL
    9m 29s
  14. SELECT Statement in Oracle SQL
    9m 35s
  15. INSERT Statement in Oracle SQL
    19m 31s
  16. UPDATE Statement in Oracle SQL
    9m 48s
  17. DELETE Statement in Oracle SQL
    11m 46s
  18. MERGE Statement in Oracle SQL
    17m 27s
  19. DML Statement Practical in Oracle SQL
    51m 11s
  20. Alter Table Statement Practical in Oracle SQL
    10m 30s
  21. Drop Table, Truncate Table, and Delete Practical in Oracle SQL
    20m
  22. Data Control Language in Oracle SQL
    13m 25s

  1. Ordering of Data in Oracle SQL
    25m 45s
  2. Ordering of Data Practical in Oracle SQL
    20m 52s

  1. Introduction to Table Joins in Oracle SQL
    17m 7s
  2. Inner Join in Oracle SQL
    20m 51s
  3. Left Outer Join in Oracle SQL
    21m 41s
  4. Right Outer Join in Oracle SQL
    11m 27s
  5. Full Outer Join in Oracle SQL
    19m 57s
  6. Practical of Inner Join and Outer Join in Oracle SQL
    39m 24s
  7. Practical of Multiple Columns with Join Condition in Oracle SQL
    22m 16s

  1. SET Operators in Oracle SQL
    17m 18s
  2. UNION in Oracle SQL
    22m 4s
  3. MINUS in Oracle SQL
    11m 36s
  4. INTERSECT in Oracle SQL
    12m 52s
  5. SET Operators Practical in Oracle SQL
    37m

  1. Comparison Operators in Oracle SQL
    19m 17s
  2. Comparison Operators Examples in Oracle SQL
    27m 58s
  3. In and Exists Operators in Oracle SQL
    27m 12s
  4. Logical Operators in Oracle SQL
    22m 13s
  5. Operators Practical in Oracle SQL
    54m 30s

  1. Using GROUP BY in Oracle SQL
    13m 49s
  2. Using Aggregate Functions in Oracle SQL
    23m 37s
  3. Using Having Clause in Oracle SQL
    8m 43s
  4. Group By and Aggregate Function Practical in Oracle SQL
    25m 42s

  1. SQL Functions in Oracle SQL
    5m 55s
  2. Conversion Functions in Oracle SQL
    33m 10s
  3. Null Handling Functions in Oracle SQL
    16m 45s
  4. Conditional Functions in Oracle SQL
    19m 16s
  5. Numeric Functions in Oracle SQL
    26m 42s
  6. Character Functions in Oracle SQL
    57m 13s
  7. Date Functions in Oracle SQL
    34m 10s
  8. Practicals: Functions in Oracle SQL
    40m 4s

  1. Introduction to Index in Oracle SQL
    23m 58s
  2. B - tree Index in Oracle SQL
    17m 53s
  3. Bitmap Index in Oracle SQL
    16m 7s
  4. Practicals: Index in Oracle SQL
    28m 53s

  1. Sequence in Oracle SQL
    30m 41s
  2. Practicals: Sequence in Oracle SQL
    26m 33s

  1. Views in Oracle SQL
    30m 6s
  2. Materialized Views in Oracle SQL
    45m 8s
  3. Practicals: View in Oracle SQL
    37m 15s

  1. Synonyms in Oracle SQL
    16m 47s
  2. Practicals: Synonyms in Oracle SQL
    18m 40s

  1. Data Dictionary Views in Oracle SQL
    01h 20m 41s
  2. Practicals: Data Dictionary Views in Oracle SQL
    32m 18s

  1. Common Table Expressions in Oracle SQL
    20m 21s
  2. Hierarchical Query in Oracle SQL
    01h 6m 3s
  3. Distinct in Oracle SQL
    16m 4s
  4. Default in Conversion Function in Oracle SQL
    19m
  5. Like Condition in Oracle SQL
    23m 15s
  6. Multitable Insert in Oracle SQL
    33m 56s
  7. Conditional Aggregation in Oracle SQL
    15m 23s
  8. Transposing Columns and Rows in Oracle SQL
    43m 15s
  9. Miscellaneous Practicals in Oracle SQL
    01h 12s

  1. Course Summary
    18m 43s

  1. Interview Questions
    18m 16s

  1. Career Guidelines
    3m
Enroll For Free