• رقم الدرس : 32
  • 00:16:00

  • 031-Oracle SQL 12c: Self join and more examples

  • تشغيل

دروس الكورس

  1. 1- 001-Oracle SQL 12c: Before You Start
  2. 2- 002-Oracle SQL 12c: Course Agenda
  3. 3- 003-Oracle SQL 12c: Introduction Part 1
  4. 4- 004-Oracle SQL 12c: Introduction Part 2
  5. 5- 004.1- Oracle SQL 12c: Oracle history and 12c Architecture
  6. 6- 005-Oracle SQL 12c: Installing oracle 12c on windows
  7. 7- 006-Oracle SQL 12c: First connection and unlock HR account 1
  8. 8- 007-Oracle SQL 12c: First connection and unlock HR account 2
  9. 9- 008-Oracle SQL 12c: Basic Select Part 1
  10. 10- 009-Oracle SQL 12c: Basic Select Part 2
  11. 11- 010-Oracle SQL 12c: Restricting and Sorting part 1
  12. 12- 011-Oracle SQL 12c: Restricting and Sorting part 2
  13. 13- 012-Oracle SQL 12c: Restricting and Sorting part 3
  14. 14- 013-Oracle SQL 12c: Restricting and Sorting part 4
  15. 15- 014-Oracle SQL 12c: Substitution variables part 1
  16. 16- 015-Oracle SQL 12c: Substitution variables part 2
  17. 17- 016-Oracle SQL 12c: Character functions
  18. 18- 017-Oracle SQL 12c: Number functions
  19. 19- 018-Oracle SQL 12c: Date functions
  20. 20- 019-Oracle SQL 12c: Using Conversion Functions 1
  21. 21- 020-Oracle SQL 12c: Using Conversion Functions 2
  22. 22- 021-Oracle SQL 12c: Using Conversion Functions 3
  23. 23- 022-Oracle SQL 12c: Using Conversion Functions 4
  24. 24- 023-Oracle SQL 12c: Using Conversion Functions 5
  25. 25- 024-Oracle SQL 12c: Using the Group Functions 1
  26. 26- 025-Oracle SQL 12c: Using the Group Functions 2
  27. 27- 026-Oracle SQL 12c: What is joins and Cartesian Products?
  28. 28- 027-Oracle SQL 12c: Types of Joins
  29. 29- 028-Oracle SQL 12c: Equijoin
  30. 30- 029-Oracle SQL 12c: Nonequijoins
  31. 31- 030-Oracle SQL 12c: Outer Join
  32. 32- 031-Oracle SQL 12c: Self join and more examples
  33. 33- 032-Oracle SQL 12c: 1999 Join syntax part 1
  34. 34- 033-Oracle SQL 12c: 1999 Join syntax part 2
  35. 35- 034-Oracle SQL 12c: 1999 Join syntax part 3
  36. 36- 035-Oracle SQL 12c: Using Subqueries to Solve Queries 1
  37. 37- 036-Oracle SQL 12c: Using Subqueries to Solve Queries 2
  38. 38- 037-Oracle SQL 12c: Using Subqueries to Solve Queries 3
  39. 39- 038-Oracle SQL 12c: Using Subqueries to Solve Queries 4
  40. 40- 039-Oracle SQL 12c: Using the Set Operators part 1
  41. 41- 040-Oracle SQL 12c: Using the Set Operators part 2
  42. 42- 041-Oracle SQL 12c: What is DML and insert rules
  43. 43- 042-Oracle SQL 12c: Insert statement
  44. 44- 043-Oracle SQL 12c: Common errors insert and creating script
  45. 45- 044-Oracle SQL 12c: Update statement part 1
  46. 46- 045-Oracle SQL 12c: Update statement part 2
  47. 47- 046-Oracle SQL 12c: Delete statement part 1
  48. 48- 047-Oracle SQL 12c: Delete statement part 2
  49. 49- 048-Oracle SQL 12c: Commit and rollback
  50. 50- 049-Oracle SQL 12c: Read Consistency
  51. 51- 050-Oracle SQL 12c: DML Practice part 1
  52. 52- 051-Oracle SQL 12c: DML Practice part 2
  53. 53- 052-Oracle SQL 12c: DML Practice part 3
  54. 54- 053-Oracle SQL 12c: DB objects and data types
  55. 55- 054-Oracle SQL 12c: Schema and create table syntax
  56. 56- 055-Oracle SQL 12c: Including Constraints part 1
  57. 57- 056-Oracle SQL 12c: Including Constraints part 2
  58. 58- 057-Oracle SQL 12c: Create table practice 1
  59. 59- 058-Oracle SQL 12c: Create table practice 2
  60. 60- 059-Oracle SQL 12c: Creating table using subquery
  61. 61- 060-Oracle SQL 12c: Alter table statement
  62. 62- 061-Oracle SQL 12c: Set unused option -read only- drop table
  63. 63- 062-Oracle SQL 12c: Very nice DDL practice 1
  64. 64- 063-Oracle SQL 12c: Very nice DDL practice 2
  65. 65- 064-Oracle SQL 12c: Alter table and constraints
  66. 66- 065-Oracle SQL 12c: Tips you should know part 1
  67. 67- 066-Oracle SQL 12c: Tips you should know part 2
  68. 68- 067-Oracle SQL 12c: Tips you should know part 3
  69. 69- 068-Oracle SQL 12c: You are ready for EXAM 1Z0-061
  70. 70- 069-Oracle SQL 12c: Data Dictionary Views part 1
  71. 71- 070-Oracle SQL 12c: Data Dictionary Views part 2
  72. 72- 071-Oracle SQL 12c: Data Dictionary Views part 3
  73. 73- 072-Oracle SQL 12c: Data Dictionary Views part 4
  74. 74- 073-Oracle SQL 12c: Creating Sequences part 1
  75. 75- 074-Oracle SQL 12c: Creating Sequences part 2
  76. 76- 075-Oracle SQL 12c: Sequences practice 1
  77. 77- 076-Oracle SQL 12c: Sequences practice 2
  78. 78- 077-Oracle SQL 12c: Creating Synonyms
  79. 79- 078-Oracle SQL 12c: Creating Indexes Part 1
  80. 80- 079-Oracle SQL 12c: Creating Indexes Part 2
  81. 81- 080-Oracle SQL 12c: Indexes Practice/ تماربن الوحوش
  82. 82- 081-Oracle SQL 12c: Creating Views part 1
  83. 83- 082-Oracle SQL 12c: Creating Views part 2
  84. 84- 083-Oracle SQL 12c: Creating Views part 3/اعطيني عملي يابا
  85. 85- 084-Oracle SQL 12c: Creating Views part 4/هيك صح
  86. 86- 085-Oracle SQL 12c: Managing constraints Part 1/جميل
  87. 87- 086-Oracle SQL 12c: Managing constraints Part 2
  88. 88- 087-Oracle SQL 12c: DEFERRABLE Constraints/ هاي حلوه
  89. 89- 088-Oracle SQL 12c: Global Temporary Table
  90. 90- 089-Oracle SQL 12c: SQL Loader
  91. 91- 090-Oracle SQL 12c: External Tables Part 1
  92. 92- 091-Oracle SQL 12c: External Tables Part 2/ يا سلام
  93. 93- 092-Oracle SQL 12c: Subquery as a source table/ خد مثال حقيقي
  94. 94- 093-Oracle SQL 12c: Multiple Column Subquery / لقد وقعنا في الفخ
  95. 95- 094- Oracle SQL 12c: Scalar Subquery
  96. 96- 095- Oracle SQL 12c: Correlated Subquery / Exists /not exists
  97. 97- 096- Oracle SQL 12c: With Clause / اول مره اعرف
  98. 98- 097- Oracle SQL 12c: Manipulating Data by Using Subqueries
  99. 99- 098- Oracle SQL 12c: Controlling User Access part 1/نظري
  100. 100- 099- Oracle SQL 12c: Controlling User Access part 2/نظري
  101. 101- 100- Oracle SQL 12c: Controlling User Access part 3/نظري
  102. 102- 101- Oracle SQL 12c: Controlling User Access part 4/عملي
  103. 103- 102- Oracle SQL 12c: Controlling User Access part 5/عملي
  104. 104- 103- Oracle SQL 12c: Controlling User Access part 6/عملي
  105. 105- 104- Oracle SQL 12c: Controlling User Access part 7/عملي
  106. 106- 105- Oracle SQL 12c: Controlling User Access part 8/عملي
  107. 107- 106- Oracle SQL 12c: Manipulating Data- Introduction
  108. 108- 107- Oracle SQL 12c: Manipulating Data- Explicit default value
  109. 109- 108- Oracle SQL 12c: Manipulating Data- INSERT ALL
  110. 110- 109- Oracle SQL 12c: Manipulating Data- Pivoting Insert
  111. 111- 110- Oracle SQL 12c: Manipulating Data- Merge Statement 1
  112. 112- 111- Oracle SQL 12c: Manipulating Data- Merge Statement 2
  113. 113- 112- Oracle SQL 12c: Manipulating Data- Flashback Statement
  114. 114- 113- Oracle SQL 12c: Managing Data in Different Time Zones 1
  115. 115- 114- Oracle SQL 12c: Managing Data in Different Time Zones 2
  116. 116- 115- Oracle SQL 12c: The End- Thank You