Name Udemy - The Complete Oracle SQL Certification Course

File Type video

Size 5.82GB

UpdateDate 2025-3-21

hash *****3D787292AA623BBB557F3D41EBCC21FA0B

Hot 1

Files 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.mp4 | 339.87MB 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.srt | 29.99KB 1. Database Basics/2. Creating the Workspace in Oracle.mp4 | 50.35MB 1. Database Basics/2. Creating the Workspace in Oracle.srt | 10.22KB 1. Database Basics/3. IMPORTANT Prepare the Sample Data.mp4 | 24.27MB 1. Database Basics/3. IMPORTANT Prepare the Sample Data.srt | 5.82KB 1. Database Basics/3.1 course_data.txt | 764B 1. Database Basics/[CourseClub.Me].url | 48B 1. Database Basics/[DesireCourse.Net].url | 51B 10. APPENDIX - Installing Oracle on Windows/1. Install Oracle Database 19c in Windows.mp4 | 78.54MB 10. APPENDIX - Installing Oracle on Windows/1. Install Oracle Database 19c in Windows.srt | 16.18KB 10. APPENDIX - Installing Oracle on Windows/2. Install Oracle SQL Developer in Windows.mp4 | 95.13MB 10. APPENDIX - Installing Oracle on Windows/2. Install Oracle SQL Developer in Windows.srt | 21.94KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html | 688B 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp4 | 25.29MB 2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.srt | 20.00KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/2.1 Code for Select Clause.txt | 132B 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp4 | 93.86MB 2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.srt | 26.00KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/3.1 Code for WHERE Clause.txt | 130B 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp4 | 122.90MB 2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.srt | 28.33KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/4.1 Code for Using Operators in the WHERE Clause.txt | 277B 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp4 | 104.52MB 2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.srt | 28.37KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/5.1 Code for Combining WHERE, AND & OR Operators.txt | 199B 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp4 | 109.94MB 2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.srt | 26.89KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt | 281B 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp4 | 110.11MB 2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.srt | 27.31KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/7.1 Code for Query Filtering Conditions & Operator Precedence.txt | 326B 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp4 | 109.53MB 2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.srt | 25.81KB 2. Single Table Queries (Exercises & Solutions in the Lectures)/8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt | 331B 2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Practice with single table queries.html | 159B 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp4 | 96.53MB 3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.srt | 26.64KB 3. Single Row Functions (Exercises and Solutions In the Lectures)/1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt | 295B 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp4 | 103.37MB 3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.srt | 26.49KB 3. Single Row Functions (Exercises and Solutions In the Lectures)/2.1 Code for Using Functions in WHERE and Character Based SRFs.txt | 281B 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp4 | 98.63MB 3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.srt | 27.63KB 3. Single Row Functions (Exercises and Solutions In the Lectures)/3.1 Code for Numeric and Date Datatype SRFs.txt | 1.10KB 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.mp4 | 95.14MB 3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.srt | 27.44KB 3. Single Row Functions (Exercises and Solutions In the Lectures)/4.1 Code for Conversion SRFs & Date Formatting.txt | 528B 3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html | 723B 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp4 | 78.27MB 3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.srt | 23.32KB 3. Single Row Functions (Exercises and Solutions In the Lectures)/6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt | 778B 3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Practice with Single Row Functions.html | 159B 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4 | 100.88MB 4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..srt | 27.38KB 4. Grouping Functions (Exercises and Solutions In the Lectures)/1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt | 865B 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp4 | 99.17MB 4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.srt | 28.32KB 4. Grouping Functions (Exercises and Solutions In the Lectures)/2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt | 200B 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp4 | 65.33MB 4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.srt | 17.61KB 4. Grouping Functions (Exercises and Solutions In the Lectures)/3.1 Code for More Practice with the GROUP BY Clause.txt | 98B 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp4 | 127.17MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).srt | 34.32KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt | 1.24KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp4 | 110.32MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.srt | 27.38KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2.1 Code for Relating Tables together using JOINs .txt | 1.18KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp4 | 137.49MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.srt | 30.33KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3.1 Code for JOINS Continued INNER & OUTER Joins.txt | 1.20KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4 | 122.56MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.srt | 29.87KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4.1 Code for More JOINS with Correlated Subqueries .txt | 1.11KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5. SELF JOIN.mp4 | 59.02MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5. SELF JOIN.srt | 16.69KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4 | 53.14MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.srt | 12.59KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. EQUIJOIN and NON-EQUIJOINs.mp4 | 45.91MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. EQUIJOIN and NON-EQUIJOINs.srt | 14.43KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7.1 Code for EQUI and NON-EQUI Joins.txt | 421B 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. CASE Statements.mp4 | 61.60MB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. CASE Statements.srt | 11.85KB 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8.1 Code for CASE Statement.txt | 379B 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/[CourseClub.Me].url | 48B 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/[DesireCourse.Net].url | 51B 6. Analytical Functions using OVER and PARTITION with ORDER BY/1. OVER Clause with PARTITION BY.mp4 | 118.08MB 6. Analytical Functions using OVER and PARTITION with ORDER BY/1. OVER Clause with PARTITION BY.srt | 27.54KB 6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.mp4 | 128.35MB 6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.srt | 28.79KB 6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.mp4 | 61.10MB 6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.srt | 13.86KB 6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.mp4 | 44.78MB 6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.srt | 10.12KB 6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.mp4 | 107.88MB 6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.srt | 23.91KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp4 | 117.45MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.srt | 31.23KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1.1 Code for Creating Your Own Tables & Design Considerations.txt | 158B 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.mp4 | 114.24MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.srt | 25.54KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10.1 Code for Delete, Truncate and Drop Commands.txt | 397B 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.mp4 | 80.44MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.srt | 20.01KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11.1 Code for Database Indexes.txt | 601B 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4 | 159.07MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).srt | 32.50KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt | 1.17KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).mp4 | 138.29MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).srt | 32.89KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt | 1.57KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/14. SQL could be tricky, check this out!.html | 1.20KB 1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp4 | 67.54MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.srt | 20.01KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/16. BECOME A SQL QUERY WIZARD!.html | 704B 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/17. Bonus Lecture Lifetime Access to All My Courses.html | 995B 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp4 | 113.78MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.srt | 27.48KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2.1 Code for Inserting Data Into our Table.txt | 984B 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp4 | 146.49MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.srt | 32.66KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3.1 Code for Create Table With Primary Key Constraint.txt | 1.91KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.mp4 | 77.05MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.srt | 15.74KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4.1 Code for Multi-Table Insert Using INSERT ALL.txt | 1.01KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.mp4 | 100.00MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.srt | 22.53KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5.1 Code for Alter Table and Modify Column Attributes.txt | 690B 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.mp4 | 123.53MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.srt | 27.17KB 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 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. MERGE Statement in Oracle.mp4 | 117.45MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. MERGE Statement in Oracle.srt | 23.43KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.1 Code for MERGE Statement.txt | 1.05KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.2 merge_sql_example.txt | 2.88KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Primary and Foreign Keys.html | 1.57KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. Sequence Statements.mp4 | 64.60MB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. Sequence Statements.srt | 17.76KB 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9.1 Code for Sequence Statements.txt | 315B 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.mp4 | 65.89MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.srt | 16.63KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.mp4 | 61.89MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.srt | 28.57KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.mp4 | 54.38MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.srt | 22.50KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.mp4 | 131.33MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.srt | 28.56KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.mp4 | 114.72MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.srt | 27.83KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5.1 code for cascade constraints.txt | 798B 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.mp4 | 38.71MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.srt | 12.04KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.mp4 | 107.56MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.srt | 24.27KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7.1 code for external tables.txt | 1.02KB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.mp4 | 225.52MB 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.srt | 53.82KB 9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.mp4 | 167.91MB 9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.srt | 40.86KB 9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.mp4 | 176.99MB 9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.srt | 42.13KB 9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4 | 213.93MB 9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.srt | 48.52KB 9. Exam Question Walkthrough Videos + 2 Exams/4. Practice Test 1.html | 155B 9. Exam Question Walkthrough Videos + 2 Exams/5. Practice Test 2.html | 155B 9. Exam Question Walkthrough Videos + 2 Exams/[CourseClub.Me].url | 48B 9. Exam Question Walkthrough Videos + 2 Exams/[DesireCourse.Net].url | 51B