Udemy - The Complete Oracle SQL Certification Course (12.2023)

File Name

Size

01 - Database Basics/001 Oracle Database Introduction & Basics of Tables.mp4

68 MB

01 - Database Basics/001 Oracle Database Introduction & Basics of Tables.srt

34 kB

01 - Database Basics/002 Creating the Workspace in Oracle.mp4

50 MB

01 - Database Basics/002 Creating the Workspace in Oracle.srt

12 kB

01 - Database Basics/003 course-data.txt

2.4 kB

01 - Database Basics/003 IMPORTANT Prepare the Sample Data.mp4

23 MB

01 - Database Basics/003 IMPORTANT Prepare the Sample Data.srt

7.0 kB

01 - Database Basics/004 Dedicated TA Support.mp4

16 MB

01 - Database Basics/004 Dedicated TA Support.srt

3.1 kB

01 - Database Basics/005 Join our Online Community (Discord).html

1.7 kB

01 - Database Basics/006 How to Proceed in This Course.mp4

25 MB

01 - Database Basics/006 How to Proceed in This Course.srt

5.1 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/001 Oracle Exams and Certification Information.html

682 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/002 Code-for-Select-Clause.txt

245 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/002 Retrieving Data Using the SELECT Clause.mp4

81 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/002 Retrieving Data Using the SELECT Clause.srt

24 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/003 Code-for-WHERE-Clause.txt

130 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/003 Using the WHERE Clause in a Query.mp4

58 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/003 Using the WHERE Clause in a Query.srt

30 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/004 Important Information from Instructor.mp4

73 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/004 Important Information from Instructor.srt

7.3 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/005 Code-for-Using-Operators-in-the-WHERE-Clause.txt

659 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/005 Using Operators in the WHERE Clause.mp4

104 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/005 Using Operators in the WHERE Clause.srt

31 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/006 Some Inspiration.mp4

26 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/006 Some Inspiration.srt

5.2 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/007 Code-for-Combining-WHERE-AND-OR-Operators.txt

263 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/007 Combining WHERE, AND & OR with Operators.mp4

94 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/007 Combining WHERE, AND & OR with Operators.srt

33 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/008 Code-for-Query-Filtering-Continued-BETWEEN-IN-NULL.txt

618 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/008 Query Filtering Continued BETWEEN, IN and NULL.mp4

110 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/008 Query Filtering Continued BETWEEN, IN and NULL.srt

30 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/009 What Will Make you Grow as a Software Developer.mp4

34 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/009 What Will Make you Grow as a Software Developer.srt

7.0 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/010 Code-for-Query-Filtering-Conditions-Operator-Precedence.txt

689 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/010 Query Filtering Conditions & Operator Precedence.mp4

73 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/010 Query Filtering Conditions & Operator Precedence.srt

32 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/011 Code-for-Ordering-Concatenating-Aliasing-Query-Results.txt

683 B

02 - Single Table Queries (Exercises & Solutions in the Lectures)/011 Ordering, Concatenating And Aliasing Query Results.mp4

72 MB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/011 Ordering, Concatenating And Aliasing Query Results.srt

31 kB

02 - Single Table Queries (Exercises & Solutions in the Lectures)/012 Assignment 1 Practice with Single Table Queries.html

5.3 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/001 Code-for-Single-Row-Functions-SRF-Using-the-Dual-Table.txt

715 B

03 - Single Row Functions (Exercises and Solutions In the Lectures)/001 Single Row Functions (SRF) & Using The Dual Table.mp4

88 MB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/001 Single Row Functions (SRF) & Using The Dual Table.srt

32 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/002 Code-for-Using-Functions-in-WHERE-and-Character-Based-SRFs.txt

1.0 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/002 Using Functions in WHERE And Character Based SRFs.mp4

94 MB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/002 Using Functions in WHERE And Character Based SRFs.srt

32 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/003 Code-for-Numeric-and-Date-Datatype-SRFs.txt

1.1 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/003 Numeric and Date Data type SRFs.mp4

84 MB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/003 Numeric and Date Data type SRFs.srt

33 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/004 Code-for-Conversion-SRFs-Date-Formatting.txt

528 B

03 - Single Row Functions (Exercises and Solutions In the Lectures)/004 Conversion SRFs and Date Formatting.mp4

65 MB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/004 Conversion SRFs and Date Formatting.srt

33 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/005 Some More Date Functions.html

727 B

03 - Single Row Functions (Exercises and Solutions In the Lectures)/006 Code-for-Concluding-SRFs-NULL-NULLIF-Functions.txt

778 B

03 - Single Row Functions (Exercises and Solutions In the Lectures)/006 Concluding SRFs & NULL NULLIF Functions.mp4

66 MB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/006 Concluding SRFs & NULL NULLIF Functions.srt

27 kB

