589689.xyz

[] Udemy - Oracle SQL - Step by Step SQL

  • 收录时间:2020-07-10 21:00:41
  • 文件大小:1GB
  • 下载次数:9
  • 最近下载:2021-01-04 12:53:25
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 23. Bonus Lets Recap with a 5 Step Process/3. Step 1 Let's Select all the columns needed....mp4 54MB
  2. 21. SUB Queries/7. Correlated SUB Query.mp4 41MB
  3. 21. SUB Queries/1. What is a SUB Query.mp4 32MB
  4. 12. Joining data from 2 or more tables (JOINS)/1. Why Joins.mp4 30MB
  5. 2. Software Installation/3. Installing SQL Developer.mp4 30MB
  6. 21. SUB Queries/4. Sub queries in the FROM clause.mp4 29MB
  7. 2. Software Installation/3. Installing SQL Developer.srt 27MB
  8. 7. Logical Operators/3. LIKE operator.mp4 26MB
  9. 21. SUB Queries/2. Sub queries on multiple columns (Pairwise Comparision).mp4 25MB
  10. 20. Giving Permissions to other users (GRANT)/1. I like him (GRANT).mp4 24MB
  11. 2. Software Installation/2. Installing Java SDK.mp4 24MB
  12. 1. Chapter 1/2. Welcome!!.mp4 23MB
  13. 12. Joining data from 2 or more tables (JOINS)/10. Adding filters to Joins.mp4 23MB
  14. 13. Functions available for us to use/3. NUMBER related functions.mp4 23MB
  15. 2. Software Installation/1. Installing Oracle.mp4 23MB
  16. 23. Bonus Lets Recap with a 5 Step Process/2. Business Requirement.mp4 22MB
  17. 21. SUB Queries/3. Sub queries on multiple columns (Non-Pairwise Comparision).srt 22MB
  18. 21. SUB Queries/3. Sub queries on multiple columns (Non-Pairwise Comparision).mp4 22MB
  19. 5. Lets see the Data/1. What data can I see.mp4 21MB
  20. 15. Data Definition Language (DDL)/4. Create Table AS - CTAS.mp4 20MB
  21. 23. Bonus Lets Recap with a 5 Step Process/5. Step 3 Let's perform the Grouping....mp4 19MB
  22. 2. Software Installation/4. Running scripts necessary for the course.mp4 18MB
  23. 20. Giving Permissions to other users (GRANT)/2. I don't like him (REVOKE).mp4 17MB
  24. 21. SUB Queries/6. Scalar Sub queries.mp4 16MB
  25. 18. Views/4. Create View from more than 1 Table.mp4 15MB
  26. 11. Lets group the data/3. GROUP BY with multiple columns.mp4 14MB
  27. 23. Bonus Lets Recap with a 5 Step Process/8. Recap the 10 things we have done....mp4 13MB
  28. 18. Views/1. Why Views.mp4 12MB
  29. 12. Joining data from 2 or more tables (JOINS)/8. Joining the 3rd table.mp4 12MB
  30. 17. Lets put some restrictions on a table (Constraints)/6. Check data in other table before insertingdeleting (FOREIGN KEY).mp4 12MB
  31. 14. Interesting THINGS!!!/2. Alternative Name (ALIAS name).mp4 11MB
  32. 12. Joining data from 2 or more tables (JOINS)/2. Inner Join.mp4 11MB
  33. 16. Data Manipulation Language (DML)/2. Insert data into a table (INSERT).mp4 11MB
  34. 13. Functions available for us to use/5. DATE related functions.mp4 10MB
  35. 11. Lets group the data/1. AggregateSummary Functions.mp4 10MB
  36. 15. Data Definition Language (DDL)/2. Let's change the structure of a table (ALTER).mp4 10MB
  37. 23. Bonus Lets Recap with a 5 Step Process/6. Step 4 Let's perform Filtering at Group level....mp4 10MB
  38. 7. Logical Operators/7. AND and OR.mp4 10MB
  39. 12. Joining data from 2 or more tables (JOINS)/9. Joining the 4th table and so on....mp4 9MB
  40. 21. SUB Queries/5. Sub queries in the WITH clause.mp4 9MB
  41. 6. Lets limit the data we see (Filtering)/4. Filters on Character and Date values....mp4 9MB
  42. 23. Bonus Lets Recap with a 5 Step Process/4. Step 2 Let's add the necessary Filters....mp4 9MB
  43. 14. Interesting THINGS!!!/4. PSEUDO Columns.mp4 9MB
  44. 9. Lets sort the data we see (Sorting)/1. ORDER BY clause.mp4 8MB
  45. 23. Bonus Lets Recap with a 5 Step Process/7. Step 5 Lets Sort the data....mp4 8MB
  46. 11. Lets group the data/4. GROUP BY with HAVING clause.mp4 8MB
  47. 22. Advanced Topics - Index/2. Lets create an Index....mp4 8MB
  48. 14. Interesting THINGS!!!/1. IF THEN ELSE (CASE statement).mp4 8MB
  49. 11. Lets group the data/2. GROUP BY clause.mp4 8MB
  50. 16. Data Manipulation Language (DML)/3. Delete data from a table (DELETE).mp4 8MB
  51. 3. Database Concepts/2. What is a Database.mp4 8MB
  52. 14. Interesting THINGS!!!/3. DISTINCT values.mp4 8MB
  53. 6. Lets limit the data we see (Filtering)/5. Filtering based on a column in a table....mp4 8MB
  54. 4. Enter the Dragon (Database)/5. Data Model for our Course.mp4 8MB
  55. 17. Lets put some restrictions on a table (Constraints)/4. What is NOT NULL + UNIQUE = PRIMARY KEY.mp4 8MB
  56. 17. Lets put some restrictions on a table (Constraints)/5. Accept only few values (CHECK).mp4 8MB
  57. 13. Functions available for us to use/4. CHARACTER related functions.mp4 8MB
  58. 10. How do we combine data from 2 tables/2. UNION operator.mp4 8MB
  59. 17. Lets put some restrictions on a table (Constraints)/2. No empty data allowed (NOT NULL).mp4 8MB
  60. 16. Data Manipulation Language (DML)/4. Modify existing data in a table (UPDATE).mp4 7MB
  61. 19. Other Database Objects/2. Series of Numbers (SEQUENCE).mp4 7MB
  62. 17. Lets put some restrictions on a table (Constraints)/3. No Duplicate data (UNIQUE).mp4 7MB
  63. 6. Lets limit the data we see (Filtering)/3. Filtering Data (More Examples...).mp4 7MB
  64. 12. Joining data from 2 or more tables (JOINS)/6. Cross Join.mp4 7MB
  65. 18. Views/3. Lets update View Data.mp4 6MB
  66. 4. Enter the Dragon (Database)/4. What type of Data can we store.mp4 6MB
  67. 17. Lets put some restrictions on a table (Constraints)/7. Constraints on multiple columns.mp4 6MB
  68. 16. Data Manipulation Language (DML)/5. Delete all the data from a table (TRUNCATE).mp4 6MB
  69. 12. Joining data from 2 or more tables (JOINS)/3. Left Outer Join.mp4 6MB
  70. 7. Logical Operators/4. ALL and ANY.mp4 6MB
  71. 3. Database Concepts/1. What is a Table.mp4 6MB
  72. 6. Lets limit the data we see (Filtering)/1. Filtering Data (WHERE command).mp4 6MB
  73. 8. Arithmetic operators/1. They are simple!!! (10 + 20 = 30).mp4 6MB
  74. 12. Joining data from 2 or more tables (JOINS)/4. Right Outer Join.mp4 6MB
  75. 7. Logical Operators/6. IS NULL and IS NOT NULL.mp4 6MB
  76. 5. Lets see the Data/3. How do I see a part of the data (SELECT) .mp4 6MB
  77. 19. Other Database Objects/1. Alternative name for Objects (SYNONYMS).mp4 5MB
  78. 12. Joining data from 2 or more tables (JOINS)/7. Natural Join.mp4 5MB
  79. 22. Advanced Topics - Index/3. UNIQUE Index.mp4 5MB
  80. 5. Lets see the Data/2. How do I see data (SELECT) .mp4 5MB
  81. 3. Database Concepts/4. What is a Transaction.mp4 5MB
  82. 3. Database Concepts/5. What is ACID.mp4 5MB
  83. 12. Joining data from 2 or more tables (JOINS)/5. Full Outer Join.mp4 5MB
  84. 15. Data Definition Language (DDL)/1. Let's create a table (CREATE).mp4 5MB
  85. 7. Logical Operators/2. IN and NOT IN.mp4 5MB
  86. 18. Views/2. Lets modify an existing view.mp4 5MB
  87. 10. How do we combine data from 2 tables/1. SET Operators.mp4 5MB
  88. 7. Logical Operators/1. BETWEEN and NOT BETWEEN.mp4 5MB
  89. 17. Lets put some restrictions on a table (Constraints)/9. More operations on Constraints....mp4 4MB
  90. 22. Advanced Topics - Index/1. Book Index.mp4 4MB
  91. 9. Lets sort the data we see (Sorting)/2. How are NULL values treated while Sorting Data.mp4 4MB
  92. 13. Functions available for us to use/1. DUAL (What is this).mp4 4MB
  93. 7. Logical Operators/5. Lets learn about NULL....mp4 4MB
  94. 3. Database Concepts/3. What is a Relational Database (RDBMS).mp4 4MB
  95. 10. How do we combine data from 2 tables/5. MINUS operator.mp4 4MB
  96. 22. Advanced Topics - Index/4. Dropping and Renaming an Index.mp4 4MB
  97. 10. How do we combine data from 2 tables/4. INTERSECT operator.mp4 3MB
  98. 4. Enter the Dragon (Database)/2. How do you talk with a Database.mp4 3MB
  99. 17. Lets put some restrictions on a table (Constraints)/8. Adding constraints to an existing table.mp4 3MB
  100. 10. How do we combine data from 2 tables/3. UNION ALL operator.mp4 3MB
  101. 13. Functions available for us to use/2. Why do we need functions.mp4 2MB
  102. 3. Database Concepts/6. RDBMS Vendors.mp4 2MB
  103. 4. Enter the Dragon (Database)/3. What are the most common commands.mp4 2MB
  104. 6. Lets limit the data we see (Filtering)/2. Comparison Operators.mp4 2MB
  105. 17. Lets put some restrictions on a table (Constraints)/1. Why constraints.mp4 2MB
  106. 15. Data Definition Language (DDL)/3. Let's delete the table (DROP).mp4 2MB
  107. 16. Data Manipulation Language (DML)/1. COMMIT and ROLLBACK.mp4 2MB
  108. 15. Data Definition Language (DDL)/5. Lab 11 (Exercises with Answers).pdf 374KB
  109. 18. Views/5. Lab 14 (Exercises with Answers).pdf 361KB
  110. 17. Lets put some restrictions on a table (Constraints)/10. Lab 13 (Exercises with Answers).pdf 306KB
  111. 11. Lets group the data/5. Lab 7 (Exercises with Answers).pdf 292KB
  112. 16. Data Manipulation Language (DML)/6. Lab 12 (Exercises with Answers).pdf 291KB
  113. 7. Logical Operators/8. Lab 3 (Exercises with Answers).pdf 283KB
  114. 13. Functions available for us to use/6. Lab 9 (Exercises with Answers).pdf 281KB
  115. 6. Lets limit the data we see (Filtering)/6. Lab 2 (Exercises with Answers).pdf 277KB
  116. 5. Lets see the Data/4. Lab 1 (Exercises with Answers).pdf 276KB
  117. 10. How do we combine data from 2 tables/6. Lab 6 (Exercises with Answers).pdf 274KB
  118. 12. Joining data from 2 or more tables (JOINS)/11. Lab 8 (Exercises with Answers).pdf 273KB
  119. 9. Lets sort the data we see (Sorting)/3. Lab 5 (Exercises with Answers).pdf 271KB
  120. 4. Enter the Dragon (Database)/1.1 Building SQL Template.pdf 238KB
  121. 1. Chapter 1/1. Closed CaptionsSub Titles for the course.pdf 233KB
  122. 24. Where to Go From Here/1. Project Work.pdf 212KB
  123. 8. Arithmetic operators/2. Lab 4 (Exercises with Answers).pdf 206KB
  124. 24. Where to Go From Here/2. Advanced Database concepts you can explore!!!.pdf 205KB
  125. 1. Chapter 1/3. How to make best use of the program.pdf 204KB
  126. 23. Bonus Lets Recap with a 5 Step Process/1. Scripts for this Section.pdf 204KB
  127. 20. Giving Permissions to other users (GRANT)/3. List of all GRANT's.pdf 195KB
  128. 2. Software Installation/5. Scripts for our Lab Exercises.pdf 166KB
  129. 23. Bonus Lets Recap with a 5 Step Process/3. Step 1 Let's Select all the columns needed....srt 8KB
  130. 18. Views/1. Why Views.srt 8KB
  131. 1. Chapter 1/2. Welcome!!.srt 8KB
  132. 18. Views/4. Create View from more than 1 Table.srt 8KB
  133. 11. Lets group the data/1. AggregateSummary Functions.srt 7KB
  134. 11. Lets group the data/3. GROUP BY with multiple columns.srt 7KB
  135. 21. SUB Queries/7. Correlated SUB Query.srt 7KB
  136. 16. Data Manipulation Language (DML)/2. Insert data into a table (INSERT).srt 7KB
  137. 12. Joining data from 2 or more tables (JOINS)/2. Inner Join.srt 6KB
  138. 7. Logical Operators/3. LIKE operator.srt 6KB
  139. 21. SUB Queries/4. Sub queries in the FROM clause.srt 6KB
  140. 9. Lets sort the data we see (Sorting)/1. ORDER BY clause.srt 6KB
  141. 20. Giving Permissions to other users (GRANT)/1. I like him (GRANT).srt 6KB
  142. 6. Lets limit the data we see (Filtering)/4. Filters on Character and Date values....srt 6KB
  143. 10. How do we combine data from 2 tables/2. UNION operator.srt 6KB
  144. 17. Lets put some restrictions on a table (Constraints)/6. Check data in other table before insertingdeleting (FOREIGN KEY).srt 5KB
  145. 7. Logical Operators/7. AND and OR.srt 5KB
  146. 13. Functions available for us to use/5. DATE related functions.srt 5KB
  147. 21. SUB Queries/1. What is a SUB Query.srt 5KB
  148. 15. Data Definition Language (DDL)/2. Let's change the structure of a table (ALTER).srt 5KB
  149. 23. Bonus Lets Recap with a 5 Step Process/2. Business Requirement.srt 5KB
  150. 19. Other Database Objects/2. Series of Numbers (SEQUENCE).srt 5KB
  151. 21. SUB Queries/2. Sub queries on multiple columns (Pairwise Comparision).srt 5KB
  152. 11. Lets group the data/2. GROUP BY clause.srt 5KB
  153. 12. Joining data from 2 or more tables (JOINS)/1. Why Joins.srt 5KB
  154. 14. Interesting THINGS!!!/3. DISTINCT values.srt 5KB
  155. 14. Interesting THINGS!!!/2. Alternative Name (ALIAS name).srt 5KB
  156. 5. Lets see the Data/1. What data can I see.srt 5KB
  157. 14. Interesting THINGS!!!/1. IF THEN ELSE (CASE statement).srt 5KB
  158. 6. Lets limit the data we see (Filtering)/5. Filtering based on a column in a table....srt 4KB
  159. 22. Advanced Topics - Index/2. Lets create an Index....srt 4KB
  160. 13. Functions available for us to use/4. CHARACTER related functions.srt 4KB
  161. 16. Data Manipulation Language (DML)/3. Delete data from a table (DELETE).srt 4KB
  162. 17. Lets put some restrictions on a table (Constraints)/5. Accept only few values (CHECK).srt 4KB
  163. 7. Logical Operators/4. ALL and ANY.srt 4KB
  164. 13. Functions available for us to use/3. NUMBER related functions.srt 4KB
  165. 16. Data Manipulation Language (DML)/4. Modify existing data in a table (UPDATE).srt 4KB
  166. 14. Interesting THINGS!!!/4. PSEUDO Columns.srt 4KB
  167. 6. Lets limit the data we see (Filtering)/3. Filtering Data (More Examples...).srt 4KB
  168. 7. Logical Operators/6. IS NULL and IS NOT NULL.srt 4KB
  169. 17. Lets put some restrictions on a table (Constraints)/4. What is NOT NULL + UNIQUE = PRIMARY KEY.srt 4KB
  170. 3. Database Concepts/2. What is a Database.srt 4KB
  171. 17. Lets put some restrictions on a table (Constraints)/7. Constraints on multiple columns.srt 4KB
  172. 19. Other Database Objects/1. Alternative name for Objects (SYNONYMS).srt 4KB
  173. 17. Lets put some restrictions on a table (Constraints)/2. No empty data allowed (NOT NULL).srt 4KB
  174. 17. Lets put some restrictions on a table (Constraints)/3. No Duplicate data (UNIQUE).srt 4KB
  175. 12. Joining data from 2 or more tables (JOINS)/10. Adding filters to Joins.srt 4KB
  176. 4. Enter the Dragon (Database)/4. What type of Data can we store.srt 4KB
  177. 16. Data Manipulation Language (DML)/5. Delete all the data from a table (TRUNCATE).srt 4KB
  178. 15. Data Definition Language (DDL)/1. Let's create a table (CREATE).srt 4KB
  179. 12. Joining data from 2 or more tables (JOINS)/6. Cross Join.srt 4KB
  180. 15. Data Definition Language (DDL)/4. Create Table AS - CTAS.srt 4KB
  181. 20. Giving Permissions to other users (GRANT)/2. I don't like him (REVOKE).srt 4KB
  182. 22. Advanced Topics - Index/3. UNIQUE Index.srt 4KB
  183. 6. Lets limit the data we see (Filtering)/1. Filtering Data (WHERE command).srt 4KB
  184. 12. Joining data from 2 or more tables (JOINS)/3. Left Outer Join.srt 4KB
  185. 3. Database Concepts/5. What is ACID.srt 4KB
  186. 11. Lets group the data/4. GROUP BY with HAVING clause.srt 4KB
  187. 12. Joining data from 2 or more tables (JOINS)/4. Right Outer Join.srt 4KB
  188. 18. Views/3. Lets update View Data.srt 3KB
  189. 10. How do we combine data from 2 tables/1. SET Operators.srt 3KB
  190. 3. Database Concepts/1. What is a Table.srt 3KB
  191. 2. Software Installation/1. Installing Oracle.srt 3KB
  192. 13. Functions available for us to use/1. DUAL (What is this).srt 3KB
  193. 7. Logical Operators/2. IN and NOT IN.srt 3KB
  194. 7. Logical Operators/1. BETWEEN and NOT BETWEEN.srt 3KB
  195. 5. Lets see the Data/2. How do I see data (SELECT) .srt 3KB
  196. 12. Joining data from 2 or more tables (JOINS)/5. Full Outer Join.srt 3KB
  197. 10. How do we combine data from 2 tables/5. MINUS operator.srt 3KB
  198. 5. Lets see the Data/3. How do I see a part of the data (SELECT) .srt 3KB
  199. 22. Advanced Topics - Index/1. Book Index.srt 3KB
  200. 12. Joining data from 2 or more tables (JOINS)/7. Natural Join.srt 3KB
  201. 8. Arithmetic operators/1. They are simple!!! (10 + 20 = 30).srt 3KB
  202. 21. SUB Queries/6. Scalar Sub queries.srt 3KB
  203. 4. Enter the Dragon (Database)/3. What are the most common commands.srt 3KB
  204. 23. Bonus Lets Recap with a 5 Step Process/8. Recap the 10 things we have done....srt 3KB
  205. 10. How do we combine data from 2 tables/4. INTERSECT operator.srt 3KB
  206. 2. Software Installation/4. Running scripts necessary for the course.srt 3KB
  207. 3. Database Concepts/4. What is a Transaction.srt 3KB
  208. 4. Enter the Dragon (Database)/2. How do you talk with a Database.srt 3KB
  209. 17. Lets put some restrictions on a table (Constraints)/9. More operations on Constraints....srt 3KB
  210. 17. Lets put some restrictions on a table (Constraints)/8. Adding constraints to an existing table.srt 3KB
  211. 7. Logical Operators/5. Lets learn about NULL....srt 3KB
  212. 3. Database Concepts/3. What is a Relational Database (RDBMS).srt 3KB
  213. 23. Bonus Lets Recap with a 5 Step Process/5. Step 3 Let's perform the Grouping....srt 3KB
  214. 18. Views/2. Lets modify an existing view.srt 3KB
  215. 2. Software Installation/2. Installing Java SDK.srt 2KB
  216. 17. Lets put some restrictions on a table (Constraints)/1. Why constraints.srt 2KB
  217. 4. Enter the Dragon (Database)/5. Data Model for our Course.srt 2KB
  218. 12. Joining data from 2 or more tables (JOINS)/8. Joining the 3rd table.srt 2KB
  219. 22. Advanced Topics - Index/4. Dropping and Renaming an Index.srt 2KB
  220. 9. Lets sort the data we see (Sorting)/2. How are NULL values treated while Sorting Data.srt 2KB
  221. 10. How do we combine data from 2 tables/3. UNION ALL operator.srt 2KB
  222. 21. SUB Queries/5. Sub queries in the WITH clause.srt 2KB
  223. 16. Data Manipulation Language (DML)/1. COMMIT and ROLLBACK.srt 2KB
  224. 6. Lets limit the data we see (Filtering)/2. Comparison Operators.srt 2KB
  225. 13. Functions available for us to use/2. Why do we need functions.srt 2KB
  226. 3. Database Concepts/6. RDBMS Vendors.srt 2KB
  227. 12. Joining data from 2 or more tables (JOINS)/9. Joining the 4th table and so on....srt 2KB
  228. 23. Bonus Lets Recap with a 5 Step Process/6. Step 4 Let's perform Filtering at Group level....srt 2KB
  229. 23. Bonus Lets Recap with a 5 Step Process/7. Step 5 Lets Sort the data....srt 1KB
  230. 15. Data Definition Language (DDL)/3. Let's delete the table (DROP).srt 1KB
  231. 23. Bonus Lets Recap with a 5 Step Process/4. Step 2 Let's add the necessary Filters....srt 1KB
  232. 2. Software Installation/4.1 Create User.txt 191B
  233. [Tutorialsplanet.NET].url 128B
  234. 4. Enter the Dragon (Database)/1. Building SQL Template....html 116B
  235. 2. Software Installation/3.1 SQL Developer URL.txt 85B
  236. 2. Software Installation/1.1 Oracle database URL.txt 84B
  237. 2. Software Installation/2.1 Java URL.txt 84B