Udemy - The Complete Oracle SQL Bootcamp (2025) (8.2025)

Creation Time	Sept. 21, 2025, 1:39 p.m.
Last Access Time	Sept. 21, 2025, 6 p.m.
File Size	12.9 GB
Keywords	Complete - Udemy 2025 SQL Oracle 8 The Bootcamp
Total Requests	4
Total Files	864
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

02. Software Download & Installation/11. Option 2 Downloading And Installing Oracle Database.mp4 195.7 MB
16. Data Manipulation Language (DML) Statements/4. INSERT Statement (Part 2).mp4 178.7 MB
17. Using Oracle FLASHBACK Technologies/2. FLASHBACK Operations (Part 2).mp4 166.7 MB
07. Single-Row Functions/16. Date Values & Date Formats in Oracle.mp4 164.6 MB
12. Joining Multiple Tables/28. Cross Join (Cartesian Product Cross Product).mp4 160.3 MB
16. Data Manipulation Language (DML) Statements/19. MERGE Statement.mp4 158.3 MB
15. Data Definition Language (DDL) Statements/7. ALTER TABLE Statement.mp4 157.7 MB
16. Data Manipulation Language (DML) Statements/29. FOR UPDATE Statement.mp4 154.2 MB
02. Software Download & Installation/13. Option 2 Configuring and Using the SQL Developer.mp4 143.7 MB
05. Sorting Data/1. ORDER BY Clause.mp4 142.1 MB
12. Joining Multiple Tables/37. Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4 140.6 MB
18. Oracle Constraints in SQL/4. UNIQUE Constraint.mp4 137.6 MB
07. Single-Row Functions/17. Date Functions & Arithmetic Operations on Dates.mp4 136.5 MB
09. Conditional Expressions/1. Oracle Conditional Expressions CASE Expressions.mp4 135.9 MB
08. Conversion Functions/7. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4 135.4 MB
13. Using Subqueries/4. Single Row Subqueries.mp4 134.1 MB
08. Conversion Functions/3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4 133.2 MB
23. Working with Oracle Indexes in SQL/1. What is an Index in SQL.mp4 125.5 MB
06. Using Substitution Variables/3. Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4 125.0 MB
16. Data Manipulation Language (DML) Statements/9. Conditional INSERT ALL Statements.mp4 124.0 MB
12. Joining Multiple Tables/30. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4 122.6 MB
18. Oracle Constraints in SQL/8. FOREIGN KEY Constraint (Part 1).mp4 121.7 MB
24. Managing Oracle Privileges and Roles/7. Granting System Privileges.mp4 121.0 MB
14. Working with the Oracle SET Operators/2. UNION and UNION ALL Operators.mp4 119.4 MB
12. Joining Multiple Tables/12. Multiple Join Operations.mp4 119.0 MB
14. Working with the Oracle SET Operators/1. Introduction to SET Operators in Oracle SQL.mp4 117.9 MB
17. Using Oracle FLASHBACK Technologies/6. Tracking Changes In Data In a Particular Time.mp4 116.9 MB
08. Conversion Functions/5. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4 114.7 MB
13. Using Subqueries/14. Correlated Subqueries.mp4 109.1 MB
12. Joining Multiple Tables/34. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4 105.2 MB
16. Data Manipulation Language (DML) Statements/15. UPDATE Statement.mp4 105.1 MB
07. Single-Row Functions/1. Single Row Functions.mp4 105.0 MB
16. Data Manipulation Language (DML) Statements/23. COMMIT and ROLLBACK Statements.mp4 104.5 MB
15. Data Definition Language (DDL) Statements/5. CREATE TABLE AS SELECT (CTAS) Statement in Oracle.mp4 103.5 MB
13. Using Subqueries/6. Multiple Row Subqueries.mp4 102.6 MB
07. Single-Row Functions/8. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4 101.3 MB
03. Retrieving Data/6. SQL Statement Basics.mp4 101.1 MB
02. Software Download & Installation/2. The Ways to Get a Database.mp4 99.5 MB
11. Grouping Data/4. GROUP BY Clause (Part 2).mp4 95.5 MB
02. Software Download & Installation/7. Option 1 Configuring the VMware Virtualization Software.mp4 95.1 MB
24. Managing Oracle Privileges and Roles/12. Granting Object Privileges.mp4 92.7 MB
05. Sorting Data/8. ROWNUM & ROWID in SQL.mp4 92.6 MB
02. Software Download & Installation/14. Option 2 Installing Sample Schemas in Oracle Database.mp4 92.5 MB
12. Joining Multiple Tables/18. Non-Equijoins (Joining Unequal Tables).mp4 89.1 MB
04. Restricting Data/16. Logical Operators (AND, OR, NOT).mp4 88.4 MB
02. Software Download & Installation/3. Option 1 Installing VMware and VirtualBox on Windows.mp4 87.9 MB
17. Using Oracle FLASHBACK Technologies/4. PURGE Operations.mp4 86.3 MB
12. Joining Multiple Tables/31. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4 83.9 MB
07. Single-Row Functions/10. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4 83.4 MB
07. Single-Row Functions/19. Date Manipulation Functions in SQL.mp4 83.3 MB
24. Managing Oracle Privileges and Roles/14. Definer's Rights and Invoker's Rights (Part 1).mp4 83.2 MB
07. Single-Row Functions/14. Nested Functions.mp4 81.1 MB
19. Database Views/9. Performing DML Operations with Views.mp4 80.3 MB
16. Data Manipulation Language (DML) Statements/13. Pivoting Insert.mp4 79.6 MB
15. Data Definition Language (DDL) Statements/2. Naming Rules & Naming Conventions in Oracle.mp4 78.7 MB
22. Oracle Synonyms/2. Creating, Using, and Dropping Synonyms.mp4 78.6 MB
18. Oracle Constraints in SQL/15. Adding Constraints via ALTER TABLE Statements.mp4 78.0 MB
23. Working with Oracle Indexes in SQL/17. How to Modify (Alter) Indexes.mp4 77.5 MB
21. Oracle Sequences/7. Using Sequences.mp4 75.9 MB
23. Working with Oracle Indexes in SQL/2. Index Types in SQL.mp4 75.1 MB
17. Using Oracle FLASHBACK Technologies/1. FLASHBACK Operations (Part 1).mp4 73.5 MB
02. Software Download & Installation/9. Option 1 Configuring SQL Developer inside of the Virtual Machine.mp4 73.4 MB
24. Managing Oracle Privileges and Roles/3. How to Create a User in Oracle Database (Part 2).mp4 73.3 MB
20. Data Dictionary Views/5. USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views.mp4 72.9 MB
18. Oracle Constraints in SQL/6. PRIMARY KEY Constraint.mp4 70.9 MB
24. Managing Oracle Privileges and Roles/18. Revoking Privileges and Roles (Part 2).mp4 70.1 MB
08. Conversion Functions/1. Conversion Functions.mp4 70.0 MB
24. Managing Oracle Privileges and Roles/11. Roles and PUBLIC (Part 2).mp4 69.8 MB
12. Joining Multiple Tables/3. Natural Join.mp4 69.6 MB
12. Joining Multiple Tables/24. RIGHT OUTER JOIN (RIGHT JOIN).mp4 69.3 MB
16. Data Manipulation Language (DML) Statements/7. Unconditional Insert Statements (INSERT ALL Statements).mp4 69.2 MB
15. Data Definition Language (DDL) Statements/17. COMMENT Statement.mp4 69.2 MB
18. Oracle Constraints in SQL/9. FOREIGN KEY Constraint (Part 2).mp4 68.8 MB
07. Single-Row Functions/2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functions.mp4 68.2 MB
18. Oracle Constraints in SQL/23. Disabling Constraints.mp4 67.8 MB
13. Using Subqueries/12. SCALAR Subqueries.mp4 67.8 MB
23. Working with Oracle Indexes in SQL/13. Multiple Indexes on the Same Columns & Invisible Indexes.mp4 67.5 MB
12. Joining Multiple Tables/32. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4 66.5 MB
07. Single-Row Functions/12. Numeric Functions.mp4 66.0 MB
12. Joining Multiple Tables/7. Handling Ambiguous Column Names.mp4 65.8 MB
18. Oracle Constraints in SQL/27. Status of Constraints.mp4 65.0 MB
03. Retrieving Data/22. Arithmetic Expressions and NULL Values.mp4 64.5 MB
13. Using Subqueries/10. Using Subqueries as a Table.mp4 64.1 MB
18. Oracle Constraints in SQL/11. The ON DELETE CASCADE ON DELETE SET NULL Clause.mp4 63.9 MB
07. Single-Row Functions/4. Character Functions - Character Manipulation Functions (Part 1).mp4 63.5 MB
12. Joining Multiple Tables/1. What is a Join & Oracle SQL Join Types.mp4 63.5 MB
16. Data Manipulation Language (DML) Statements/2. INSERT Statement (Part 1).mp4 63.1 MB
11. Grouping Data/1. GROUP BY Clause (Part 1).mp4 62.6 MB
16. Data Manipulation Language (DML) Statements/27. SAVEPOINT Statement.mp4 62.4 MB
12. Joining Multiple Tables/22. LEFT OUTER JOIN (LEFT JOIN).mp4 62.0 MB
18. Oracle Constraints in SQL/30. Deferring Constraints (Part 2).mp4 60.4 MB
04. Restricting Data/4. Comparison Operators.mp4 59.1 MB
07. Single-Row Functions/6. Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp4 56.2 MB
18. Oracle Constraints in SQL/29. Deferring Constraints (Part 1).mp4 55.6 MB
13. Using Subqueries/1. Using Subqueries.mp4 55.5 MB
03. Retrieving Data/16. DISTINCT and UNIQUE Operator.mp4 55.2 MB
06. Using Substitution Variables/1. What is a Substitution Variable.mp4 55.1 MB
02. Software Download & Installation/8. Option 1 Configuring the Oracle VirtualBox Virtualization Software.mp4 55.0 MB
03. Retrieving Data/1. Oracle Data Types.mp4 54.7 MB
23. Working with Oracle Indexes in SQL/15. Analyzing the USER_INDEXES and USER_IND_COLUMNS Views.mp4 54.5 MB
23. Working with Oracle Indexes in SQL/7. How to Create Indexes While Table Creation.mp4 53.9 MB
05. Sorting Data/3. ASC and DESC Operators.mp4 53.8 MB
01. Database Concepts/7. What is a Relational Database (RDBMS).mp4 53.8 MB
12. Joining Multiple Tables/20. OUTER JOINS.mp4 53.4 MB
21. Oracle Sequences/14. Oracle IDENTITY Column (Part 2).mp4 52.6 MB
23. Working with Oracle Indexes in SQL/11. Function-Based Indexes.mp4 52.1 MB
09. Conditional Expressions/3. Oracle Conditional Expressions DECODE Function.mp4 51.3 MB
13. Using Subqueries/8. Multiple Column Subqueries.mp4 51.1 MB
18. Oracle Constraints in SQL/19. Cascading Constraints in Oracle.mp4 51.1 MB
25. Appendix/3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4 50.6 MB
24. Managing Oracle Privileges and Roles/1. What are Privileges in SQL.mp4 50.1 MB
21. Oracle Sequences/13. Oracle IDENTITY Column (Part 1).mp4 49.9 MB
02. Software Download & Installation/1. About the Database Installation.mp4 48.6 MB
19. Database Views/3. Creating Simple Views.mp4 48.5 MB
20. Data Dictionary Views/16. USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views.mp4 48.4 MB
06. Using Substitution Variables/7. SET VERIFY ON SET VERIFY OFF Commands.mp4 48.3 MB
13. Using Subqueries/16. EXISTS Operator & Semijoins.mp4 48.2 MB
06. Using Substitution Variables/5. ACCEPT and PROMPT Commands.mp4 46.8 MB
05. Sorting Data/10. Oracle FETCH Clause.mp4 46.6 MB
01. Database Concepts/11. The Sample (HR) Schema Used in This Course.mp4 46.6 MB
15. Data Definition Language (DDL) Statements/11. READ-ONLY Tables in SQL.mp4 46.6 MB
20. Data Dictionary Views/13. USER_CONS_COLUMNS Data Dictionary View.mp4 46.0 MB
24. Managing Oracle Privileges and Roles/15. Definer's Rights and Invoker's Rights (Part 2).mp4 45.9 MB
03. Retrieving Data/20. Concatenation Operators.mp4 45.7 MB
10. Group Functions/1. Group Functions.mp4 44.4 MB
20. Data Dictionary Views/2. The Dictionary View.mp4 44.3 MB
20. Data Dictionary Views/11. USER_CONSTRAINTS Data Dictionary View.mp4 44.3 MB
25. Appendix/1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp4 44.2 MB
02. Software Download & Installation/18. SQL Statements Used in This Course.mp4 43.2 MB
16. Data Manipulation Language (DML) Statements/11. Conditional INSERT FIRST Statements.mp4 43.1 MB
16. Data Manipulation Language (DML) Statements/21. (TCL) Transaction Control Language & TCL Commands.mp4 43.1 MB
24. Managing Oracle Privileges and Roles/17. Revoking Privileges and Roles (Part 1).mp4 42.9 MB
23. Working with Oracle Indexes in SQL/5. How to Create Indexes (Part 2).mp4 42.4 MB
18. Oracle Constraints in SQL/17. Dropping (Removing) Constraints.mp4 41.3 MB
24. Managing Oracle Privileges and Roles/9. Roles and PUBLIC (Part 1).mp4 41.0 MB
16. Data Manipulation Language (DML) Statements/17. DELETE Statement.mp4 40.3 MB
18. Oracle Constraints in SQL/1. What is a Constraint Oracle Constraint Types.mp4 40.3 MB
19. Database Views/11. Using the WITH CHECK OPTION Clause in SQL.mp4 38.9 MB
14. Working with the Oracle SET Operators/12. Combining Multiple Queries Using the SET Operators.mp4 38.8 MB
01. Database Concepts/2. Why Oracle Database.mp4 38.6 MB
13. Using Subqueries/19. NOT EXISTS Operator.mp4 38.5 MB
03. Retrieving Data/14. Quote (Q) Operator.mp4 38.4 MB
21. Oracle Sequences/9. Using Sequences as a Default Value.mp4 38.3 MB
24. Managing Oracle Privileges and Roles/2. How to Create a User in Oracle Database (Part 1).mp4 38.3 MB
04. Restricting Data/6. BETWEEN … AND Operator.mp4 37.5 MB
04. Restricting Data/19. Rules of Precedence.mp4 37.0 MB
02. Software Download & Installation/6. Option 1 Downloading Virtual Machine Image(If the previous lecture didn't work).mp4 37.0 MB
14. Working with the Oracle SET Operators/10. Using the ORDER BY Clause with SET Operators.mp4 36.3 MB
18. Oracle Constraints in SQL/25. Enabling Constraints.mp4 36.2 MB
23. Working with Oracle Indexes in SQL/3. How to Create Indexes (Part 1).mp4 36.2 MB
11. Grouping Data/6. HAVING Clause.mp4 36.0 MB
10. Group Functions/2. AVG Function.mp4 36.0 MB
10. Group Functions/13. LISTAGG Function.mp4 34.9 MB
15. Data Definition Language (DDL) Statements/15. TRUNCATE TABLE Statement.mp4 34.6 MB
04. Restricting Data/11. LIKE Operator.mp4 34.5 MB
03. Retrieving Data/8. Oracle Error Messages.mp4 34.4 MB
21. Oracle Sequences/2. Creating Sequences.mp4 33.7 MB
10. Group Functions/7. MAX Function.mp4 33.3 MB
15. Data Definition Language (DDL) Statements/3. CREATE TABLE Statement.mp4 32.3 MB
11. Grouping Data/9. Nested Group Functions.mp4 31.9 MB
15. Data Definition Language (DDL) Statements/13. DROP TABLE Statement.mp4 31.3 MB
04. Restricting Data/8. IN Operator.mp4 30.9 MB
18. Oracle Constraints in SQL/13. CHECK Constraint.mp4 30.6 MB
12. Joining Multiple Tables/16. Self Join.mp4 30.3 MB
03. Retrieving Data/3. DESCRIBE Command.mp4 29.3 MB
03. Retrieving Data/4. INFORMATION Command.mp4 29.0 MB
21. Oracle Sequences/12. The User_Sequences View.mp4 27.1 MB
12. Joining Multiple Tables/14. Restricting Joins.mp4 27.1 MB
12. Joining Multiple Tables/9. Inner Join & Join with the ON Clause.mp4 26.7 MB
14. Working with the Oracle SET Operators/8. Matching Unmatched Queries in SET Operations.mp4 26.7 MB
16. Data Manipulation Language (DML) Statements/25. Row Lock in Oracle.mp4 26.6 MB
12. Joining Multiple Tables/5. Join with the USING Clause.mp4 26.2 MB
15. Data Definition Language (DDL) Statements/9. Marking Columns Unused (Using The SET UNUSED Clause).mp4 26.1 MB
03. Retrieving Data/12. Using Column Aliases.mp4 25.9 MB
10. Group Functions/11. SUM Function.mp4 25.6 MB
03. Retrieving Data/2. What is a NULL Value.mp4 25.4 MB
01. Database Concepts/10. Introduction to Database Objects.mp4 25.1 MB
04. Restricting Data/14. IS NULL Operator.mp4 24.4 MB
20. Data Dictionary Views/9. USER_TAB_COLUMNS Data Dictionary View.mp4 23.9 MB
03. Retrieving Data/10. Using SELECT Statements.mp4 23.8 MB
18. Oracle Constraints in SQL/2. NOT NULL Constraint.mp4 23.6 MB
02. Software Download & Installation/16. Option 3 Using Oracle Live SQL.mp4 22.6 MB
15. Data Definition Language (DDL) Statements/19. RENAME Statement.mp4 22.5 MB
01. Database Concepts/8. Entity Relationship Logic in Databases.mp4 22.0 MB
01. Database Concepts/4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4 21.7 MB
19. Database Views/1. What is a View and What is it Used for.mp4 21.3 MB
20. Data Dictionary Views/7. USER_TABLES Data Dictionary View.mp4 20.6 MB
10. Group Functions/4. COUNT Function.mp4 19.7 MB
04. Restricting Data/1. Using WHERE Clause.mp4 19.4 MB
24. Managing Oracle Privileges and Roles/5. Changing Database Users' Passwords in Oracle Database.mp4 19.3 MB
16. Data Manipulation Language (DML) Statements/1. Data Manipulation Language (DML).mp4 18.6 MB
01. Database Concepts/1. What is a Database.mp4 18.4 MB
05. Sorting Data/6. NULLS FIRST and NULLS LAST Operators.mp4 18.0 MB
22. Oracle Synonyms/4. Analyzing The USER_SYNONYMS View.mp4 17.8 MB
14. Working with the Oracle SET Operators/6. MINUS Operator.mp4 17.8 MB
02. Software Download & Installation/12. Option 2 Unlocking the HR Schema.mp4 17.7 MB
21. Oracle Sequences/4. Modifying Sequences.mp4 17.5 MB
01. Database Concepts/12. What is SQL.mp4 17.1 MB
20. Data Dictionary Views/1. What are Data Dictionary Views in Oracle.mp4 16.8 MB
16. Data Manipulation Language (DML) Statements/6. Multitable Insert Statements.mp4 16.5 MB
12. Joining Multiple Tables/26. FULL OUTER JOIN (FULL JOIN).mp4 16.0 MB
19. Database Views/15. Dropping Views.mp4 15.4 MB
15. Data Definition Language (DDL) Statements/1. Data Definition Language (DDL).mp4 15.1 MB
19. Database Views/7. Modifying Views.mp4 14.7 MB
01. Database Concepts/3. What is a Table.mp4 14.7 MB
10. Group Functions/9. MIN Function.mp4 14.4 MB
02. Software Download & Installation/14. sample_schemas.zip 14.0 MB
20. Data Dictionary Views/4. Difference Between USER, ALL, DBA and V$ Prefixes.mp4 13.8 MB
23. Working with Oracle Indexes in SQL/9. How to Remove (Drop) Indexes.mp4 13.1 MB
12. Joining Multiple Tables/36. Which Join Type Should You Use.mp4 13.0 MB
19. Database Views/13. Using the WITH READ ONLY Clause on Views.mp4 12.8 MB
10. Group Functions/15. Overview Of Group Functions.mp4 12.5 MB
20. Data Dictionary Views/15. USER_VIEWS Data Dictionary View.mp4 12.2 MB
12. Joining Multiple Tables/2. Creating a Join.mp4 12.0 MB
01. Database Concepts/9. What is Pluggable Database.mp4 11.9 MB
18. Oracle Constraints in SQL/21. Renaming Constraints.mp4 11.6 MB
14. Working with the Oracle SET Operators/4. INTERSECT Operator.mp4 11.3 MB
21. Oracle Sequences/1. What is a Sequence.mp4 11.0 MB
22. Oracle Synonyms/1. What is a Synonym.mp4 11.0 MB
19. Database Views/5. Creating Complex Views.mp4 10.9 MB
21. Oracle Sequences/11. Sequence Caching.mp4 7.7 MB
26. Conclusion/3. Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam 18.06.2017.pdf 6.8 MB
19. Database Views/2. View Types in Oracle.mp4 6.6 MB
21. Oracle Sequences/6. Dropping Sequences.mp4 3.9 MB
01. Database Concepts/6. SQL Cheatsheet (Oracle Master).pdf 3.6 MB
26. Conclusion/2. SQL Cheatsheet (Oracle Master).pdf 3.6 MB
01. Database Concepts/6. Oracle Database - OCA Certification (1Z0-071) Exam (2018-06-30).pdf 2.0 MB
26. Conclusion/3. Oracle-Database-12c-Database-SQL-1Z0-071-Exam 2018-06-30.pdf 2.0 MB
26. Conclusion/3. Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam 04.03.2017.pdf 1.6 MB
01. Database Concepts/6. Oracle Database - SQL Fundamentals (1Z0-061) Exam (04.03.2017).pdf 1.6 MB
02. Software Download & Installation/3. How to Download the VMware Workstation Player.pdf 1.2 MB
01. Database Concepts/5. 2020-01-16_19-46-13-f55f6f39ef0e59c2d7bb8a7b7dacfefc.gif 717.4 KB
02. Software Download & Installation/19. 2020-01-16_19-47-57-f82ccadaf66b3a9aa3cd221a9b6a9f4a.gif 717.4 KB
02. Software Download & Installation/4. 2019-11-13_08-44-17-36ec1d2b01a9239e4fb53274ad363120.gif 717.4 KB
25. Appendix/2. 2019-11-13_08-30-27-6394965f16e448587bb6f8c7eec9bf39.gif 717.4 KB
26. Conclusion/2. 2019-11-14_21-59-28-5fde1c718751a99c55622a5befa12b99.gif 717.4 KB
01. Database Concepts/6. Oracle Database - OCA Certification (1Z0-071) Exam (2018-07-12).pdf 574.4 KB
26. Conclusion/3. Oracle-Database-12c-Database-SQL-1Z0-071-Exam 2016-07-12.pdf 574.4 KB
24. Managing Oracle Privileges and Roles/20. Searching Privileges Using Data Dictionary Views.pdf 401.6 KB
25. Appendix/5. 2023-03-09_20-15-59-6893e79d34f7828cbc1abe86076226d4.png 320.0 KB
25. Appendix/4. 2021-07-28_12-31-00-c1f25cee46bc8defab09a5876ff965a0.png 254.1 KB
01. Database Concepts/6. 2023-01-16_23-03-37-be355a434fc137422d5c3cecf98a144c.gif 250.2 KB
26. Conclusion/4. 2021-02-07_21-17-19-4f51f29f49c17985b493595b0066d0c3.png 238.9 KB
26. Conclusion/4. 2025-01-06_06-33-37-5cd2387cfe5f9dcd73f9cf6959cf62c4.png 235.8 KB
01. Database Concepts/11. HR-Schema-Relationship.png 233.1 KB
02. Software Download & Installation/12. (Oracle Master Training) - Scripts to Unlock the HR Schema.pdf 230.8 KB
25. Appendix/5. 2023-03-09_20-15-59-1e27dd72b386f597bae8e49bb9ad2cdf.png 149.2 KB
24. Managing Oracle Privileges and Roles/20. 2023-02-03_14-56-45-c9f8f5aa2af3ece51add7821b0ff9340.png 144.9 KB
25. Appendix/5. 2023-03-09_20-16-00-62499a9ba27d21bc0db4803a4cb3c4c1.png 144.7 KB
26. Conclusion/4. 2021-02-07_21-17-25-c0ba87930833bc641f45c7cbd82bb828.png 134.4 KB
25. Appendix/5. 2023-03-09_20-16-00-bfa0d37879dd85d7f5e1b57359cad4ad.png 126.7 KB
26. Conclusion/4. 2021-02-07_21-17-02-906d81b6bdffc5aafbd8a8c09566cd82.png 126.5 KB
26. Conclusion/4. 2021-02-07_21-17-30-c8b778be2a98b9ca9875983888d33ac3.png 78.2 KB
26. Conclusion/4. 2021-02-07_21-16-55-99e2b39489ab6bd2dc268fe6482e53cf.png 73.5 KB
02. Software Download & Installation/15. HR Schema Create Code.sql 70.3 KB
02. Software Download & Installation/15. Option 2 HR Schema Create Code (if you could not get the HR user in other ways).html 69.8 KB
02. Software Download & Installation/19. students-review.png 57.8 KB
01. Database Concepts/6. 2018-05-15_11-06-45-92263958fe07de76c280b5bc9e1bc9aa.png 33.0 KB
23. Working with Oracle Indexes in SQL/19.21 Quiz (Indexes).html 32.4 KB
12. Joining Multiple Tables/38.10 Quiz (Joining Multiple Tables).html 31.6 KB
24. Managing Oracle Privileges and Roles/21.22 Quiz (Privileges & Roles).html 30.0 KB
07. Single-Row Functions/16. Date Values & Date Formats in Oracle.vtt 28.3 KB
18. Oracle Constraints in SQL/4. UNIQUE Constraint.vtt 28.0 KB
09. Conditional Expressions/1. Oracle Conditional Expressions CASE Expressions.vtt 26.4 KB
04. Restricting Data/23.3 Quiz (Restricting Data).html 25.8 KB
07. Single-Row Functions/8. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).vtt 25.4 KB
13. Using Subqueries/21.11 Quiz (Using Subqueries).html 24.7 KB
11. Grouping Data/11.9 Quiz (Grouping Data).html 24.3 KB
17. Using Oracle FLASHBACK Technologies/8.15 Quiz (Flashback Technologies).html 24.2 KB
21. Oracle Sequences/16.19 Quiz (Sequences).html 24.2 KB
16. Data Manipulation Language (DML) Statements/19. MERGE Statement.vtt 23.7 KB
08. Conversion Functions/7. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.vtt 23.3 KB
08. Conversion Functions/9.6 Quiz (Conversion Functions).html 23.2 KB
09. Conditional Expressions/5.7 Quiz (Conditional Expressions).html 23.1 KB
07. Single-Row Functions/19. Date Manipulation Functions in SQL.vtt 23.0 KB
02. Software Download & Installation/13. Option 2 Configuring and Using the SQL Developer.vtt 22.9 KB
13. Using Subqueries/6. Multiple Row Subqueries.vtt 22.8 KB
18. Oracle Constraints in SQL/32.16 Quiz (Constraints).html 22.7 KB
14. Working with the Oracle SET Operators/14.12 Quiz (Set Operators).html 22.5 KB
16. Data Manipulation Language (DML) Statements/4. INSERT Statement (Part 2).vtt 22.3 KB
12. Joining Multiple Tables/37. Entity-Relationship Models in DBMS - How to Use Them with Joins.vtt 22.3 KB
01. Database Concepts/13.1 Quiz (Database Concepts).html 21.9 KB
12. Joining Multiple Tables/28. Cross Join (Cartesian Product Cross Product).vtt 21.8 KB
07. Single-Row Functions/21.5 Quiz (Single-Row Functions).html 21.6 KB
05. Sorting Data/13.4 Quiz (Sorting Data).html 21.5 KB
15. Data Definition Language (DDL) Statements/7. ALTER TABLE Statement.vtt 21.4 KB
16. Data Manipulation Language (DML) Statements/31.14 Quiz (Data Manipulation Language).html 21.2 KB
03. Retrieving Data/25.2 Quiz (Retrieving Data).html 21.2 KB
10. Group Functions/17.8 Quiz (Group Functions).html 21.1 KB
20. Data Dictionary Views/18.18 Quiz (Data Dictionary Views).html 20.9 KB
19. Database Views/17.17 Quiz (Views).html 20.9 KB
15. Data Definition Language (DDL) Statements/21.13 Quiz (Data Definition Language).html 20.9 KB
22. Oracle Synonyms/2. Creating, Using, and Dropping Synonyms.vtt 20.8 KB
13. Using Subqueries/8. Multiple Column Subqueries.vtt 20.5 KB
25. Appendix/4. 2021-07-28_12-33-55-bd9091405377882a86141d063ae8a8c7.png 20.1 KB
25. Appendix/4. 2021-07-28_12-32-49-bf8f77c403ae854d0a92712895813d85.png 19.8 KB
07. Single-Row Functions/17. Date Functions & Arithmetic Operations on Dates.vtt 19.8 KB
07. Single-Row Functions/12. Numeric Functions.vtt 19.8 KB
06. Using Substitution Variables/3. Double Ampersand (&&) and DEFINE & UNDEFINE Commands.vtt 19.8 KB
16. Data Manipulation Language (DML) Statements/29. FOR UPDATE Statement.vtt 19.8 KB
22. Oracle Synonyms/6.20 Quiz (Synonyms).html 19.6 KB
12. Joining Multiple Tables/31. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).vtt 19.5 KB
17. Using Oracle FLASHBACK Technologies/2. FLASHBACK Operations (Part 2).vtt 19.5 KB
02. Software Download & Installation/11. Option 2 Downloading And Installing Oracle Database.vtt 19.4 KB
11. Grouping Data/1. GROUP BY Clause (Part 1).vtt 19.4 KB
14. Working with the Oracle SET Operators/1. Introduction to SET Operators in Oracle SQL.vtt 19.2 KB
08. Conversion Functions/3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).vtt 19.0 KB
02. Software Download & Installation/2. The Ways to Get a Database.vtt 18.9 KB
24. Managing Oracle Privileges and Roles/7. Granting System Privileges.vtt 18.7 KB
13. Using Subqueries/12. SCALAR Subqueries.vtt 18.2 KB
13. Using Subqueries/14. Correlated Subqueries.vtt 18.1 KB
08. Conversion Functions/5. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).vtt 18.0 KB
23. Working with Oracle Indexes in SQL/1. What is an Index in SQL.vtt 18.0 KB
25. Appendix/4. 2021-07-28_12-33-19-133b255e9ab9947014826c0288246c5d.png 17.8 KB
07. Single-Row Functions/14. Nested Functions.vtt 17.7 KB
24. Managing Oracle Privileges and Roles/11. Roles and PUBLIC (Part 2).vtt 17.4 KB
12. Joining Multiple Tables/34. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.vtt 17.4 KB
05. Sorting Data/1. ORDER BY Clause.vtt 17.3 KB
14. Working with the Oracle SET Operators/2. UNION and UNION ALL Operators.vtt 17.2 KB
24. Managing Oracle Privileges and Roles/12. Granting Object Privileges.vtt 17.1 KB
07. Single-Row Functions/2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functions.vtt 16.8 KB
16. Data Manipulation Language (DML) Statements/2. INSERT Statement (Part 1).vtt 16.7 KB
23. Working with Oracle Indexes in SQL/13. Multiple Indexes on the Same Columns & Invisible Indexes.vtt 16.6 KB
16. Data Manipulation Language (DML) Statements/27. SAVEPOINT Statement.vtt 16.5 KB
13. Using Subqueries/4. Single Row Subqueries.vtt 16.3 KB
24. Managing Oracle Privileges and Roles/15. Definer's Rights and Invoker's Rights (Part 2).vtt 16.2 KB
18. Oracle Constraints in SQL/8. FOREIGN KEY Constraint (Part 1).vtt 16.1 KB
24. Managing Oracle Privileges and Roles/14. Definer's Rights and Invoker's Rights (Part 1).vtt 16.1 KB
23. Working with Oracle Indexes in SQL/2. Index Types in SQL.vtt 15.9 KB
17. Using Oracle FLASHBACK Technologies/6. Tracking Changes In Data In a Particular Time.vtt 15.9 KB
12. Joining Multiple Tables/30. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).vtt 15.8 KB
16. Data Manipulation Language (DML) Statements/9. Conditional INSERT ALL Statements.vtt 15.6 KB
07. Single-Row Functions/4. Character Functions - Character Manipulation Functions (Part 1).vtt 15.6 KB
06. Using Substitution Variables/1. What is a Substitution Variable.vtt 15.6 KB
12. Joining Multiple Tables/18. Non-Equijoins (Joining Unequal Tables).vtt 15.6 KB
23. Working with Oracle Indexes in SQL/7. How to Create Indexes While Table Creation.vtt 15.5 KB
02. Software Download & Installation/9. Option 1 Configuring SQL Developer inside of the Virtual Machine.vtt 15.4 KB
17. Using Oracle FLASHBACK Technologies/1. FLASHBACK Operations (Part 1).vtt 15.2 KB
21. Oracle Sequences/14. Oracle IDENTITY Column (Part 2).vtt 15.2 KB
07. Single-Row Functions/1. Single Row Functions.vtt 15.1 KB
16. Data Manipulation Language (DML) Statements/23. COMMIT and ROLLBACK Statements.vtt 14.9 KB
12. Joining Multiple Tables/22. LEFT OUTER JOIN (LEFT JOIN).vtt 14.8 KB
05. Sorting Data/10. Oracle FETCH Clause.vtt 14.7 KB
13. Using Subqueries/16. EXISTS Operator & Semijoins.vtt 14.4 KB
19. Database Views/3. Creating Simple Views.vtt 14.1 KB
18. Oracle Constraints in SQL/6. PRIMARY KEY Constraint.vtt 14.1 KB
15. Data Definition Language (DDL) Statements/5. CREATE TABLE AS SELECT (CTAS) Statement in Oracle.vtt 14.1 KB
11. Grouping Data/4. GROUP BY Clause (Part 2).vtt 14.0 KB
01. Database Concepts/10. Introduction to Database Objects.vtt 13.9 KB
03. Retrieving Data/6. SQL Statement Basics.vtt 13.8 KB
07. Single-Row Functions/10. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).vtt 13.7 KB
04. Restricting Data/16. Logical Operators (AND, OR, NOT).vtt 13.7 KB
24. Managing Oracle Privileges and Roles/3. How to Create a User in Oracle Database (Part 2).vtt 13.5 KB
12. Joining Multiple Tables/12. Multiple Join Operations.vtt 13.5 KB
08. Conversion Functions/1. Conversion Functions.vtt 13.5 KB
15. Data Definition Language (DDL) Statements/2. Naming Rules & Naming Conventions in Oracle.vtt 13.4 KB
18. Oracle Constraints in SQL/15. Adding Constraints via ALTER TABLE Statements.vtt 13.4 KB
16. Data Manipulation Language (DML) Statements/15. UPDATE Statement.vtt 13.2 KB
05. Sorting Data/8. ROWNUM & ROWID in SQL.vtt 13.1 KB
24. Managing Oracle Privileges and Roles/9. Roles and PUBLIC (Part 1).vtt 12.7 KB
12. Joining Multiple Tables/7. Handling Ambiguous Column Names.vtt 12.6 KB
16. Data Manipulation Language (DML) Statements/7. Unconditional Insert Statements (INSERT ALL Statements).vtt 12.6 KB
12. Joining Multiple Tables/32. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).vtt 12.5 KB
07. Single-Row Functions/6. Character Functions - Character Manipulation Functions Part 2 (INSTR Function).vtt 12.5 KB
23. Working with Oracle Indexes in SQL/17. How to Modify (Alter) Indexes.vtt 12.2 KB
15. Data Definition Language (DDL) Statements/15. TRUNCATE TABLE Statement.vtt 12.2 KB
21. Oracle Sequences/7. Using Sequences.vtt 12.1 KB
18. Oracle Constraints in SQL/23. Disabling Constraints.vtt 12.0 KB
18. Oracle Constraints in SQL/9. FOREIGN KEY Constraint (Part 2).vtt 12.0 KB
17. Using Oracle FLASHBACK Technologies/4. PURGE Operations.vtt 11.8 KB
04. Restricting Data/11. LIKE Operator.vtt 11.8 KB
18. Oracle Constraints in SQL/29. Deferring Constraints (Part 1).vtt 11.8 KB
20. Data Dictionary Views/11. USER_CONSTRAINTS Data Dictionary View.vtt 11.6 KB
24. Managing Oracle Privileges and Roles/18. Revoking Privileges and Roles (Part 2).vtt 11.6 KB
12. Joining Multiple Tables/3. Natural Join.vtt 11.6 KB
21. Oracle Sequences/2. Creating Sequences.vtt 11.5 KB
18. Oracle Constraints in SQL/27. Status of Constraints.vtt 11.5 KB
10. Group Functions/13. LISTAGG Function.vtt 11.4 KB
16. Data Manipulation Language (DML) Statements/13. Pivoting Insert.vtt 11.4 KB
10. Group Functions/2. AVG Function.vtt 11.3 KB
03. Retrieving Data/22. Arithmetic Expressions and NULL Values.vtt 11.2 KB
15. Data Definition Language (DDL) Statements/17. COMMENT Statement.vtt 11.2 KB
18. Oracle Constraints in SQL/30. Deferring Constraints (Part 2).vtt 11.1 KB
23. Working with Oracle Indexes in SQL/5. How to Create Indexes (Part 2).vtt 11.0 KB
15. Data Definition Language (DDL) Statements/3. CREATE TABLE Statement.vtt 10.8 KB
04. Restricting Data/8. IN Operator.vtt 10.7 KB
15. Data Definition Language (DDL) Statements/9. Marking Columns Unused (Using The SET UNUSED Clause).vtt 10.6 KB
19. Database Views/9. Performing DML Operations with Views.vtt 10.6 KB
09. Conditional Expressions/3. Oracle Conditional Expressions DECODE Function.vtt 10.5 KB
04. Restricting Data/19. Rules of Precedence.vtt 10.4 KB
16. Data Manipulation Language (DML) Statements/25. Row Lock in Oracle.vtt 10.4 KB
19. Database Views/11. Using the WITH CHECK OPTION Clause in SQL.vtt 10.4 KB
21. Oracle Sequences/13. Oracle IDENTITY Column (Part 1).vtt 10.4 KB
24. Managing Oracle Privileges and Roles/2. How to Create a User in Oracle Database (Part 1).vtt 10.3 KB
05. Sorting Data/3. ASC and DESC Operators.vtt 10.3 KB
15. Data Definition Language (DDL) Statements/13. DROP TABLE Statement.vtt 10.3 KB
23. Working with Oracle Indexes in SQL/3. How to Create Indexes (Part 1).vtt 10.2 KB
25. Appendix/3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.vtt 10.2 KB
10. Group Functions/1. Group Functions.vtt 10.2 KB
18. Oracle Constraints in SQL/11. The ON DELETE CASCADE ON DELETE SET NULL Clause.vtt 10.1 KB
25. Appendix/1. Appendix 1 Oracle Database 12c Installation into Your Computer.vtt 10.0 KB
12. Joining Multiple Tables/24. RIGHT OUTER JOIN (RIGHT JOIN).vtt 10.0 KB
18. Oracle Constraints in SQL/13. CHECK Constraint.vtt 9.8 KB
12. Joining Multiple Tables/20. OUTER JOINS.vtt 9.6 KB
11. Grouping Data/6. HAVING Clause.vtt 9.5 KB
13. Using Subqueries/10. Using Subqueries as a Table.vtt 9.5 KB
18. Oracle Constraints in SQL/1. What is a Constraint Oracle Constraint Types.vtt 9.5 KB
13. Using Subqueries/1. Using Subqueries.vtt 9.3 KB
12. Joining Multiple Tables/1. What is a Join & Oracle SQL Join Types.vtt 9.2 KB
03. Retrieving Data/4. INFORMATION Command.vtt 8.9 KB
02. Software Download & Installation/7. Option 1 Configuring the VMware Virtualization Software.vtt 8.9 KB
03. Retrieving Data/14. Quote (Q) Operator.vtt 8.9 KB
14. Working with the Oracle SET Operators/10. Using the ORDER BY Clause with SET Operators.vtt 8.9 KB
20. Data Dictionary Views/5. USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views.vtt 8.8 KB
15. Data Definition Language (DDL) Statements/11. READ-ONLY Tables in SQL.vtt 8.4 KB
03. Retrieving Data/20. Concatenation Operators.vtt 8.3 KB
01. Database Concepts/1. What is a Database.vtt 8.3 KB
23. Working with Oracle Indexes in SQL/11. Function-Based Indexes.vtt 8.3 KB
20. Data Dictionary Views/2. The Dictionary View.vtt 8.2 KB
02. Software Download & Installation/14. Option 2 Installing Sample Schemas in Oracle Database.vtt 8.2 KB
06. Using Substitution Variables/5. ACCEPT and PROMPT Commands.vtt 8.1 KB
01. Database Concepts/7. What is a Relational Database (RDBMS).vtt 8.1 KB
20. Data Dictionary Views/9. USER_TAB_COLUMNS Data Dictionary View.vtt 8.1 KB
03. Retrieving Data/16. DISTINCT and UNIQUE Operator.vtt 8.1 KB
02. Software Download & Installation/12. Option 2 Unlocking the HR Schema.vtt 8.1 KB
24. Managing Oracle Privileges and Roles/17. Revoking Privileges and Roles (Part 1).vtt 8.1 KB
01. Database Concepts/2. Why Oracle Database.vtt 8.1 KB
06. Using Substitution Variables/7. SET VERIFY ON SET VERIFY OFF Commands.vtt 7.9 KB
01. Database Concepts/11. The Sample (HR) Schema Used in This Course.vtt 7.9 KB
02. Software Download & Installation/3. Option 1 Installing VMware and VirtualBox on Windows.vtt 7.9 KB
18. Oracle Constraints in SQL/2. NOT NULL Constraint.vtt 7.9 KB
16. Data Manipulation Language (DML) Statements/21. (TCL) Transaction Control Language & TCL Commands.vtt 7.8 KB
12. Joining Multiple Tables/9. Inner Join & Join with the ON Clause.vtt 7.7 KB
23. Working with Oracle Indexes in SQL/15. Analyzing the USER_INDEXES and USER_IND_COLUMNS Views.vtt 7.7 KB
18. Oracle Constraints in SQL/17. Dropping (Removing) Constraints.vtt 7.7 KB
10. Group Functions/4. COUNT Function.vtt 7.6 KB
02. Software Download & Installation/8. Option 1 Configuring the Oracle VirtualBox Virtualization Software.vtt 7.6 KB
13. Using Subqueries/19. NOT EXISTS Operator.vtt 7.5 KB
16. Data Manipulation Language (DML) Statements/11. Conditional INSERT FIRST Statements.vtt 7.5 KB
02. Software Download & Installation/16. Option 3 Using Oracle Live SQL.vtt 7.5 KB
03. Retrieving Data/12. Using Column Aliases.vtt 7.5 KB
20. Data Dictionary Views/16. USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views.vtt 7.3 KB
21. Oracle Sequences/9. Using Sequences as a Default Value.vtt 7.2 KB
14. Working with the Oracle SET Operators/8. Matching Unmatched Queries in SET Operations.vtt 7.2 KB
03. Retrieving Data/1. Oracle Data Types.vtt 7.2 KB
03. Retrieving Data/10. Using SELECT Statements.vtt 7.2 KB
04. Restricting Data/4. Comparison Operators.vtt 7.1 KB
14. Working with the Oracle SET Operators/12. Combining Multiple Queries Using the SET Operators.vtt 7.1 KB
03. Retrieving Data/8. Oracle Error Messages.vtt 7.1 KB
12. Joining Multiple Tables/16. Self Join.vtt 6.9 KB
18. Oracle Constraints in SQL/19. Cascading Constraints in Oracle.vtt 6.9 KB
19. Database Views/15. Dropping Views.vtt 6.7 KB
18. Oracle Constraints in SQL/25. Enabling Constraints.vtt 6.7 KB
15. Data Definition Language (DDL) Statements/19. RENAME Statement.vtt 6.6 KB
16. Data Manipulation Language (DML) Statements/1. Data Manipulation Language (DML).vtt 6.5 KB
12. Joining Multiple Tables/5. Join with the USING Clause.vtt 6.5 KB
24. Managing Oracle Privileges and Roles/5. Changing Database Users' Passwords in Oracle Database.vtt 6.3 KB
20. Data Dictionary Views/13. USER_CONS_COLUMNS Data Dictionary View.vtt 6.3 KB
24. Managing Oracle Privileges and Roles/1. What are Privileges in SQL.vtt 6.1 KB
20. Data Dictionary Views/1. What are Data Dictionary Views in Oracle.vtt 6.1 KB
22. Oracle Synonyms/4. Analyzing The USER_SYNONYMS View.vtt 5.9 KB
04. Restricting Data/6. BETWEEN … AND Operator.vtt 5.9 KB
19. Database Views/1. What is a View and What is it Used for.vtt 5.8 KB
04. Restricting Data/14. IS NULL Operator.vtt 5.7 KB
03. Retrieving Data/2. What is a NULL Value.vtt 5.6 KB
01. Database Concepts/12. What is SQL.vtt 5.4 KB
01. Database Concepts/4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).vtt 5.4 KB
16. Data Manipulation Language (DML) Statements/17. DELETE Statement.vtt 5.3 KB
02. Software Download & Installation/18. SQL Statements Used in This Course.vtt 5.3 KB
15. Data Definition Language (DDL) Statements/1. Data Definition Language (DDL).vtt 5.3 KB
21. Oracle Sequences/4. Modifying Sequences.vtt 5.3 KB
22. Oracle Synonyms/1. What is a Synonym.vtt 5.2 KB
12. Joining Multiple Tables/11.13 Write a SQL Query Returning the Distribution of Orders Based on the Gender and Order Mode.html 5.2 KB
20. Data Dictionary Views/7. USER_TABLES Data Dictionary View.vtt 5.2 KB
10. Group Functions/7. MAX Function.vtt 5.1 KB
11. Grouping Data/9. Nested Group Functions.vtt 5.0 KB
10. Group Functions/9. MIN Function.vtt 4.9 KB
20. Data Dictionary Views/4. Difference Between USER, ALL, DBA and V$ Prefixes.vtt 4.9 KB
13. Using Subqueries/18.15 Write a SQL Query to Find the Customers who Paid over 100000 for One Order.html 4.9 KB
19. Database Views/7. Modifying Views.vtt 4.8 KB
12. Joining Multiple Tables/36. Which Join Type Should You Use.vtt 4.8 KB
04. Restricting Data/1. Using WHERE Clause.vtt 4.7 KB
14. Working with the Oracle SET Operators/6. MINUS Operator.vtt 4.6 KB
04. Restricting Data/18.6 Return the managers who earn less than 10000.html 4.6 KB
04. Restricting Data/10.4 Type a SQL Query which Returns the Employees who Work as Sales People.html 4.6 KB
02. Software Download & Installation/1. About the Database Installation.vtt 4.6 KB
05. Sorting Data/12.9 Bring the second top 10 orders.html 4.5 KB
03. Retrieving Data/3. DESCRIBE Command.vtt 4.5 KB
04. Restricting Data/21.7 A Challenging Exercise on the Rules of Precedence.html 4.5 KB
10. Group Functions/15. Overview Of Group Functions.vtt 4.5 KB
05. Sorting Data/5.8 It's Time Order the Rows.html 4.5 KB
03. Retrieving Data/24.2 Write a SQL Query to Calculate New Salaries.html 4.5 KB
12. Joining Multiple Tables/26. FULL OUTER JOIN (FULL JOIN).vtt 4.5 KB
11. Grouping Data/3.11 Type a SQL Query Returning the Number of Distinct Job ID Values for Each Department.html 4.4 KB
05. Sorting Data/6. NULLS FIRST and NULLS LAST Operators.vtt 4.4 KB
10. Group Functions/11. SUM Function.vtt 4.4 KB
13. Using Subqueries/3.14 Return the employees who work at the same department with Douglas.html 4.3 KB
04. Restricting Data/13.5 Return all the managers based on their job titles.html 4.3 KB
02. Software Download & Installation/6. Option 1 Downloading Virtual Machine Image(If the previous lecture didn't work).vtt 4.3 KB
10. Group Functions/6.10 Write a SQL query returning the number of married male customers.html 4.3 KB
18. Oracle Constraints in SQL/21. Renaming Constraints.vtt 4.3 KB
20. Data Dictionary Views/15. USER_VIEWS Data Dictionary View.vtt 4.2 KB
11. Grouping Data/8.12 Type a SQL Query Returns Departments which Have more than 10 employees.html 4.2 KB
04. Restricting Data/3.3 Write a SQL Query to Fetch the Employees Working as Sales Managers.html 4.2 KB
19. Database Views/13. Using the WITH READ ONLY Clause on Views.vtt 4.2 KB
12. Joining Multiple Tables/33. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Code Samples).html 4.1 KB
12. Joining Multiple Tables/33. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Code Samples).sql 4.1 KB
02. Software Download & Installation/4. Option 1 How to Install the Virtual Box on Mac OS X.html 4.1 KB
21. Oracle Sequences/12. The User_Sequences View.vtt 4.1 KB
12. Joining Multiple Tables/14. Restricting Joins.vtt 4.1 KB
03. Retrieving Data/18.1 Write a SQL Query that Returns All the Possible Product Status Values.html 4.1 KB
01. Database Concepts/8. Entity Relationship Logic in Databases.vtt 4.0 KB
21. Oracle Sequences/1. What is a Sequence.vtt 3.8 KB
12. Joining Multiple Tables/2. Creating a Join.vtt 3.8 KB
16. Data Manipulation Language (DML) Statements/6. Multitable Insert Statements.vtt 3.8 KB
14. Working with the Oracle SET Operators/4. INTERSECT Operator.vtt 3.7 KB
01. Database Concepts/3. What is a Table.vtt 3.7 KB
21. Oracle Sequences/11. Sequence Caching.vtt 3.6 KB
23. Working with Oracle Indexes in SQL/8. How to Create Indexes While Table Creation (Code Samples).html 3.4 KB
23. Working with Oracle Indexes in SQL/8. How to Create Indexes While Table Creation (Code Samples).sql 3.4 KB
19. Database Views/5. Creating Complex Views.vtt 3.4 KB
23. Working with Oracle Indexes in SQL/9. How to Remove (Drop) Indexes.vtt 3.4 KB
01. Database Concepts/9. What is Pluggable Database.vtt 3.4 KB
18. Oracle Constraints in SQL/10. FOREIGN KEY Constraint (Code Samples).sql 3.3 KB
18. Oracle Constraints in SQL/10. FOREIGN KEY Constraint (Code Samples).html 3.2 KB
07. Single-Row Functions/5. Character Manipulation Functions (Part 1) (Code Samples).html 3.2 KB
07. Single-Row Functions/5. Character Manipulation Functions (Part 1) (Code Samples).sql 3.2 KB
19. Database Views/2. View Types in Oracle.vtt 3.2 KB
25. Appendix/2. Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c.html 3.1 KB
08. Conversion Functions/4. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1) (Code Samples).html 2.9 KB
14. Working with the Oracle SET Operators/11. Using the ORDER BY Clause with SET Operators (Code Samples).html 2.9 KB
08. Conversion Functions/4. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1) (Code Samples).sql 2.9 KB
14. Working with the Oracle SET Operators/11. Using the ORDER BY Clause with SET Operators (Code Samples).sql 2.9 KB
16. Data Manipulation Language (DML) Statements/10. Conditional INSERT ALL Statements (Code Samples).html 2.8 KB
16. Data Manipulation Language (DML) Statements/10. Conditional INSERT ALL Statements (Code Samples).sql 2.7 KB
12. Joining Multiple Tables/35. Differences Between Inner Joins-Outer Joins, Equijoins-Non-Equijoins (Code).html 2.7 KB
12. Joining Multiple Tables/35. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins (Code Samples).sql 2.6 KB
12. Joining Multiple Tables/34. Source Code - Differences Between All Types of Joins.sql 2.6 KB
24. Managing Oracle Privileges and Roles/16. Definer's Rights and Invoker's Rights (Code Samples).html 2.6 KB
24. Managing Oracle Privileges and Roles/16. Definer's Rights and Invoker's Rights (Code Samples).sql 2.5 KB
14. Working with the Oracle SET Operators/12. Source Code - Combining Multiple Queries Using the SET Operators.sql 2.5 KB
26. Conclusion/4. Bonus Lecture.html 2.4 KB
13. Using Subqueries/7. Multiple Row Subqueries (Code Samples).html 2.3 KB
13. Using Subqueries/7. Multiple Row Subqueries(Code Samples).sql 2.3 KB
09. Conditional Expressions/2. Oracle Conditional Expressions CASE Expressions (Code Samples).html 2.2 KB
09. Conditional Expressions/2. Oracle Conditional Expressions- CASE Expressions (Code Samples).sql 2.2 KB
13. Using Subqueries/5. Single Row Subqueries (Code Samples).html 2.2 KB
13. Using Subqueries/15. Correlated Subqueries (Code Samples).html 2.2 KB
13. Using Subqueries/5. Single Row Subqueries(Code Samples).sql 2.2 KB
13. Using Subqueries/15. CORRELATED Subqueries (Code Samples).sql 2.1 KB
12. Joining Multiple Tables/29. Cross Join (Cartesian Product Cross Product) (Code Samples).html 2.1 KB
12. Joining Multiple Tables/29. Cross Join (Cartesian Product Cross Product)(Code Samples).sql 2.1 KB
16. Data Manipulation Language (DML) Statements/20. MERGE Statement (Code Samples).html 2.0 KB
21. Oracle Sequences/13. IDENTITY Column Source Code.txt 2.0 KB
18. Oracle Constraints in SQL/12. The ON DELETE CASCADE ON DELETE SET NULL Clause (Code Samples).html 2.0 KB
16. Data Manipulation Language (DML) Statements/20. MERGE Statement (Code Samples).sql 2.0 KB
18. Oracle Constraints in SQL/12. The ON DELETE CASCADE ON DELETE SET NULL Clause (Code Samples).sql 2.0 KB
07. Single-Row Functions/9. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions) (Code Samples).html 2.0 KB
14. Working with the Oracle SET Operators/13. Combining Multiple Queries Using the SET Operators (Code Samples).html 2.0 KB
07. Single-Row Functions/9. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)(Code Samples).sql 2.0 KB
14. Working with the Oracle SET Operators/13. Combining Multiple Queries Using the SET Operators (Code Samples).sql 1.9 KB
19. Database Views/10. Performing DML Operations with Views (Code Samples).html 1.9 KB
19. Database Views/10. Performing DML Operations with Views (Code Samples).sql 1.9 KB
13. Using Subqueries/9. Multiple Column Subqueries (Code Samples).html 1.9 KB
18. Oracle Constraints in SQL/5. UNIQUE Constraint (Code Samples).html 1.9 KB
19. Database Views/12. Using the WITH CHECK OPTION Clause in SQL (Code Samples).html 1.9 KB
12. Joining Multiple Tables/13. Multiple Join Operations (Code Samples).html 1.8 KB
19. Database Views/12. Using the WITH CHECK OPTION Clause in SQL (Code Samples).sql 1.8 KB
12. Joining Multiple Tables/13. Multiple Join Operations (Code Samples).sql 1.8 KB
18. Oracle Constraints in SQL/5. UNIQUE Constraint (Code Samples).sql 1.8 KB
21. Oracle Sequences/6. Dropping Sequences.vtt 1.8 KB
25. Appendix/4. Appendix 4 How to Uninstall Oracle Database.html 1.8 KB
12. Joining Multiple Tables/8. Handling Ambiguous Column Names (Code Samples).html 1.8 KB
10. Group Functions/14. LISTAGG Function (Code Samples).html 1.8 KB
10. Group Functions/14. LISTAGG Function (Code Samples).sql 1.8 KB
25. Appendix/5. How to Enroll in Oracle 1Z0-071 SQL Associate Certification Exam.html 1.8 KB
02. Software Download & Installation/5. Option 1 Downloading Virtual Machine Image (19c).html 1.7 KB
12. Joining Multiple Tables/25. RIGHT OUTER JOIN (RIGHT JOIN) (Code Samples).html 1.7 KB
12. Joining Multiple Tables/8. Handling Ambiguous Column Names (Code Samples).sql 1.7 KB
12. Joining Multiple Tables/25. RIGHT OUTER JOIN (RIGHT JOIN) (Code Samples).sql 1.6 KB
16. Data Manipulation Language (DML) Statements/14. Pivoting Insert (Code Samples).html 1.6 KB
16. Data Manipulation Language (DML) Statements/3. INSERT Statement (Part 1) (Code Samples).html 1.6 KB
13. Using Subqueries/13. SCALAR Subqueries (Code Samples).html 1.6 KB
16. Data Manipulation Language (DML) Statements/30. FOR UPDATE Statement (Code Samples).html 1.6 KB
16. Data Manipulation Language (DML) Statements/14. Pivoting Insert (Code Samples).sql 1.6 KB
12. Joining Multiple Tables/18. NonEquiJoins - Source Code.sql 1.6 KB
16. Data Manipulation Language (DML) Statements/30. FOR UPDATE Statement (Code Samples).sql 1.6 KB
16. Data Manipulation Language (DML) Statements/5. INSERT Statement (Part 2) (Code Samples).html 1.5 KB
16. Data Manipulation Language (DML) Statements/8. Unconditional Insert Statements (INSERT ALL Statements) (Code Samples).html 1.5 KB
13. Using Subqueries/13. SCALAR Subqueries (Code Samples).sql 1.5 KB
16. Data Manipulation Language (DML) Statements/5. INSERT Statement (Part 2) (Code Samples).sql 1.5 KB
16. Data Manipulation Language (DML) Statements/8. Unconditional Insert Statements (INSERT ALL Statements) (Code Samples).sql 1.5 KB
24. Managing Oracle Privileges and Roles/19. Revoking Privileges and Roles (Code Samples).html 1.5 KB
21. Oracle Sequences/15. Oracle IDENTITY Column (Code Samples).html 1.5 KB
18. Oracle Constraints in SQL/7. PRIMARY KEY Constraint (Code Samples).html 1.5 KB
24. Managing Oracle Privileges and Roles/19. Revoking Privileges and Roles (Code Samples).sql 1.4 KB
18. Oracle Constraints in SQL/7. PRIMARY KEY Constraint (Code Samples).sql 1.4 KB
21. Oracle Sequences/15. Oracle IDENTITY Column (Code Samples).sql 1.4 KB
23. Working with Oracle Indexes in SQL/18. How to Modify (Alter) Indexes (Code Samples).html 1.4 KB
23. Working with Oracle Indexes in SQL/14. Multiple Indexes on the Same Columns & Invisible Indexes (Code Samples).html 1.4 KB
23. Working with Oracle Indexes in SQL/18. Altering Indexes (Code Samples).sql 1.4 KB
15. Data Definition Language (DDL) Statements/8. ALTER TABLE Statement (Code Samples).html 1.4 KB
16. Data Manipulation Language (DML) Statements/12. Conditional INSERT FIRST Statements (Code Samples).html 1.4 KB
12. Joining Multiple Tables/10. Inner Join & Join with the ON Clause (Code Samples).html 1.3 KB
23. Working with Oracle Indexes in SQL/14. Multiple Indexes on the Same Columns & Invisible Indexes (Code Samples).sql 1.3 KB
15. Data Definition Language (DDL) Statements/6. CREATE TABLE AS SELECT (CTAS) Statement in Oracle (Code Samples).html 1.3 KB
15. Data Definition Language (DDL) Statements/8. ALTER TABLE Statement (Code Samples).sql 1.3 KB
20. Data Dictionary Views/14. USER_CONS_COLUMNS Data Dictionary View (Code Samples).html 1.3 KB
16. Data Manipulation Language (DML) Statements/12. Conditional INSERT FIRST Statements (Code Samples).sql 1.3 KB
12. Joining Multiple Tables/10. Inner Join & Join with the ON Clause (Code Samples).sql 1.3 KB
15. Data Definition Language (DDL) Statements/6. CREATE TABLE AS SELECT (CTAS) Statement in Oracle.sql 1.3 KB
18. Oracle Constraints in SQL/28. Status of Constraints (Code Samples).html 1.3 KB
17. Using Oracle FLASHBACK Technologies/7. Tracking Changes In Data In a Particular Time (Code Samples).html 1.3 KB
02. Software Download & Installation/14. Installation Code.txt 1.3 KB
20. Data Dictionary Views/14. USER_CONS_COLUMNS Data Dictionary View (Code Samples).sql 1.3 KB
01. Database Concepts/6. Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html 1.3 KB
24. Managing Oracle Privileges and Roles/13. Granting Object Privileges (Code Samples).html 1.3 KB
17. Using Oracle FLASHBACK Technologies/3. FLASHBACK Operations (Part 2) (Code Samples).html 1.3 KB
17. Using Oracle FLASHBACK Technologies/7. Tracking Changes In Data In a Particular Time (Code Samples).sql 1.2 KB
26. Conclusion/3. SQL Certification Exam Samples.html 1.2 KB
05. Sorting Data/4. ASC and DESC Operators (Code Samples).html 1.2 KB
19. Database Views/4. Creating Simple Views (Code Samples).html 1.2 KB
11. Grouping Data/2. GROUP BY Clause (Part 1) (Code Samples).html 1.2 KB
18. Oracle Constraints in SQL/28. Status of Constraints (Code Samples).sql 1.2 KB
17. Using Oracle FLASHBACK Technologies/3. FLASHBACK Operations (Part 2) (Code Samples).sql 1.2 KB
18. Oracle Constraints in SQL/24. Disabling Constraints (Code Samples).html 1.2 KB
13. Using Subqueries/11. Using Subqueries as a Table (Code Samples).html 1.2 KB
18. Oracle Constraints in SQL/16. Adding Constraints via ALTER TABLE Statements (Code Samples).html 1.2 KB
24. Managing Oracle Privileges and Roles/13. Granting Object Privileges (Code Samples).sql 1.2 KB
02. Software Download & Installation/10. Important Note.html 1.2 KB
07. Single-Row Functions/20. Date Manipulation Functions in SQL (Code Samples).html 1.2 KB
11. Grouping Data/2. GROUP BY Clause (Part 1) (Code Samples).sql 1.2 KB
19. Database Views/4. Creating Simple Views (Code Samples).sql 1.2 KB
18. Oracle Constraints in SQL/24. Disabling Constraints (Code Samples).sql 1.2 KB
05. Sorting Data/4. ASC and DESC Operators(Code Samples).sql 1.2 KB
18. Oracle Constraints in SQL/20. Cascading Constraints in Oracle (Code Samples).html 1.2 KB
16. Data Manipulation Language (DML) Statements/3. INSERT Statement (Part 1) (Code Samples).sql 1.2 KB
13. Using Subqueries/11. Using Subqueries as a Table(Code Samples).sql 1.2 KB
24. Managing Oracle Privileges and Roles/10. Roles and PUBLIC (Code Samples).html 1.2 KB
02. Software Download & Installation/17. Option 3 Oracle Live SQL Limitations.html 1.1 KB
05. Sorting Data/11. Oracle FETCH Clause (Code Samples).html 1.1 KB
18. Oracle Constraints in SQL/16. Adding Constraints via ALTER TABLE Statements (Code Samples).sql 1.1 KB
11. Grouping Data/7. HAVING Clause (Code Samples).html 1.1 KB
07. Single-Row Functions/20. Date Manipulation Functions(Code Samples).sql 1.1 KB
08. Conversion Functions/6. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2) (Code Samples).html 1.1 KB
01. Database Concepts/5. The Working Document (Course Slide for Course Participants).html 1.1 KB
18. Oracle Constraints in SQL/20. Cascading Constraints in Oracle (Code Samples).sql 1.1 KB
07. Single-Row Functions/3. Case Conversion (LOWER, UPPER, INITCAP) Functions (Code Samples).html 1.1 KB
05. Sorting Data/11. Oracle FETCH Clause(Code Samples).sql 1.1 KB
14. Working with the Oracle SET Operators/2. RETIRED_EMPLOYEES Table Create Code.sql 1.1 KB
07. Single-Row Functions/11. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions) (Code Samples).html 1.1 KB
18. Oracle Constraints in SQL/14. CHECK Constraint (Code Samples).html 1.1 KB
12. Joining Multiple Tables/23. LEFT OUTER JOIN (LEFT JOIN) (Code Samples).html 1.1 KB
08. Conversion Functions/6. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2) (Code Samples).sql 1.1 KB
12. Joining Multiple Tables/15. Restricting Joins (Code Samples).html 1.1 KB
11. Grouping Data/7. HAVING Clause (Code Samples).sql 1.1 KB
23. Working with Oracle Indexes in SQL/12. Function-Based Indexes (Code Samples).html 1.1 KB
05. Sorting Data/2. ORDER BY Clause (Code Samples).html 1.1 KB
06. Using Substitution Variables/4. Double Ampersand (&&) and DEFINE & UNDEFINE Commands (Code Samples).html 1.1 KB
07. Single-Row Functions/3. Case Conversion (LOWER, UPPER, INITCAP) Functios(Code Samples).sql 1.1 KB
04. Restricting Data/20. Rules of Precedence (Code Samples).html 1.1 KB
18. Oracle Constraints in SQL/18. Dropping (Removing) Constraints (Code Samples).html 1.0 KB
07. Single-Row Functions/18. Date Functions & Arithmetic Operations on Dates (Code Samples).html 1.0 KB
07. Single-Row Functions/11. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)(Code Samples).sql 1.0 KB
11. Grouping Data/5. GROUP BY Clause (Part 2) (Code Samples).html 1.0 KB
18. Oracle Constraints in SQL/14. CHECK Constraint (Code Samples).sql 1.0 KB
12. Joining Multiple Tables/23. LEFT OUTER JOIN (LEFT JOIN) (Code Samples).sql 1.0 KB
12. Joining Multiple Tables/15. Restricting Joins (Code Samples).sql 1.0 KB
14. Working with the Oracle SET Operators/3. UNION and UNION ALL Operators (Code Samples).html 1.0 KB
15. Data Definition Language (DDL) Statements/4. CREATE TABLE Statement (Code Samples).html 1.0 KB
16. Data Manipulation Language (DML) Statements/28. SAVEPOINT Statement (Code Samples).html 1.0 KB
22. Oracle Synonyms/3. Creating, Using, and Dropping Synonyms (Code Samples).html 1.0 KB
23. Working with Oracle Indexes in SQL/12. Function-Based Indexes (Code Samples).sql 1.0 KB
05. Sorting Data/2. ORDER BY Clause(Code Samples).sql 1.0 KB
12. Joining Multiple Tables/17. Self Join (Code Samples).html 1.0 KB
18. Oracle Constraints in SQL/18. Dropping (Removing) Constraints (Code Samples).sql 1018 bytes
07. Single-Row Functions/18. Date Functions & Arithmetic Operations on Dates (Code Samples).sql 1011 bytes
09. Conditional Expressions/4. Oracle Conditional Expressions DECODE Function (Code Samples).html 1010 bytes
04. Restricting Data/20. Rules of Precedence(Code Samples).sql 1009 bytes
12. Joining Multiple Tables/19. Non-Equijoins (Joining Unequal Tables) (Code Samples).html 1008 bytes
16. Data Manipulation Language (DML) Statements/16. UPDATE Statement (Code Samples).html 1004 bytes
15. Data Definition Language (DDL) Statements/18. COMMENT Statement (Code Samples).html 1000 bytes
11. Grouping Data/5. GROUP BY Clause (Part 2) (Code Samples).sql 999 bytes
07. Single-Row Functions/7. Character Manipulation Functions Part 2 (INSTR Function) (Code Samples).html 996 bytes
26. Conclusion/2. SQL Cheatsheet.html 996 bytes
18. Oracle Constraints in SQL/31. Deferring Constraints (Code Samples).html 992 bytes
14. Working with the Oracle SET Operators/3. UNION and UNION ALL Operators (Code Samples).sql 986 bytes
15. Data Definition Language (DDL) Statements/4. CREATE TABLE Statement (Code Samples).sql 985 bytes
22. Oracle Synonyms/3. Creating, Using, and Dropping Synonyms (Code Samples).sql 982 bytes
16. Data Manipulation Language (DML) Statements/28. SAVEPOINT Statement (Code Samples).sql 981 bytes
06. Using Substitution Variables/4. Double Ampersand (&&) and DEFINE&UNDEFINE Commands(Code Samples).sql 976 bytes
14. Working with the Oracle SET Operators/7. MINUS Operator (Code Samples).html 974 bytes
12. Joining Multiple Tables/17. Self Join (Code Samples).sql 968 bytes
06. Using Substitution Variables/2. What is a Substitution Variable (Code Samples).html 961 bytes
09. Conditional Expressions/4. Oracle Conditional Expressions - DECODE Function (Code Samples).sql 956 bytes
08. Conversion Functions/8. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions (Code Samples).html 955 bytes
16. Data Manipulation Language (DML) Statements/16. UPDATE Statement (Code Samples).sql 955 bytes
12. Joining Multiple Tables/19. Non-Equijoins (Joining Unequal Tables) (Code Samples).sql 945 bytes
15. Data Definition Language (DDL) Statements/18. COMMENT Statement (Code Samples).sql 943 bytes
18. Oracle Constraints in SQL/31. Deferring Constraints (Code Samples).sql 932 bytes
07. Single-Row Functions/7. Character Manipulation Functions Part 2 (INSTR Function) (Code Samples).sql 929 bytes
13. Using Subqueries/17. EXISTS Operator & Semijoins (Code Samples).html 919 bytes
14. Working with the Oracle SET Operators/7. MINUS Operator (Code Samples).sql 915 bytes
08. Conversion Functions/8. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions (Code Samples).sql 896 bytes
07. Single-Row Functions/15. Nested Functions (Code Samples).html 895 bytes
17. Using Oracle FLASHBACK Technologies/5. PURGE Operations (Code Samples).html 888 bytes
03. Retrieving Data/26. Coding Exercise 2 Solution.html 884 bytes
06. Using Substitution Variables/2. What is a Substitution Variable(Code Samples).sql 875 bytes
05. Sorting Data/7. NULLS FIRST and NULLS LAST Operators (Code Samples).html 864 bytes
23. Working with Oracle Indexes in SQL/6. How to Create Indexes (Part 2) (Code Samples).html 864 bytes
03. Retrieving Data/21. Concatenation Operators (Code Samples).html 861 bytes
15. Data Definition Language (DDL) Statements/16. TRUNCATE TABLE Statement (Code Samples).html 858 bytes
05. Sorting Data/9. ROWNUM & ROWID in SQL (Code Samples).html 853 bytes
13. Using Subqueries/17. EXISTS Operator & Semijoins (Code Samples).sql 852 bytes
08. Conversion Functions/2. Conversion Functions (Code Samples).html 851 bytes
06. Using Substitution Variables/6. ACCEPT and PROMPT Commands (Code Samples).html 850 bytes
04. Restricting Data/12. LIKE Operator (Code Samples).html 842 bytes
17. Using Oracle FLASHBACK Technologies/5. PURGE Operations (Code Samples).sql 842 bytes
07. Single-Row Functions/15. Nested Functions(Code Samples).sql 840 bytes
03. Retrieving Data/23. Arithmetic Expressions and NULL Values (Code Samples).html 838 bytes
18. Oracle Constraints in SQL/3. NOT NULL Constraint (Code Samples).html 824 bytes
21. Oracle Sequences/8. Using Sequences (Code Samples).html 818 bytes
03. Retrieving Data/15. Quote (Q) Operator (Code Samples).html 814 bytes
03. Retrieving Data/17. DISTINCT and UNIQUE Operators (Code Samples).html 812 bytes
19. Database Views/14. Using the WITH READ ONLY Clause on Views (Code Samples).html 808 bytes
14. Working with the Oracle SET Operators/9. Matching Unmatched Queries in SET Operations (Code Samples).html 807 bytes
16. Data Manipulation Language (DML) Statements/24. COMMIT and ROLLBACK Statements (Code Samples).html 807 bytes
13. Using Subqueries/20. NOT EXISTS Operator (Sample Codes).html 806 bytes
23. Working with Oracle Indexes in SQL/6. How to Create Indexes (Part 2) (Code Samples).sql 804 bytes
16. Data Manipulation Language (DML) Statements/26. Row Lock in Oracle (Code Samples).html 800 bytes
15. Data Definition Language (DDL) Statements/16. TRUNCATE TABLE Statement (Code Samples).sql 799 bytes
03. Retrieving Data/21. Concatenation Operators(Code Samples).sql 795 bytes
05. Sorting Data/7. NULLS FIRST and NULLS LAST Operators(Code Samples).sql 795 bytes
04. Restricting Data/9. IN Operator (Code Samples).html 787 bytes
08. Conversion Functions/2. Conversion Functions(Code Samples).sql 785 bytes
05. Sorting Data/9. ROWNUM and ROWID in SQL(Code Samples).sql 782 bytes
06. Using Substitution Variables/6. ACCEPT and PROMPT Commands(Code Samples).sql 779 bytes
04. Restricting Data/12. LIKE Operator(Code Samples).sql 777 bytes
24. Managing Oracle Privileges and Roles/8. Granting System Privileges (Code Samples).html 774 bytes
03. Retrieving Data/23. Arithmetic Opertors and NULL values(Code Samples).sql 771 bytes
24. Managing Oracle Privileges and Roles/4. How to Create a User in Oracle Database (Code Samples).html 768 bytes
10. Group Functions/3. AVG Function (Code Samples).html 764 bytes
03. Retrieving Data/13. CODE Using Column Aliases.html 763 bytes
21. Oracle Sequences/8. Using Sequences (Code Samples).sql 761 bytes
18. Oracle Constraints in SQL/3. NOT NULL Constraint (Code Samples).sql 760 bytes
15. Data Definition Language (DDL) Statements/14. DROP TABLE Statement (Code Samples).html 758 bytes
03. Retrieving Data/17. DISTINCT and UNIQUE Operators(Code Samples).sql 747 bytes
16. Data Manipulation Language (DML) Statements/24. COMMIT and ROLLBACK Statements (Code Samples).sql 747 bytes
21. Oracle Sequences/10. Using Sequences as a Default Value (Code Samples).html 747 bytes
13. Using Subqueries/20. NOT EXISTS Operator(Code Samples).sql 746 bytes
16. Data Manipulation Language (DML) Statements/26. Row Lock in Oracle (Code Samples).sql 746 bytes
19. Database Views/14. Using the WITH READ ONLY Clause on Views (Code Samples).sql 746 bytes
14. Working with the Oracle SET Operators/9. Matching Unmatched Queries in SET Operations (Code Samples).sql 744 bytes
03. Retrieving Data/15. Quote (Q) Operator(Code Samples).sql 741 bytes
20. Data Dictionary Views/17. USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views (Code Samples).html 737 bytes
04. Restricting Data/9. IN Operator(Code Samples).sql 723 bytes
24. Managing Oracle Privileges and Roles/8. Granting System Privileges (Code Samples).sql 714 bytes
07. Single-Row Functions/13. Numeric Functions (Code Samples).html 708 bytes
19. Database Views/8. Modifying Views (Code Samples).html 708 bytes
24. Managing Oracle Privileges and Roles/4. How to Create a User in Oracle Database (Code Samples).sql 707 bytes
15. Data Definition Language (DDL) Statements/14. DROP TABLE Statement(Code Samples).sql 704 bytes
21. Oracle Sequences/5. Modifying Sequences (Code Samples).html 704 bytes
16. Data Manipulation Language (DML) Statements/18. DELETE Statement (Code Samples).html 702 bytes
10. Group Functions/3. AVG Function (Code Samples).sql 701 bytes
03. Retrieving Data/13. Using Column Aliases(Code Samples).sql 695 bytes
23. Working with Oracle Indexes in SQL/16. Analyzing the USER_INDEXES and USER_IND_COLUMNS Views (Code Samples).html 693 bytes
04. Restricting Data/5. Comparison Operators (Code Samples).html 691 bytes
24. Managing Oracle Privileges and Roles/20. Searching Privileges Using Data Dictionary Views.html 690 bytes
21. Oracle Sequences/10. Using Sequences as a Default Value (Code Samples).sql 682 bytes
20. Data Dictionary Views/17. USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views (Code Samples).sql 672 bytes
15. Data Definition Language (DDL) Statements/20. RENAME Statement (Code Samples).html 670 bytes
15. Data Definition Language (DDL) Statements/10. Marking Columns Unused (Using The SET UNUSED Clause) (Code Samples).html 667 bytes
03. Retrieving Data/19. Coding Exercise 1 Solution.html 661 bytes
12. Joining Multiple Tables/21. OUTER JOINS (Code Samples).html 660 bytes
15. Data Definition Language (DDL) Statements/12. READ-ONLY Tables in SQL (Code Samples).html 656 bytes
21. Oracle Sequences/5. Modifying Sequences (Code Samples).sql 655 bytes
10. Group Functions/16. Overview Of Group Functions (Code Samples).html 651 bytes
04. Restricting Data/17. Logical Operators (Code Samples).html 647 bytes
07. Single-Row Functions/13. Numeric Functions(Code Samples).sql 646 bytes
13. Using Subqueries/2. Using Subqueries (Code Samples).html 644 bytes
19. Database Views/8. Modifying Views (Code Samples).sql 643 bytes
16. Data Manipulation Language (DML) Statements/18. DELETE Statement (Code Samples).sql 641 bytes
18. Oracle Constraints in SQL/26. Enabling Constraints (Code Samples).html 639 bytes
06. Using Substitution Variables/8. SET VERIFY ON-OFF Commands(Code Samples).html 638 bytes
12. Joining Multiple Tables/4. Natural Join (Code Samples).html 638 bytes
24. Managing Oracle Privileges and Roles/22. Good News!.html 633 bytes
19. Database Views/6. Creating Complex Views (Code Samples).html 630 bytes
23. Working with Oracle Indexes in SQL/16. Analyzing USER_INDEXES and USER_IND_COLUMNS Views (Code Samples).sql 630 bytes
12. Joining Multiple Tables/27. FULL OUTER JOIN (FULL JOIN) (Code Samples).html 628 bytes
04. Restricting Data/7. BETWEEN...AND Operator (Code Samples).html 621 bytes
04. Restricting Data/5. Comparison Operators(Code Samples).sql 616 bytes
03. Retrieving Data/5. INFORMATION Command (Code Samples).html 609 bytes
15. Data Definition Language (DDL) Statements/20. RENAME Statement (Code Samples).sql 606 bytes
15. Data Definition Language (DDL) Statements/10. Marking Columns Unused (Using The SET UNUSED Clause) (Code Samples).sql 604 bytes
12. Joining Multiple Tables/21. OUTER JOINS (Code Samples).sql 599 bytes
11. Grouping Data/10. Nested Group Functions (Code Samples).html 598 bytes
15. Data Definition Language (DDL) Statements/12. READ-ONLY Tables in SQL (Code Samples).sql 598 bytes
23. Working with Oracle Indexes in SQL/4. How to Create Indexes (Part 1) (Code Samples).html 597 bytes
10. Group Functions/16. Overview of Group Functions (Code Samples).sql 595 bytes
02. Software Download & Installation/19. Don't Forget to Leave a Rating!.html 583 bytes
03. Retrieving Data/11. Using SELECT Statements (Code Samples).html 581 bytes
13. Using Subqueries/2. Using Subqueries (Code Samples).sql 573 bytes
18. Oracle Constraints in SQL/26. Enabling Constraints (Code Samples).sql 573 bytes
21. Oracle Sequences/3. Creating Sequences (Code Samples).html 573 bytes
12. Joining Multiple Tables/4. Natural Join (Code Samples).sql 572 bytes
04. Restricting Data/15. IS NULL Operator (Code Samples).html 571 bytes
04. Restricting Data/17. Logical Operators(Code Samples).sql 571 bytes
19. Database Views/16. Dropping Views (Code Samples).html 571 bytes
20. Data Dictionary Views/10. USER_TAB_COLUMNS Data Dictionary View (Code Samples).html 569 bytes
06. Using Substitution Variables/8. SET VERIFY ON-OFF Commands(Code Samples).sql 567 bytes
14. Working with the Oracle SET Operators/5. INTERSECT Operator (Code Samples).html 566 bytes
12. Joining Multiple Tables/6. Join with the USING Clause (Code Samples).html 565 bytes
19. Database Views/6. Creating Complex Views (Code Samples).sql 562 bytes
12. Joining Multiple Tables/27. FULL OUTER JOIN (Code Samples).sql 561 bytes
20. Data Dictionary Views/3. The Dictionary View (Code Samples).html 559 bytes
04. Restricting Data/7. BETWEEN...AND Operator(Code Samples).sql 556 bytes
20. Data Dictionary Views/6. USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views (Code Samples).html 538 bytes
23. Working with Oracle Indexes in SQL/4. How to Create Indexes (Part 1) (Code Samples).sql 533 bytes
11. Grouping Data/10. Nested Group Functions (Code Samples).sql 532 bytes
10. Group Functions/12. SUM Function (Code Samples).html 531 bytes
04. Restricting Data/2. Using WHERE Clause (Code Samples).html 530 bytes
22. Oracle Synonyms/5. Analyzing The USER_SYNONYMS View (Code Samples).html 529 bytes
03. Retrieving Data/9. Oracle Error Messages (Code Samples).html 528 bytes
18. Oracle Constraints in SQL/22. Renaming Constraints (Code Samples).html 517 bytes
10. Group Functions/10. MIN Function (Code Samples).html 515 bytes
10. Group Functions/5. COUNT Function (Code Samples).html 514 bytes
03. Retrieving Data/11. Using SELECT Statements(Code Samples).sql 512 bytes
21. Oracle Sequences/3. Creating Sequences (Code Samples).sql 512 bytes
19. Database Views/16. Dropping Views (Code Samples).sql 510 bytes
20. Data Dictionary Views/8. USER_TABLES Data Dictionary View (Code Samples).html 507 bytes
04. Restricting Data/15. IS NULL Operator(Code Samples).sql 501 bytes
20. Data Dictionary Views/12. USER_CONSTRAINTS Data Dictionary View (Code Samples).html 501 bytes
20. Data Dictionary Views/10. USER_TAB_COLUMNS Data Dictionary View (Code Samples).sql 500 bytes
12. Joining Multiple Tables/6. Join with the USING Clause (Code Samples).sql 498 bytes
14. Working with the Oracle SET Operators/5. INTERSECT Operator (Code Samples).sql 495 bytes
20. Data Dictionary Views/3. The Dictionary View (Code Samples).sql 492 bytes
16. Data Manipulation Language (DML) Statements/22. (TCL) Transaction Control Language & TCL Commands (Code Samples).html 487 bytes
10. Group Functions/8. MAX Function (Code Samples).html 480 bytes
20. Data Dictionary Views/6. USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views (Code Samples).sql 475 bytes
22. Oracle Synonyms/5. Analyzing The USER_SYNONYMS View (Code Samples).sql 464 bytes
10. Group Functions/12. SUM Function (Code Samples).sql 461 bytes
03. Retrieving Data/9. Oracle Error Messages(Code Samples).sql 458 bytes
03. Retrieving Data/7. SQL Statement Basics (Code Samples).html 457 bytes
04. Restricting Data/2. Using WHERE Clause(Code Samples).sql 457 bytes
03. Retrieving Data/5. INFORMATION Command(Code Samples).sql 450 bytes
10. Group Functions/10. MIN Function (Code Samples).sql 446 bytes
18. Oracle Constraints in SQL/22. Renaming Constraints (Code Samples).sql 446 bytes
10. Group Functions/5. COUNT Function (Code Samples).sql 445 bytes
20. Data Dictionary Views/8. USER_TABLES Data Dictionary View (Code Samples).sql 444 bytes
24. Managing Oracle Privileges and Roles/6. Changing Users' Passwords in Oracle Database (Code Samples).html 443 bytes
20. Data Dictionary Views/12. USER_CONSTRAINTS Data Dictionary View (Code Samples).sql 432 bytes
23. Working with Oracle Indexes in SQL/10. How to Remove (Drop) Indexes (Code Samples).html 413 bytes
16. Data Manipulation Language (DML) Statements/22. (TCL) Transaction Control Language & TCL Commands (Code Samples).sql 412 bytes
10. Group Functions/8. MAX Function (Code Samples).sql 410 bytes
03. Retrieving Data/7. SQL Statement Basics(Code Samples).sql 385 bytes
24. Managing Oracle Privileges and Roles/6. Changing Users' Passwords in Oracle Database (Code Samples).sql 372 bytes
23. Working with Oracle Indexes in SQL/10. How to Remove (Drop) Indexes (Code Samples).sql 340 bytes
07. Single-Row Functions/12. Oracle-Numeric-Functions.txt 86 bytes
02. Software Download & Installation/3. Download-VMware-Workstation-Player.txt 85 bytes
02. Software Download & Installation/11. Oracles-Official-Website.txt 84 bytes
02. Software Download & Installation/6. Download-Virtual-Machine-Image-19c-.txt 84 bytes
01. Database Concepts/5. Download-the-Working-Document.txt 82 bytes
02. Software Download & Installation/3. Download-Oracle-Virtualbox.txt 41 bytes
25. Appendix/1. Oracles-Official-Website.txt 23 bytes

Udemy - The Complete Oracle SQL Bootcamp (2025) (8.2025)

File List

Download Torrent

Related Resources

Copyright Infringement