03 - Single Row Functions (Exercises and Solutions In the Lectures)/007 Assignment 2 Practice with Single Row Functions.html

6.6 kB

04 - Grouping Functions (Exercises and Solutions In the Lectures)/001 Code-for-Grouping-Functions-MIN-MAX-AVG-COUNT-etc.txt

865 B

04 - Grouping Functions (Exercises and Solutions In the Lectures)/001 Grouping Functions MIN, MAX, AVG, COUNT etc.mp4

59 MB

04 - Grouping Functions (Exercises and Solutions In the Lectures)/001 Grouping Functions MIN, MAX, AVG, COUNT etc.srt

32 kB

04 - Grouping Functions (Exercises and Solutions In the Lectures)/002 Code-for-GROUP-BY-Clause-HAVING-CLAUSE.txt

601 B

04 - Grouping Functions (Exercises and Solutions In the Lectures)/002 GROUP BY Clause & HAVING Clause.mp4

68 MB

04 - Grouping Functions (Exercises and Solutions In the Lectures)/002 GROUP BY Clause & HAVING Clause.srt

33 kB

04 - Grouping Functions (Exercises and Solutions In the Lectures)/003 Code-for-More-Practice-with-the-GROUP-BY-Clause.txt

259 B

04 - Grouping Functions (Exercises and Solutions In the Lectures)/003 More Practice With The GROUP BY Clause.mp4

54 MB

04 - Grouping Functions (Exercises and Solutions In the Lectures)/003 More Practice With The GROUP BY Clause.srt

21 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/001 Code-for-SELECT-within-SELECT-Nested-Queries-Subqueries.txt

1.2 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/001 SELECT within SELECT (Subqueries).mp4

86 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/001 SELECT within SELECT (Subqueries).srt

39 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/002 Code-for-Relating-Tables-together-using-JOINs.txt

1.2 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/002 Relating Tables Together Using JOINs.mp4

95 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/002 Relating Tables Together Using JOINs.srt

31 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/003 Code-for-JOINS-Continued-INNER-OUTER-Joins.txt

1.2 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/003 Joins Continued INNER & OUTER Joins.mp4

87 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/003 Joins Continued INNER & OUTER Joins.srt

38 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/004 Career Advice.mp4

16 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/004 Career Advice.srt

3.2 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/005 Code-for-More-JOINS-with-Correlated-Subqueries.txt

1.1 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/005 Correlated Subqueries with EXISTS & NOT EXIST operators.mp4

106 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/005 Correlated Subqueries with EXISTS & NOT EXIST operators.srt

36 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/006 SELF JOIN.mp4

31 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/006 SELF JOIN.srt

17 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/007 CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4

30 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/007 CROSS JOIN, NATURAL JOIN and the USING CLAUSE.srt

15 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/008 Code-for-EQUI-and-NON-EQUI-Joins.txt

421 B

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/008 EQUIJOIN and NON-EQUIJOINs.mp4

21 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/008 EQUIJOIN and NON-EQUIJOINs.srt

16 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/009 CASE Statements.mp4

62 MB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/009 CASE Statements.srt

14 kB

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/009 Code-for-CASE-Statement.txt

379 B

05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/009 Oracle-COALESCE-Function.pdf

283 kB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/001 OVER Clause with PARTITION BY.mp4

60 MB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/001 OVER Clause with PARTITION BY.srt

33 kB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/002 Compute Running Totals with Ordering and Partitioning.mp4

52 MB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/002 Compute Running Totals with Ordering and Partitioning.srt

32 kB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/003 Unbounded Preceding Order in Over Clause.mp4

25 MB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/003 Unbounded Preceding Order in Over Clause.srt

16 kB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/004 Slicing Windows and Filtering with Analytic Functions.mp4

21 MB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/004 Slicing Windows and Filtering with Analytic Functions.srt

11 kB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/005 Rank, Dense_rank, Lead, and Lag Functions.mp4

53 MB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/005 Rank, Dense_rank, Lead, and Lag Functions.srt

26 kB

06 - Analytical Functions using OVER and PARTITION with ORDER BY/006 Assignment Application of Window Functions and SELF JOIN.html

1.8 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/001 Code-for-Creating-Your-Own-Tables-Design-Considerations.txt

158 B

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/001 Creating Your Own Tables & Design Considerations.mp4

108 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/001 Creating Your Own Tables & Design Considerations.srt

35 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/002 Code-for-Inserting-Data-Into-our-Table.txt

984 B

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/002 Inserting Data Into Our Table.mp4

104 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/002 Inserting Data Into Our Table.srt

33 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/003 Code-for-Create-Table-With-Primary-Key-Constraint.txt

1.9 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/003 Create Table With a Primary Key Constraint.mp4

136 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/003 Create Table With a Primary Key Constraint.srt

38 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/004 Code-for-Multi-Table-Insert-Using-INSERT-ALL.txt

