FreeCourseSite com Udemy - The Complete Oracle SQL Certification Course

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