Udemy - The Complete Oracle SQL Certification Course 2020-6 AhLaN

1. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.mp4339.87MB
2. 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp467.54MB
3. 1. Database Basics/2. Creating the Workspace in Oracle.mp450.35MB
4. 1. Database Basics/3. IMPORTANT Prepare the Sample Data.mp424.27MB
5. 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp425.29MB
6. 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp493.86MB
7. 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp4122.9MB
8. 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp4104.52MB
9. 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp4109.94MB
10. 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp4110.11MB
11. 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp4109.53MB
12. 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp496.53MB
13. 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp4103.37MB
14. 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp498.63MB
15. 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.mp495.14MB
16. 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp478.27MB
17. 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4100.88MB
18. 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp499.17MB
19. 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp465.33MB
20. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp4127.17MB
21. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp4110.32MB
22. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp4137.49MB
23. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4122.56MB
24. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5. SELF JOIN.mp459.02MB
25. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp453.14MB
26. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. EQUIJOIN and NON-EQUIJOINs.mp445.91MB
27. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. CASE Statements.mp461.6MB
28. 6. Analytical Functions using OVER and PARTITION with ORDER BY/1. OVER Clause with PARTITION BY.mp4118.08MB
29. 6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.mp4128.35MB
30. 6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.mp461.1MB
31. 6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.mp444.78MB
32. 6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.mp4107.88MB
33. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp4117.45MB
34. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp4113.78MB
35. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp4146.49MB
36. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.mp477.05MB
37. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.mp4100MB
38. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.mp4123.53MB
39. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. MERGE Statement in Oracle.mp4117.45MB
40. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. Sequence Statements.mp464.6MB
41. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.mp4114.24MB
42. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.mp480.44MB
43. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4159.07MB
44. 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).mp4138.29MB
45. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.mp465.89MB
46. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.mp461.89MB
47. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.mp454.38MB
48. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.mp4131.33MB
49. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.mp4114.72MB
50. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.mp438.71MB
51. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.mp4107.56MB
52. 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.mp4225.52MB
53. 9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.mp4167.91MB
54. 9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.mp4176.99MB
55. 9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4213.93MB
56. 10. APPENDIX - Installing Oracle on Windows/1. Install Oracle Database 19c in Windows.mp478.54MB
57. 10. APPENDIX - Installing Oracle on Windows/2. Install Oracle SQL Developer in Windows.mp495.13MB