1.0 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/004 INSERT ALL for Multi-table & Conditional Inserts.mp4

31 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/004 INSERT ALL for Multi-table & Conditional Inserts.srt

19 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/005 Code-for-Alter-Table-and-Modify-Column-Attributes.txt

690 B

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/005 Using ALTER to modify the table structure.mp4

57 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/005 Using ALTER to modify the table structure.srt

26 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/006 Code-for-Create-Table-with-SELECT-and-UPDATE-existing-Data.txt

706 B

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/006 Create Table with SELECT + UPDATE Data.mp4

107 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/006 Create Table with SELECT + UPDATE Data.srt

32 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/007 Code-for-MERGE-Statement.txt

1.1 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/007 MERGE Statement in Oracle.mp4

89 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/007 MERGE Statement in Oracle.srt

29 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/007 merge-sql-example.txt

2.9 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/008 Primary and Foreign Keys.html

1.6 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/009 Sequence Statements in Oracle.mp4

29 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/009 Sequence Statements in Oracle.srt

22 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/010 Code-for-Delete-Truncate-and-Drop-Commands.txt

397 B

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/010 DELETE, TRUNCATE, and DROP Commands.mp4

64 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/010 DELETE, TRUNCATE, and DROP Commands.srt

30 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/011 Code-for-Database-Indexes.txt

601 B

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/011 Working With Database Indexes.mp4

55 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/011 Working With Database Indexes.srt

24 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/012 Code-for-System-Tables-Pseudo-Columns-Deleting-Duplicate-Data.txt

1.2 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/012 System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4

143 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/012 System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).srt

40 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/013 Code-for-Other-Objects-and-Commands-VIEWs-UNION-ALL-etc.txt

1.6 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/013 Views and Other Objects and Commands (Newly Added).mp4

93 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/013 Views and Other Objects and Commands (Newly Added).srt

40 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/014 SQL could be tricky, check this out!.html

1.2 kB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/015 Granting and Revoking Privileges.mp4

65 MB

07 - Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/015 Granting and Revoking Privileges.srt

25 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/001 OFFSET and FETCH.mp4

51 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/001 OFFSET and FETCH.srt

18 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/002 ERD Diagrams.mp4

62 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/002 ERD Diagrams.srt

31 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/003 Commit, Rollback, and Savepoint.mp4

25 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/003 Commit, Rollback, and Savepoint.srt

25 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/004 code-for-building-lease-example.txt

506 B

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/004 Large Objects and Interval Data Types.mp4

125 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/004 Large Objects and Interval Data Types.srt

33 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/005 code-for-cascade-constraints.txt

798 B

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/005 Using Cascade Constraints and On Delete Cascade.mp4

63 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/005 Using Cascade Constraints and On Delete Cascade.srt

31 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/006 UNUSED Columns.mp4

17 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/006 UNUSED Columns.srt

14 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/007 code-for-external-tables.txt

1.0 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/007 External Tables.mp4

101 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/007 External Tables.srt

26 kB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/008 SQL Plus and Substitution Variables.mp4

206 MB

08 - ADDITIONAL TOPICS + REVIEW for EXAM 170-071/008 SQL Plus and Substitution Variables.srt

57 kB

09 - Exam Question Walkthrough Videos + 2 Exams/001 QA 1- DML, DDL, and Transaction Control.mp4

123 MB

09 - Exam Question Walkthrough Videos + 2 Exams/001 QA 1- DML, DDL, and Transaction Control.srt

46 kB

09 - Exam Question Walkthrough Videos + 2 Exams/002 QA 2- Fetch and Substitution Variables.mp4

132 MB

09 - Exam Question Walkthrough Videos + 2 Exams/002 QA 2- Fetch and Substitution Variables.srt

45 kB

09 - Exam Question Walkthrough Videos + 2 Exams/003 QA 3 - Conversion Functions, TO_CHAR, NVL, and TO_DATE.mp4

187 MB

09 - Exam Question Walkthrough Videos + 2 Exams/003 QA 3 - Conversion Functions, TO_CHAR, NVL, and TO_DATE.srt

54 kB

09 - Exam Question Walkthrough Videos + 2 Exams/004 Practice Test 1.html

32 kB

09 - Exam Question Walkthrough Videos + 2 Exams/005 Practice Test 2.html

15 kB

10 - APPENDIX - Installing Oracle on Windows/001 Install Oracle Database 19c in Windows.mp4

38 MB

10 - APPENDIX - Installing Oracle on Windows/001 Install Oracle Database 19c in Windows.srt

18 kB

10 - APPENDIX - Installing Oracle on Windows/002 Install Oracle SQL Developer in Windows.mp4

48 MB

10 - APPENDIX - Installing Oracle on Windows/002 Install Oracle SQL Developer in Windows.srt

26 kB

11 - Course Extras!/001 Bonus Lecture.html

1.8 kB