589689.xyz

[] Udemy - The Complete Oracle SQL Certification Course

  • 收录时间:2021-09-01 21:55:22
  • 文件大小:6GB
  • 下载次数:1
  • 最近下载:2021-09-01 21:55:22
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.mp4 340MB
  2. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.mp4 226MB
  3. 9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4 214MB
  4. 9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.mp4 177MB
  5. 9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.mp4 168MB
  6. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4 159MB
  7. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp4 146MB
  8. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).mp4 138MB
  9. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp4 137MB
  10. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.mp4 131MB
  11. 6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.mp4 128MB
  12. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp4 127MB
  13. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.mp4 124MB
  14. 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp4 123MB
  15. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4 123MB
  16. 6. Analytical Functions using OVER and PARTITION with ORDER BY/1. OVER Clause with PARTITION BY.mp4 118MB
  17. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp4 117MB
  18. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. MERGE Statement in Oracle.mp4 117MB
  19. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.mp4 115MB
  20. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.mp4 114MB
  21. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp4 114MB
  22. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp4 110MB
  23. 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp4 110MB
  24. 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp4 110MB
  25. 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp4 110MB
  26. 6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.mp4 108MB
  27. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.mp4 108MB
  28. 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp4 105MB
  29. 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp4 103MB
  30. 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4 101MB
  31. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.mp4 100MB
  32. 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp4 99MB
  33. 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp4 99MB
  34. 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp4 97MB
  35. 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.mp4 95MB
  36. 10. APPENDIX - Installing Oracle on Windows/2. Install Oracle SQL Developer in Windows.mp4 95MB
  37. 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp4 94MB
  38. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.mp4 80MB
  39. 10. APPENDIX - Installing Oracle on Windows/1. Install Oracle Database 19c in Windows.mp4 79MB
  40. 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp4 78MB
  41. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.mp4 77MB
  42. 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp4 68MB
  43. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.mp4 66MB
  44. 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp4 65MB
  45. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. Sequence Statements.mp4 65MB
  46. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.mp4 62MB
  47. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. CASE Statements.mp4 62MB
  48. 6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.mp4 61MB
  49. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5. SELF JOIN.mp4 59MB
  50. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.mp4 54MB
  51. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4 53MB
  52. 1. Database Basics/2. Creating the Workspace in Oracle.mp4 50MB
  53. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. EQUIJOIN and NON-EQUIJOINs.mp4 46MB
  54. 6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.mp4 45MB
  55. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.mp4 39MB
  56. 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp4 25MB
  57. 1. Database Basics/3. IMPORTANT Prepare the Sample Data.mp4 24MB
  58. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.srt 54KB
  59. 9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.srt 49KB
  60. 9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.srt 42KB
  61. 9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.srt 41KB
  62. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).srt 34KB
  63. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).srt 33KB
  64. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.srt 33KB
  65. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).srt 33KB
  66. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.srt 31KB
  67. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.srt 30KB
  68. 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.srt 30KB
  69. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.srt 30KB
  70. 6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.srt 29KB
  71. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.srt 29KB
  72. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.srt 29KB
  73. 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.srt 28KB
  74. 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.srt 28KB
  75. 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.srt 28KB
  76. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.srt 28KB
  77. 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.srt 28KB
  78. 6. Analytical Functions using OVER and PARTITION with ORDER BY/1. OVER Clause with PARTITION BY.srt 28KB
  79. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.srt 27KB
  80. 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.srt 27KB
  81. 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..srt 27KB
  82. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.srt 27KB
  83. 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.srt 27KB
  84. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.srt 27KB
  85. 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.srt 27KB
  86. 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.srt 27KB
  87. 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.srt 26KB
  88. 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.srt 26KB
  89. 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.srt 26KB
  90. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.srt 26KB
  91. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.srt 24KB
  92. 6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.srt 24KB
  93. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. MERGE Statement in Oracle.srt 23KB
  94. 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.srt 23KB
  95. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.srt 23KB
  96. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.srt 23KB
  97. 10. APPENDIX - Installing Oracle on Windows/2. Install Oracle SQL Developer in Windows.srt 22KB
  98. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.srt 20KB
  99. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.srt 20KB
  100. 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.srt 20KB
  101. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. Sequence Statements.srt 18KB
  102. 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.srt 18KB
  103. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5. SELF JOIN.srt 17KB
  104. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.srt 17KB
  105. 10. APPENDIX - Installing Oracle on Windows/1. Install Oracle Database 19c in Windows.srt 16KB
  106. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.srt 16KB
  107. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. EQUIJOIN and NON-EQUIJOINs.srt 14KB
  108. 6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.srt 14KB
  109. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.srt 13KB
  110. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.srt 12KB
  111. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. CASE Statements.srt 12KB
  112. 1. Database Basics/2. Creating the Workspace in Oracle.srt 10KB
  113. 6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.srt 10KB
  114. 1. Database Basics/3. IMPORTANT Prepare the Sample Data.srt 6KB
  115. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.2 merge_sql_example.txt 3KB
  116. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3.1 Code for Create Table With Primary Key Constraint.txt 2KB
  117. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt 2KB
  118. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Primary and Foreign Keys.html 2KB
  119. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt 1KB
  120. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/14. SQL could be tricky, check this out!.html 1KB
  121. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3.1 Code for JOINS Continued INNER & OUTER Joins.txt 1KB
  122. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2.1 Code for Relating Tables together using JOINs .txt 1KB
  123. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt 1KB
  124. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4.1 Code for More JOINS with Correlated Subqueries .txt 1KB
  125. 3. Single Row Functions (Exercises and Solutions In the Lectures)/3.1 Code for Numeric and Date Datatype SRFs.txt 1KB
  126. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.1 Code for MERGE Statement.txt 1KB
  127. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7.1 code for external tables.txt 1KB
  128. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4.1 Code for Multi-Table Insert Using INSERT ALL.txt 1KB
  129. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/17. Bonus Lecture Lifetime Access to All My Courses.html 995B
  130. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2.1 Code for Inserting Data Into our Table.txt 984B
  131. 4. Grouping Functions (Exercises and Solutions In the Lectures)/1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt 865B
  132. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5.1 code for cascade constraints.txt 798B
  133. 3. Single Row Functions (Exercises and Solutions In the Lectures)/6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt 778B
  134. 1. Database Basics/3.1 course_data.txt 764B
  135. 3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html 723B
  136. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6.1 Code for Create Table with SELECT and UPDATE existing Data.txt 706B
  137. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/16. BECOME A SQL QUERY WIZARD!.html 704B
  138. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5.1 Code for Alter Table and Modify Column Attributes.txt 690B
  139. 2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html 688B
  140. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11.1 Code for Database Indexes.txt 601B
  141. 3. Single Row Functions (Exercises and Solutions In the Lectures)/4.1 Code for Conversion SRFs & Date Formatting.txt 528B
  142. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7.1 Code for EQUI and NON-EQUI Joins.txt 421B
  143. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10.1 Code for Delete, Truncate and Drop Commands.txt 397B
  144. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8.1 Code for CASE Statement.txt 379B
  145. 2. Single Table Queries (Exercises & Solutions in the Lectures)/8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt 331B
  146. 2. Single Table Queries (Exercises & Solutions in the Lectures)/7.1 Code for Query Filtering Conditions & Operator Precedence.txt 326B
  147. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9.1 Code for Sequence Statements.txt 315B
  148. 3. Single Row Functions (Exercises and Solutions In the Lectures)/1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt 295B
  149. 2. Single Table Queries (Exercises & Solutions in the Lectures)/6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt 281B
  150. 3. Single Row Functions (Exercises and Solutions In the Lectures)/2.1 Code for Using Functions in WHERE and Character Based SRFs.txt 281B
  151. 2. Single Table Queries (Exercises & Solutions in the Lectures)/4.1 Code for Using Operators in the WHERE Clause.txt 277B
  152. 4. Grouping Functions (Exercises and Solutions In the Lectures)/2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt 200B
  153. 2. Single Table Queries (Exercises & Solutions in the Lectures)/5.1 Code for Combining WHERE, AND & OR Operators.txt 199B
  154. 2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Practice with single table queries.html 159B
  155. 3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Practice with Single Row Functions.html 159B
  156. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1.1 Code for Creating Your Own Tables & Design Considerations.txt 158B
  157. 9. Exam Question Walkthrough Videos + 2 Exams/4. Practice Test 1.html 155B
  158. 9. Exam Question Walkthrough Videos + 2 Exams/5. Practice Test 2.html 155B
  159. 2. Single Table Queries (Exercises & Solutions in the Lectures)/2.1 Code for Select Clause.txt 132B
  160. 2. Single Table Queries (Exercises & Solutions in the Lectures)/3.1 Code for WHERE Clause.txt 130B
  161. 4. Grouping Functions (Exercises and Solutions In the Lectures)/3.1 Code for More Practice with the GROUP BY Clause.txt 98B
  162. 0. Websites you may like/[DesireCourse.Net].url 51B
  163. 1. Database Basics/[DesireCourse.Net].url 51B
  164. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/[DesireCourse.Net].url 51B
  165. 9. Exam Question Walkthrough Videos + 2 Exams/[DesireCourse.Net].url 51B
  166. [DesireCourse.Net].url 51B
  167. 0. Websites you may like/[CourseClub.Me].url 48B
  168. 1. Database Basics/[CourseClub.Me].url 48B
  169. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/[CourseClub.Me].url 48B
  170. 9. Exam Question Walkthrough Videos + 2 Exams/[CourseClub.Me].url 48B
  171. [CourseClub.Me].url 48B