589689.xyz

[] Udemy - Advanced SQL SQL Expert Certification Preparation Course

  • 收录时间:2019-12-08 12:35:27
  • 文件大小:2GB
  • 下载次数:8
  • 最近下载:2021-01-20 16:15:39
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 2. Software Installation/2. Which Option to Have a Database.mp4 83MB
  2. 2. Software Installation/7. The Sample (HR) Schema Used in This Course.vtt 76MB
  3. 2. Software Installation/7. The Sample (HR) Schema Used in This Course.mp4 76MB
  4. 1. Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.mp4 51MB
  5. 2. Software Installation/1. About the Installation.mp4 50MB
  6. 2. Software Installation/5. Option 3 Using Oracle Live SQL.mp4 43MB
  7. 2. Software Installation/3. Option 1 Having The Database with Oracle VirtualBox.mp4 37MB
  8. 4. Data Dictionary Views/8. User Constraints View.mp4 34MB
  9. 16. Regular Expressions/2. What Are Metacharacters.mp4 31MB
  10. 11. Advanced Data Manipulations/8. Flashback Operations.mp4 30MB
  11. 11. Advanced Data Manipulations/7. Merging Data.mp4 29MB
  12. 2. Software Installation/4. Option 2 Downloading And Installing Oracle Database.mp4 28MB
  13. 8. Managing Views/8. Using WITH CHECK OPTION Clause.mp4 28MB
  14. 12. Constraints (Controlling Schema Objects)/9. Deferring Constraints.mp4 28MB
  15. 4. Data Dictionary Views/5. USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views.mp4 27MB
  16. 2. Software Installation/8. Configuring and Using SQL Developer.mp4 27MB
  17. 17. Analytical SQL Functions/1. What are the Analytic Functions.mp4 26MB
  18. 10. Using Advanced Subqueries/2. Scalar Subqueries.vtt 25MB
  19. 10. Using Advanced Subqueries/2. Scalar Subqueries.mp4 25MB
  20. 8. Managing Views/3. Creating Simple Views.mp4 24MB
  21. 13. Administering User Privileges and Roles/8. Granting Object Privileges.mp4 23MB
  22. 9. Materialized Views/6. Refreshing Materialized Views Manually.mp4 23MB
  23. 11. Advanced Data Manipulations/4. Conditional Insert Statements.mp4 23MB
  24. 9. Materialized Views/5. Types of Refreshing Materialized Views.mp4 21MB
  25. 12. Constraints (Controlling Schema Objects)/3. On Delete CASCADE & On Delete SET NULL.mp4 21MB
  26. 12. Constraints (Controlling Schema Objects)/10. Creating Temporary Tables.mp4 20MB
  27. 4. Data Dictionary Views/6. USER_TABLES View.mp4 19MB
  28. 3. Introducing Database Objects/1. Introducing Database Objects and Reaching Another User's Objects.mp4 19MB
  29. 17. Analytical SQL Functions/5. Windowing Clause in Analytic Functions - Part 1.mp4 19MB
  30. 10. Using Advanced Subqueries/9. Inserting Data By Using a Subquery as a Target.mp4 18MB
  31. 12. Constraints (Controlling Schema Objects)/1. Adding Constraints.mp4 18MB
  32. 16. Regular Expressions/5. Using REGEXP_REPLACE() Function.mp4 17MB
  33. 5. Creating, Using and Managing Sequences/5. Using Sequences.mp4 17MB
  34. 10. Using Advanced Subqueries/12. Correlated Update.mp4 17MB
  35. 16. Regular Expressions/6. Using REGEXP_SUBSTR() Function.mp4 17MB
  36. 7. Understanding Indexes/6. Multiple Indexes With Same Columns.mp4 16MB
  37. 7. Understanding Indexes/3. Creating Indexes.mp4 16MB
  38. 6. Creating, Using and Analyzing Synonyms/2. Creating & Dropping Synonyms.mp4 15MB
  39. 8. Managing Views/7. Performing DML Operations with Views.mp4 15MB
  40. 17. Analytical SQL Functions/6. Windowing Clause in Analytic Functions - Part 2.mp4 15MB
  41. 10. Using Advanced Subqueries/10. Manipulating Data by Using WITH CHECK OPTION Keyword.mp4 15MB
  42. 10. Using Advanced Subqueries/3. Multiple Column Subqueries.mp4 15MB
  43. 13. Administering User Privileges and Roles/4. Granting System Privileges.mp4 15MB
  44. 14. Hierarchical Queries (Tree Structure)/3. Walking On The Tree (Bottom to Up - Up to Down).mp4 14MB
  45. 11. Advanced Data Manipulations/11. FLASHBACK Query.mp4 14MB
  46. 7. Understanding Indexes/8. USER_INDEXES and USER_IND_COLUMNS Views.mp4 14MB
  47. 15. Generating Dynamic SQL Scripts/1. Generating Scripts By Using Data Dictionary Views.mp4 14MB
  48. 13. Administering User Privileges and Roles/10. Searching For Privileges in Data Dictionary Views.mp4 14MB
  49. 9. Materialized Views/2. Creating Materialized Views Part 1.mp4 14MB
  50. 7. Understanding Indexes/4. Creating Index on Table Creation.mp4 14MB
  51. 17. Analytical SQL Functions/4. LEAD & LAG Analytic Functions (Next & Previous Values).mp4 14MB
  52. 10. Using Advanced Subqueries/5. EXISTS Operator.mp4 13MB
  53. 5. Creating, Using and Managing Sequences/2. Creating Sequences.mp4 13MB
  54. 3. Introducing Database Objects/2. Reaching Another User's Objects.mp4 13MB
  55. 11. Advanced Data Manipulations/1. Using DEFAULT Keyword on Insert And Update Statements.mp4 13MB
  56. 4. Data Dictionary Views/9. USER_CONS_COLUMNS View.mp4 13MB
  57. 11. Advanced Data Manipulations/3. Unconditional Insert Statements.mp4 13MB
  58. 10. Using Advanced Subqueries/7. Using WITH Clause.mp4 13MB
  59. 4. Data Dictionary Views/7. USER_TAB_COLUMNS View.mp4 13MB
  60. 13. Administering User Privileges and Roles/6. Changing The User Password.mp4 12MB
  61. 10. Using Advanced Subqueries/1. Using Subqueries as a Source.mp4 12MB
  62. 17. Analytical SQL Functions/3. RANK and DENSE_RANK Analytic Functions.mp4 12MB
  63. 16. Regular Expressions/4. Using REGEXP_LIKE() function.mp4 12MB
  64. 16. Regular Expressions/7. Using REGEXP_INSTR() Function.mp4 11MB
  65. 9. Materialized Views/1. What is a Materialized View and Why is it Used For.mp4 11MB
  66. 17. Analytical SQL Functions/8. FIRST_VALUE and LAST_VALUE Analytic Functions.mp4 11MB
  67. 11. Advanced Data Manipulations/9. Purge Operations.mp4 11MB
  68. 9. Materialized Views/4. Complex Materialized Views.mp4 11MB
  69. 11. Advanced Data Manipulations/5. Conditional Insert First Statements.mp4 11MB
  70. 10. Using Advanced Subqueries/6. NOT EXISTS Operator.mp4 11MB
  71. 10. Using Advanced Subqueries/8. Using Recursive WITH Clause.mp4 10MB
  72. 4. Data Dictionary Views/10. USER_TAB_COMMENTS & USER_COL_COMMENTS Views.mp4 10MB
  73. 17. Analytical SQL Functions/2. ROW_NUMBER Analytic Function.mp4 10MB
  74. 9. Materialized Views/3. Creating Materialized Views Part 2.mp4 10MB
  75. 14. Hierarchical Queries (Tree Structure)/2. Generating Hierarchical Queries.mp4 10MB
  76. 11. Advanced Data Manipulations/12. FLASHBACK VERSIONS Query.mp4 10MB
  77. 8. Managing Views/6. Analyzing User Views.mp4 9MB
  78. 10. Using Advanced Subqueries/11. Correlated Delete.mp4 9MB
  79. 10. Using Advanced Subqueries/4. Correlated Subqueries.mp4 9MB
  80. 16. Regular Expressions/9. Using REGEX in Constraints.mp4 9MB
  81. 6. Creating, Using and Analyzing Synonyms/4. Analyzing USER_SYNONYMS.mp4 9MB
  82. 16. Regular Expressions/8. Using REGEXP_COUNT() Function.mp4 9MB
  83. 4. Data Dictionary Views/3. Dictionary Table.mp4 9MB
  84. 7. Understanding Indexes/5. Function Based Indexes.mp4 8MB
  85. 14. Hierarchical Queries (Tree Structure)/6. Pruning Branches Of a Tree.mp4 8MB
  86. 8. Managing Views/4. Creating Complex Views.mp4 8MB
  87. 5. Creating, Using and Managing Sequences/6. Using Sequences As a Default Value.mp4 8MB
  88. 13. Administering User Privileges and Roles/5. What is A Role and Why is It Used For.mp4 8MB
  89. 12. Constraints (Controlling Schema Objects)/4. Cascading Constraints.mp4 8MB
  90. 11. Advanced Data Manipulations/6. Pivoting Insert.mp4 8MB
  91. 14. Hierarchical Queries (Tree Structure)/5. Formatting Tree Structure (LEVEL & LPAD).mp4 8MB
  92. 14. Hierarchical Queries (Tree Structure)/4. Ranking Rows (Using LEVEL Pseudocolumn).mp4 8MB
  93. 13. Administering User Privileges and Roles/2. Creating A User.mp4 8MB
  94. 13. Administering User Privileges and Roles/3. System Privileges.mp4 8MB
  95. 12. Constraints (Controlling Schema Objects)/2. Removing Constraints.mp4 8MB
  96. 17. Analytical SQL Functions/7. INTERVAL Keyword In Analytic Functions.mp4 7MB
  97. 8. Managing Views/5. Modifying Views.mp4 7MB
  98. 12. Constraints (Controlling Schema Objects)/5. Renaming Constraints.mp4 7MB
  99. 13. Administering User Privileges and Roles/9. Revoking Object Privileges.mp4 6MB
  100. 17. Analytical SQL Functions/9. Selecting Top-N Rows with Analytic Functions.mp4 6MB
  101. 6. Creating, Using and Analyzing Synonyms/3. Using Synonyms.mp4 6MB
  102. 16. Regular Expressions/1. What is Regular Expressions and Why and Where Do We Use Them.mp4 6MB
  103. 12. Constraints (Controlling Schema Objects)/8. Status Of Constraints.mp4 6MB
  104. 12. Constraints (Controlling Schema Objects)/6. Disabling Constraints.mp4 6MB
  105. 5. Creating, Using and Managing Sequences/3. Modifying Sequences.mp4 6MB
  106. 7. Understanding Indexes/7. Dropping Indexes.mp4 6MB
  107. 8. Managing Views/9. Preventing DML Operations on A View.mp4 6MB
  108. 8. Managing Views/1. What is a View and Why Is It Used For.mp4 6MB
  109. 7. Understanding Indexes/1. What is an Index and Why is It Used For.mp4 6MB
  110. 13. Administering User Privileges and Roles/1. What Are Privileges And Why Are They Used For.mp4 6MB
  111. 14. Hierarchical Queries (Tree Structure)/1. Understanding Hierarchical Retrieval.mp4 6MB
  112. 5. Creating, Using and Managing Sequences/8. User Sequences.mp4 6MB
  113. 16. Regular Expressions/3. Regular Expression Functions.mp4 6MB
  114. 7. Understanding Indexes/2. Types of Indexes.mp4 5MB
  115. 12. Constraints (Controlling Schema Objects)/7. Enabling Constraints.mp4 5MB
  116. 13. Administering User Privileges and Roles/7. Object Privileges.mp4 5MB
  117. 6. Creating, Using and Analyzing Synonyms/1. What Is a Synonym and Why Is It Used For.mp4 5MB
  118. 9. Materialized Views/7. Scheduling Periodic Refresh of Materialized Views.mp4 4MB
  119. 5. Creating, Using and Managing Sequences/7. Sequence Caching.mp4 4MB
  120. 8. Managing Views/2. Types Of Views.mp4 4MB
  121. 1. Course Introduction/1. Introduction.mp4 4MB
  122. 8. Managing Views/10. Dropping Views.mp4 4MB
  123. 11. Advanced Data Manipulations/2. Multitable Insert Statements.mp4 3MB
  124. 11. Advanced Data Manipulations/10. Tracking Changes In Data In a Particular Time.mp4 3MB
  125. 4. Data Dictionary Views/4. Differences Between USER, ALL, DBA, V$ Prefixes.mp4 3MB
  126. 5. Creating, Using and Managing Sequences/4. Dropping Sequences.mp4 3MB
  127. 5. Creating, Using and Managing Sequences/1. What is a Sequence and Why is It Used For.mp4 3MB
  128. 4. Data Dictionary Views/1. What Are Data Dictionary Views.mp4 2MB
  129. 4. Data Dictionary Views/2. What Is There In Data Dictionary Views.mp4 2MB
  130. 2. Software Installation/3.6 Advanced-SQL-Changing-Virtual-Machine-Keyboard-Input-Settings.pdf.pdf 774KB
  131. 16. Regular Expressions/2.1 Metacharacters Chart.pdf.pdf 745KB
  132. 18. Bonus(+) Section/1.1 Special Discounts For Our Students.xlsx.xlsx 35KB
  133. 2. Software Installation/3.3 advanced sql scripts.sql.sql 23KB
  134. 3. Introducing Database Objects/5. Code Samples.html 23KB
  135. 2. Software Installation/8. Configuring and Using SQL Developer.vtt 19KB
  136. 8. Managing Views/8. Using WITH CHECK OPTION Clause.vtt 15KB
  137. 8. Managing Views/3. Creating Simple Views.vtt 15KB
  138. 16. Regular Expressions/2. What Are Metacharacters.vtt 14KB
  139. 4. Data Dictionary Views/5. USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views.vtt 13KB
  140. 2. Software Installation/3. Option 1 Having The Database with Oracle VirtualBox.vtt 13KB
  141. 2. Software Installation/2. Which Option to Have a Database.vtt 12KB
  142. 7. Understanding Indexes/6. Multiple Indexes With Same Columns.vtt 11KB
  143. 3. Introducing Database Objects/1. Introducing Database Objects and Reaching Another User's Objects.vtt 10KB
  144. 11. Advanced Data Manipulations/8. Flashback Operations.vtt 10KB
  145. 4. Data Dictionary Views/8. User Constraints View.vtt 10KB
  146. 6. Creating, Using and Analyzing Synonyms/2. Creating & Dropping Synonyms.vtt 10KB
  147. 2. Software Installation/4. Option 2 Downloading And Installing Oracle Database.vtt 9KB
  148. 13. Administering User Privileges and Roles/8. Granting Object Privileges.vtt 9KB
  149. 17. Analytical SQL Functions/5. Windowing Clause in Analytic Functions - Part 1.vtt 9KB
  150. 9. Materialized Views/5. Types of Refreshing Materialized Views.vtt 9KB
  151. 12. Constraints (Controlling Schema Objects)/9. Deferring Constraints.vtt 9KB
  152. 10. Using Advanced Subqueries/5. EXISTS Operator.vtt 9KB
  153. 3. Introducing Database Objects/2. Reaching Another User's Objects.vtt 8KB
  154. 7. Understanding Indexes/5. Function Based Indexes.vtt 8KB
  155. 16. Regular Expressions/6. Using REGEXP_SUBSTR() Function.vtt 8KB
  156. 8. Managing Views/7. Performing DML Operations with Views.vtt 8KB
  157. 5. Creating, Using and Managing Sequences/5. Using Sequences.vtt 8KB
  158. 11. Advanced Data Manipulations/7. Merging Data.vtt 7KB
  159. 2. Software Installation/5. Option 3 Using Oracle Live SQL.vtt 7KB
  160. 11. Advanced Data Manipulations/4. Conditional Insert Statements.vtt 7KB
  161. 12. Constraints (Controlling Schema Objects)/1. Adding Constraints.vtt 7KB
  162. 4. Data Dictionary Views/7. USER_TAB_COLUMNS View.vtt 7KB
  163. 12. Constraints (Controlling Schema Objects)/10. Creating Temporary Tables.vtt 7KB
  164. 14. Hierarchical Queries (Tree Structure)/3. Walking On The Tree (Bottom to Up - Up to Down).vtt 6KB
  165. 5. Creating, Using and Managing Sequences/2. Creating Sequences.vtt 6KB
  166. 7. Understanding Indexes/3. Creating Indexes.vtt 6KB
  167. 10. Using Advanced Subqueries/1. Using Subqueries as a Source.vtt 6KB
  168. 9. Materialized Views/2. Creating Materialized Views Part 1.vtt 6KB
  169. 10. Using Advanced Subqueries/3. Multiple Column Subqueries.vtt 6KB
  170. 5. Creating, Using and Managing Sequences/6. Using Sequences As a Default Value.vtt 6KB
  171. 10. Using Advanced Subqueries/10. Manipulating Data by Using WITH CHECK OPTION Keyword.vtt 6KB
  172. 6. Creating, Using and Analyzing Synonyms/4. Analyzing USER_SYNONYMS.vtt 6KB
  173. 6. Creating, Using and Analyzing Synonyms/1. What Is a Synonym and Why Is It Used For.vtt 6KB
  174. 13. Administering User Privileges and Roles/4. Granting System Privileges.vtt 6KB
  175. 7. Understanding Indexes/8. USER_INDEXES and USER_IND_COLUMNS Views.vtt 6KB
  176. 10. Using Advanced Subqueries/9. Inserting Data By Using a Subquery as a Target.vtt 6KB
  177. 17. Analytical SQL Functions/8. FIRST_VALUE and LAST_VALUE Analytic Functions.vtt 6KB
  178. 16. Regular Expressions/7. Using REGEXP_INSTR() Function.vtt 6KB
  179. 4. Data Dictionary Views/6. USER_TABLES View.vtt 6KB
  180. 9. Materialized Views/1. What is a Materialized View and Why is it Used For.vtt 5KB
  181. 1. Course Introduction/2. UDEMY 101 How to Use Udemy +Some Useful Tips.vtt 5KB
  182. 6. Creating, Using and Analyzing Synonyms/3. Using Synonyms.vtt 5KB
  183. 11. Advanced Data Manipulations/1. Using DEFAULT Keyword on Insert And Update Statements.vtt 5KB
  184. 11. Advanced Data Manipulations/3. Unconditional Insert Statements.vtt 5KB
  185. 7. Understanding Indexes/2. Types of Indexes.vtt 5KB
  186. 7. Understanding Indexes/7. Dropping Indexes.vtt 5KB
  187. 8. Managing Views/4. Creating Complex Views.vtt 5KB
  188. 10. Using Advanced Subqueries/12. Correlated Update.vtt 5KB
  189. 11. Advanced Data Manipulations/11. FLASHBACK Query.vtt 5KB
  190. 17. Analytical SQL Functions/3. RANK and DENSE_RANK Analytic Functions.vtt 5KB
  191. 10. Using Advanced Subqueries/7. Using WITH Clause.vtt 5KB
  192. 13. Administering User Privileges and Roles/6. Changing The User Password.vtt 5KB
  193. 5. Creating, Using and Managing Sequences/3. Modifying Sequences.vtt 5KB
  194. 7. Understanding Indexes/1. What is an Index and Why is It Used For.vtt 5KB
  195. 11. Advanced Data Manipulations/5. Conditional Insert First Statements.vtt 5KB
  196. 16. Regular Expressions/4. Using REGEXP_LIKE() function.vtt 5KB
  197. 4. Data Dictionary Views/10. USER_TAB_COMMENTS & USER_COL_COMMENTS Views.vtt 5KB
  198. 5. Creating, Using and Managing Sequences/8. User Sequences.vtt 5KB
  199. 2. Software Installation/1. About the Installation.vtt 5KB
  200. 8. Managing Views/5. Modifying Views.vtt 5KB
  201. 9. Materialized Views/3. Creating Materialized Views Part 2.vtt 5KB
  202. 11. Advanced Data Manipulations/12. FLASHBACK VERSIONS Query.vtt 4KB
  203. 10. Using Advanced Subqueries/6. NOT EXISTS Operator.vtt 4KB
  204. 8. Managing Views/9. Preventing DML Operations on A View.vtt 4KB
  205. 15. Generating Dynamic SQL Scripts/1. Generating Scripts By Using Data Dictionary Views.vtt 4KB
  206. 8. Managing Views/10. Dropping Views.vtt 4KB
  207. 8. Managing Views/6. Analyzing User Views.vtt 4KB
  208. 17. Analytical SQL Functions/9. Selecting Top-N Rows with Analytic Functions.vtt 4KB
  209. 17. Analytical SQL Functions/7. INTERVAL Keyword In Analytic Functions.vtt 4KB
  210. 13. Administering User Privileges and Roles/5. What is A Role and Why is It Used For.vtt 4KB
  211. 4. Data Dictionary Views/3. Dictionary Table.vtt 4KB
  212. 8. Managing Views/2. Types Of Views.vtt 4KB
  213. 17. Analytical SQL Functions/2. ROW_NUMBER Analytic Function.vtt 4KB
  214. 10. Using Advanced Subqueries/4. Correlated Subqueries.vtt 4KB
  215. 16. Regular Expressions/9. Using REGEX in Constraints.vtt 4KB
  216. 12. Constraints (Controlling Schema Objects)/4. Cascading Constraints.vtt 4KB
  217. 11. Advanced Data Manipulations/6. Pivoting Insert.vtt 4KB
  218. 13. Administering User Privileges and Roles/2. Creating A User.vtt 4KB
  219. 14. Hierarchical Queries (Tree Structure)/5. Formatting Tree Structure (LEVEL & LPAD).vtt 4KB
  220. 12. Constraints (Controlling Schema Objects)/2. Removing Constraints.vtt 4KB
  221. 16. Regular Expressions/8. Using REGEXP_COUNT() Function.vtt 4KB
  222. 13. Administering User Privileges and Roles/3. System Privileges.vtt 3KB
  223. 14. Hierarchical Queries (Tree Structure)/6. Pruning Branches Of a Tree.vtt 3KB
  224. 14. Hierarchical Queries (Tree Structure)/4. Ranking Rows (Using LEVEL Pseudocolumn).vtt 3KB
  225. 9. Materialized Views/4. Complex Materialized Views.vtt 3KB
  226. 11. Advanced Data Manipulations/9. Purge Operations.vtt 3KB
  227. 8. Managing Views/1. What is a View and Why Is It Used For.vtt 3KB
  228. 14. Hierarchical Queries (Tree Structure)/2. Generating Hierarchical Queries.vtt 3KB
  229. 13. Administering User Privileges and Roles/9. Revoking Object Privileges.vtt 3KB
  230. 12. Constraints (Controlling Schema Objects)/6. Disabling Constraints.vtt 3KB
  231. 12. Constraints (Controlling Schema Objects)/8. Status Of Constraints.vtt 3KB
  232. 4. Data Dictionary Views/2. What Is There In Data Dictionary Views.vtt 3KB
  233. 12. Constraints (Controlling Schema Objects)/7. Enabling Constraints.vtt 3KB
  234. 14. Hierarchical Queries (Tree Structure)/1. Understanding Hierarchical Retrieval.vtt 3KB
  235. 5. Creating, Using and Managing Sequences/1. What is a Sequence and Why is It Used For.vtt 3KB
  236. 16. Regular Expressions/3. Regular Expression Functions.vtt 3KB
  237. 13. Administering User Privileges and Roles/1. What Are Privileges And Why Are They Used For.vtt 3KB
  238. 4. Data Dictionary Views/4. Differences Between USER, ALL, DBA, V$ Prefixes.vtt 3KB
  239. 16. Regular Expressions/1. What is Regular Expressions and Why and Where Do We Use Them.vtt 3KB
  240. 18. Bonus(+) Section/1. Where to next.html 2KB
  241. 10. Using Advanced Subqueries/11. Correlated Delete.vtt 2KB
  242. 12. Constraints (Controlling Schema Objects)/5. Renaming Constraints.vtt 2KB
  243. 13. Administering User Privileges and Roles/7. Object Privileges.vtt 2KB
  244. 2. Software Installation/9. How to Unlock HR Schema in Oracle.html 2KB
  245. 9. Materialized Views/7. Scheduling Periodic Refresh of Materialized Views.vtt 2KB
  246. 5. Creating, Using and Managing Sequences/4. Dropping Sequences.vtt 2KB
  247. 11. Advanced Data Manipulations/2. Multitable Insert Statements.vtt 2KB
  248. 11. Advanced Data Manipulations/10. Tracking Changes In Data In a Particular Time.vtt 2KB
  249. 1. Course Introduction/1. Introduction.vtt 1KB
  250. 4. Data Dictionary Views/1. What Are Data Dictionary Views.vtt 1KB
  251. 2. Software Installation/6. Option 3 About Oracle Live SQL Restrictions.html 682B
  252. 3. Introducing Database Objects/4. Don't Forget to Leave a Rating!.html 654B
  253. 3. Introducing Database Objects/3. The Working Document.html 627B
  254. 16. Regular Expressions/9.1 Email validation sql script.sql.sql 245B
  255. 2. Software Installation/3.5 Linux Username and Password.txt.txt 185B
  256. 2. Software Installation/3.2 Step 2 Download Virtual Machine Image Link.html 141B
  257. 2. Software Installation/3.4 (Optional) Download Oracle's Virtual Machine (12c Release 2).html 141B
  258. 2. Software Installation/3.1 Step 1 Download Oracle Virtual Box.html 136B
  259. [FreeCourseLab.com].url 126B
  260. 3. Introducing Database Objects/3.1 Working Document Link.html 122B
  261. 10. Using Advanced Subqueries/13. Quiz 8.html 115B
  262. 11. Advanced Data Manipulations/13. Quiz 9.html 115B
  263. 12. Constraints (Controlling Schema Objects)/11. Quiz 10.html 115B
  264. 13. Administering User Privileges and Roles/11. Quiz 11.html 115B
  265. 14. Hierarchical Queries (Tree Structure)/7. Quiz 12.html 115B
  266. 3. Introducing Database Objects/6. Quiz 1.html 115B
  267. 4. Data Dictionary Views/11. Quiz 2.html 115B
  268. 5. Creating, Using and Managing Sequences/9. Quiz 3.html 115B
  269. 6. Creating, Using and Analyzing Synonyms/5. Quiz 4.html 115B
  270. 7. Understanding Indexes/9. Quiz 5.html 115B
  271. 8. Managing Views/11. Quiz 6.html 115B
  272. 9. Materialized Views/8. Quiz 7.html 115B
  273. 2. Software Installation/4.1 Oracle's Official Website.html 84B
  274. 13. Administering User Privileges and Roles/10. Searching For Privileges in Data Dictionary Views.vtt 51B
  275. 10. Using Advanced Subqueries/8. Using Recursive WITH Clause.vtt 50B
  276. 12. Constraints (Controlling Schema Objects)/3. On Delete CASCADE & On Delete SET NULL.vtt 50B
  277. 16. Regular Expressions/5. Using REGEXP_REPLACE() Function.vtt 50B
  278. 17. Analytical SQL Functions/1. What are the Analytic Functions.vtt 50B
  279. 17. Analytical SQL Functions/4. LEAD & LAG Analytic Functions (Next & Previous Values).vtt 50B
  280. 17. Analytical SQL Functions/6. Windowing Clause in Analytic Functions - Part 2.vtt 50B
  281. 4. Data Dictionary Views/9. USER_CONS_COLUMNS View.vtt 50B
  282. 5. Creating, Using and Managing Sequences/7. Sequence Caching.vtt 50B
  283. 7. Understanding Indexes/4. Creating Index on Table Creation.vtt 50B
  284. 9. Materialized Views/6. Refreshing Materialized Views Manually.vtt 50B