| .pad | |||
| 0 | 10 B | ||
| 1 | 9 B | ||
| 2 | 2 B | ||
| 3 | 7 B | ||
| 4 | 273.65 KB | ||
| 5 | 1012.5 KB | ||
| 6 | 1.26 MB | ||
| 7 | 649.93 KB | ||
| 8 | 715.11 KB | ||
| 9 | 1.58 MB | ||
| 10 | 1.74 MB | ||
| 11 | 1.95 MB | ||
| 12 | 129.45 KB | ||
| 13 | 712.88 KB | ||
| 14 | 1.08 MB | ||
| 15 | 931.8 KB | ||
| 16 | 1.71 MB | ||
| 17 | 1.77 MB | ||
| 18 | 1.98 MB | ||
| 19 | 1.03 MB | ||
| 20 | 562.13 KB | ||
| 21 | 1.13 MB | ||
| 22 | 277.74 KB | ||
| 23 | 34.18 KB | ||
| 24 | 126.93 KB | ||
| 25 | 646.59 KB | ||
| 26 | 1.63 MB | ||
| 27 | 101.29 KB | ||
| 28 | 1.05 MB | ||
| 29 | 1.26 MB | ||
| 30 | 483.35 KB | ||
| 31 | 903.67 KB | ||
| 32 | 1.25 MB | ||
| 33 | 425.11 KB | ||
| 34 | 15.29 KB | ||
| 35 | 1.06 MB | ||
| 36 | 1.38 MB | ||
| 37 | 1.94 MB | ||
| 38 | 303.06 KB | ||
| 39 | 699.49 KB | ||
| 40 | 1.37 MB | ||
| 41 | 1.77 MB | ||
| 42 | 632.34 KB | ||
| 43 | 636.3 KB | ||
| 44 | 283.31 KB | ||
| 45 | 331.25 KB | ||
| 46 | 5.67 KB | ||
| 47 | 1002.29 KB | ||
| 48 | 1.94 MB | ||
| 49 | 422.33 KB | ||
| 50 | 789.34 KB | ||
| 51 | 1.79 MB | ||
| 52 | 1.53 MB | ||
| 53 | 1.53 MB | ||
| 54 | 1.54 MB | ||
| 55 | 1.18 MB | ||
| 56 | 1.24 MB | ||
| 57 | 901.88 KB | ||
| 58 | 1.96 MB | ||
| 59 | 270.89 KB | ||
| 60 | 1.92 MB | ||
| 61 | 317.85 KB | ||
| 62 | 585.12 KB | ||
| 63 | 1.29 MB | ||
| 64 | 1.3 MB | ||
| 65 | 15.63 KB | ||
| 66 | 491.11 KB | ||
| 67 | 1.59 MB | ||
| 68 | 363.74 KB | ||
| 69 | 375.26 KB | ||
| 70 | 538.48 KB | ||
| 71 | 810.94 KB | ||
| 72 | 815.2 KB | ||
| 73 | 956.92 KB | ||
| 74 | 1.14 MB | ||
| 75 | 88.65 KB | ||
| 76 | 117.24 KB | ||
| 77 | 254.22 KB | ||
| 78 | 742.92 KB | ||
| 79 | 1.06 MB | ||
| 80 | 359.16 KB | ||
| 81 | 1023.1 KB | ||
| 82 | 1.8 MB | ||
| 83 | 162.4 KB | ||
| 84 | 334.8 KB | ||
| 85 | 1.67 MB | ||
| 86 | 595.91 KB | ||
| 87 | 1.37 MB | ||
| 88 | 1.74 MB | ||
| 89 | 1.22 MB | ||
| 90 | 1.68 MB | ||
| 91 | 111.27 KB | ||
| 92 | 1.38 MB | ||
| 93 | 1.63 MB | ||
| 94 | 1.64 MB | ||
| 95 | 1.86 MB | ||
| 96 | 779.94 KB | ||
| 97 | 920.31 KB | ||
| 98 | 983.56 KB | ||
| 99 | 1.3 MB | ||
| 100 | 1.06 MB | ||
| 101 | 694.63 KB | ||
| 102 | 754.45 KB | ||
| 103 | 1.11 MB | ||
| 104 | 109.39 KB | ||
| 105 | 752.86 KB | ||
| 106 | 1.2 MB | ||
| 107 | 731.89 KB | ||
| 108 | 1.93 MB | ||
| 109 | 1.71 MB | ||
| 110 | 1.74 MB | ||
| 111 | 1.76 MB | ||
| 112 | 217.88 KB | ||
| 113 | 421.83 KB | ||
| 114 | 936.7 KB | ||
| 115 | 1.59 MB | ||
| 116 | 1.79 MB | ||
| 117 | 203.74 KB | ||
| 118 | 1.85 MB | ||
| 119 | 694.14 KB | ||
| 120 | 1.79 MB | ||
| 121 | 1.81 MB | ||
| 122 | 1.89 MB | ||
| 123 | 70.2 KB | ||
| 124 | 167.39 KB | ||
| 125 | 735.51 KB | ||
| 126 | 1.03 MB | ||
| 127 | 1.6 MB | ||
| 128 | 1.08 MB | ||
| 129 | 1.57 MB | ||
| 130 | 525.57 KB | ||
| 131 | 662.34 KB | ||
| 132 | 910.51 KB | ||
| 133 | 1.68 MB | ||
| 134 | 1.01 MB | ||
| 135 | 984.23 KB | ||
| 136 | 652.21 KB | ||
| 137 | 1.15 MB | ||
| 138 | 1.04 MB | ||
| 139 | 434.52 KB | ||
| 140 | 444.52 KB | ||
| 141 | 1.24 MB | ||
| TutsNode.com.txt | 63 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 585 B | ||
| [TutsNode.com] - The Complete Oracle SQL Bootcamp (2021) | |||
| 1. Database Concepts | |||
| 1. What is a Database.mp4 | 68.7 MB | ||
| 1. What is a Database.srt | 9.69 KB | ||
| 10. The Sample (HR) Schema Used in This Course.mp4 | 76.08 MB | ||
| 10. The Sample (HR) Schema Used in This Course.srt | 8.98 KB | ||
| 10.1 HR-Schema-Relationship.png | 233.1 KB | ||
| 11. What is SQL.mp4 | 45.32 MB | ||
| 11. What is SQL.srt | 6.17 KB | ||
| 12. Section 1 Quiz.html | 162 B | ||
| 2. Why Oracle Database.mp4 | 61.75 MB | ||
| 2. Why Oracle Database.srt | 9.27 KB | ||
| 3. What is a Table.mp4 | 38.29 MB | ||
| 3. What is a Table.srt | 4.18 KB | ||
| 4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4 | 50.62 MB | ||
| 4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).srt | 6.12 KB | ||
| 5. Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html | 1.29 KB | ||
| 5.1 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam [04.03.2017].pdf | 1.58 MB | ||
| 5.2 Oracle-Database-12c-Database-SQL-1Z0-071-Exam [2018-06-30].pdf | 2.08 MB | ||
| 5.3 Oracle-Database-12c-Database-SQL-1Z0-071-Exam [2016-07-12].pdf | 574.39 KB | ||
| 5.4 SQL Cheatsheet (Oracle Master).pdf | 3.57 MB | ||
| 6. What is a Relational Database (RDBMS).mp4 | 89.59 MB | ||
| 6. What is a Relational Database (RDBMS).srt | 9.28 KB | ||
| 7. Entity Relationship Logic in Databases.mp4 | 37.09 MB | ||
| 7. Entity Relationship Logic in Databases.srt | 4.6 KB | ||
| 8. What is Pluggable Database.mp4 | 25.11 MB | ||
| 8. What is Pluggable Database.srt | 3.88 KB | ||
| 9. Introduction to Database Objects.mp4 | 126.97 MB | ||
| 9. Introduction to Database Objects.srt | 15.59 KB | ||
| 10. Group Functions | |||
| 1. Group Functions.mp4 | 56.33 MB | ||
| 1. Group Functions.srt | 10.42 KB | ||
| 2. AVG Function.mp4 | 59 MB | ||
| 3. COUNT Function.mp4 | 36.41 MB | ||
| 3. COUNT Function.srt | 8.28 KB | ||
| 4. MAX Function.mp4 | 33.32 MB | ||
| 4. MAX Function.srt | 5.73 KB | ||
| 5. MIN Function.mp4 | 28.4 MB | ||
| 5. MIN Function.srt | 5.79 KB | ||
| 6. SUM Function.mp4 | 24.32 MB | ||
| 6. SUM Function.srt | 4.87 KB | ||
| 7. LISTAGG Function.mp4 | 65.64 MB | ||
| 7. LISTAGG Function.srt | 12.66 KB | ||
| 8. Overview Of Group Functions.mp4 | 25.49 MB | ||
| 8. Overview Of Group Functions.srt | 5.21 KB | ||
| 9. Section 8 Quiz.html | 162 B | ||
| 11. Grouping Data | |||
| 1. GROUP BY Clause (Part 1).mp4 | 102.23 MB | ||
| 1. GROUP BY Clause (Part 1).srt | 18.95 KB | ||
| 2. GROUP BY Clause (Part 2).mp4 | 95.68 MB | ||
| 2. GROUP BY Clause (Part 2).srt | 14.83 KB | ||
| 3. HAVING Clause.mp4 | 61.89 MB | ||
| 3. HAVING Clause.srt | 10.77 KB | ||
| 4. Nested Group Functions.mp4 | 30.21 MB | ||
| 4. Nested Group Functions.srt | 5.69 KB | ||
| 5. Section 9 Quiz.html | 162 B | ||
| 12. Joining Multiple Tables | |||
| 1. What is a Join & Oracle SQL Join Types.mp4 | 63.07 MB | ||
| 1. What is a Join & Oracle SQL Join Types.srt | 9.23 KB | ||
| 10. Non-Equijoins (Joining Unequal Tables).mp4 | 115.53 MB | ||
| 10. Non-Equijoins (Joining Unequal Tables).srt | 15.83 KB | ||
| 10.1 NonEquiJoins - Source Code.sql | 1.56 KB | ||
| 11. OUTER JOINS.mp4 | 67.52 MB | ||
| 11. OUTER JOINS.srt | 10.05 KB | ||
| 12. LEFT OUTER JOIN (LEFT JOIN).mp4 | 113.58 MB | ||
| 12. LEFT OUTER JOIN (LEFT JOIN).srt | 15.53 KB | ||
| 13. RIGHT OUTER JOIN (RIGHT JOIN).mp4 | 91.02 MB | ||
| 13. RIGHT OUTER JOIN (RIGHT JOIN).srt | 10.29 KB | ||
| 14. FULL OUTER JOIN (FULL JOIN).mp4 | 35.8 MB | ||
| 14. FULL OUTER JOIN (FULL JOIN).srt | 4.95 KB | ||
| 15. Cross Join (Cartesian Product Cross Product).mp4 | 157.37 MB | ||
| 15. Cross Join (Cartesian Product Cross Product).srt | 22.04 KB | ||
| 16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4 | 121.37 MB | ||
| 16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).srt | 17.16 KB | ||
| 17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4 | 161.01 MB | ||
| 17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).srt | 19.99 KB | ||
| 18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4 | 86.47 MB | ||
| 18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).srt | 13.14 KB | ||
| 19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4 | 135.87 MB | ||
| 19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.srt | 18.01 KB | ||
| 2. Creating a Join.mp4 | 29.84 MB | ||
| 2. Creating a Join.srt | 3.77 KB | ||
| 20. Which Join Type Should You Use.mp4 | 26.43 MB | ||
| 20. Which Join Type Should You Use.srt | 4.9 KB | ||
| 21. Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4 | 133.09 MB | ||
| 21. Entity-Relationship Models in DBMS - How to Use Them with Joins.srt | 21.89 KB | ||
| 22. Section 10 Quiz.html | 162 B | ||
| 3. Natural Join.mp4 | 91.99 MB | ||
| 3. Natural Join.srt | 12.36 KB | ||
| 4. Join with the USING Clause.mp4 | 49.1 MB | ||
| 4. Join with the USING Clause.srt | 7.04 KB | ||
| 5. Handling Ambiguous Column Names.mp4 | 81.12 MB | ||
| 5. Handling Ambiguous Column Names.srt | 13.27 KB | ||
| 6. Inner Join & Join with the ON Clause.mp4 | 54.26 MB | ||
| 6. Inner Join & Join with the ON Clause.srt | 8.33 KB | ||
| 7. Multiple Join Operations.mp4 | 116.95 MB | ||
| 7. Multiple Join Operations.srt | 14.53 KB | ||
| 8. Restricting Joins.mp4 | 28.97 MB | ||
| 8. Restricting Joins.srt | 4.05 KB | ||
| 9. Self Join.mp4 | 61.91 MB | ||
| 9. Self Join.srt | 7.32 KB | ||
| 13. Using Subqueries | |||
| 1. Using Subqueries.mp4 | 55.42 MB | ||
| 1. Using Subqueries.srt | 9.64 KB | ||
| 10. Section 11 Quiz.html | 162 B | ||
| 2. Single Row Subqueries.mp4 | 132.23 MB | ||
| 2. Single Row Subqueries.srt | 17.26 KB | ||
| 3. Multiple Row Subqueries.mp4 | 121.97 MB | ||
| 3. Multiple Row Subqueries.srt | 22.13 KB | ||
| 4. Multiple Column Subqueries.mp4 | 128.02 MB | ||
| 4. Multiple Column Subqueries.srt | 21.2 KB | ||
| 5. Using Subqueries as a Table.mp4 | 63.63 MB | ||
| 5. Using Subqueries as a Table.srt | 10.26 KB | ||
| 6. SCALAR Subqueries.mp4 | 114.75 MB | ||
| 6. SCALAR Subqueries.srt | 18.73 KB | ||
| 7. Correlated Subqueries.mp4 | 134.92 MB | ||
| 7. Correlated Subqueries.srt | 18.83 KB | ||
| 8. EXISTS Operator & Semijoins.mp4 | 88.21 MB | ||
| 8. EXISTS Operator & Semijoins.srt | 14.67 KB | ||
| 9. NOT EXISTS Operator.mp4 | 49.24 MB | ||
| 9. NOT EXISTS Operator.srt | 7.61 KB | ||
| 14. Working with the Oracle SET Operators | |||
| 1. GOOD NEWS FOR YOU!.html | 815 B | ||
| 2. Introduction to SET Operators in Oracle SQL.mp4 | 121.88 MB | ||
| 2. Introduction to SET Operators in Oracle SQL.srt | 50 B | ||
| 2.1 Retired Employees Tables Creation Codes.pdf | 255.73 KB | ||
| 3. UNION and UNION ALL Operators.mp4 | 123.73 MB | ||
| 3. UNION and UNION ALL Operators.srt | 50 B | ||
| 4. INTERSECT Operator.mp4 | 19.36 MB | ||
| 4. INTERSECT Operator.srt | 3.8 KB | ||
| 5. MINUS Operator.mp4 | 30.11 MB | ||
| 5. MINUS Operator.srt | 4.73 KB | ||
| 6. Matching Unmatched Queries in SET Operations.mp4 | 29.93 MB | ||
| 6. Matching Unmatched Queries in SET Operations.srt | 50 B | ||
| 7. Using the ORDER BY Clause with SET Operators.mp4 | 61.27 MB | ||
| 7. Using the ORDER BY Clause with SET Operators.srt | 50 B | ||
| 8. Section 12 Quiz.html | 162 B | ||
| 15. Data Manipulation Language (DML) Statements | |||
| 1. Data Manipulation Language (DML).mp4 | 25.35 MB | ||
| 1. Data Manipulation Language (DML).srt | 50 B | ||
| 10. Section 13 Quiz.html | 162 B | ||
| 2. INSERT Statement (Part 1).mp4 | 38.24 MB | ||
| 2. INSERT Statement (Part 1).srt | 50 B | ||
| 3. INSERT Statement (Part 2).mp4 | 124.87 MB | ||
| 3. INSERT Statement (Part 2).srt | 50 B | ||
| 4. UPDATE Statement.mp4 | 110.06 MB | ||
| 4. UPDATE Statement.srt | 50 B | ||
| 5. DELETE Statement.mp4 | 66.41 MB | ||
| 5. DELETE Statement.srt | 50 B | ||
| 6. Transaction Control Statements.mp4 | 45.26 MB | ||
| 6. Transaction Control Statements.srt | 50 B | ||
| 7. COMMIT and ROLLBACK Statements.mp4 | 89.23 MB | ||
| 7. COMMIT and ROLLBACK Statements.srt | 50 B | ||
| 8. SAVEPOINT Statement.mp4 | 30.19 MB | ||
| 8. SAVEPOINT Statement.srt | 50 B | ||
| 9. FOR UPDATE Statement.mp4 | 84.82 MB | ||
| 9. FOR UPDATE Statement.srt | 50 B | ||
| 16. Data Definition Language (DDL) Statements | |||
| 1. Data Definition Language (DDL).mp4 | 21.04 MB | ||
| 1. Data Definition Language (DDL).srt | 50 B | ||
| 2. Naming Rules.mp4 | 22.99 MB | ||
| 2. Naming Rules.srt | 50 B | ||
| 3. CREATE TABLE Statement.mp4 | 160.74 MB | ||
| 3. CREATE TABLE Statement.srt | 50 B | ||
| 4. ALTER TABLE Statement.mp4 | 192.79 MB | ||
| 4. ALTER TABLE Statement.srt | 50 B | ||
| 5. DROP TABLE Statement.mp4 | 36.21 MB | ||
| 5. DROP TABLE Statement.srt | 50 B | ||
| 6. TRUNCATE TABLE Statement.mp4 | 44.89 MB | ||
| 6. TRUNCATE TABLE Statement.srt | 50 B | ||
| 7. COMMENT Statement.mp4 | 67.98 MB | ||
| 7. COMMENT Statement.srt | 50 B | ||
| 8. RENAME Statement.mp4 | 52.32 MB | ||
| 8. RENAME Statement.srt | 50 B | ||
| 9. Section 14 Quiz.html | 162 B | ||
| 17. Creating Constraints | |||
| 1. Creating Constraints.mp4 | 41.29 MB | ||
| 1. Creating Constraints.srt | 50 B | ||
| 2. NOT NULL Constraint.mp4 | 54.63 MB | ||
| 2. NOT NULL Constraint.srt | 50 B | ||
| 3. UNIQUE Constraint.mp4 | 104.63 MB | ||
| 3. UNIQUE Constraint.srt | 50 B | ||
| 4. PRIMARY KEY Constraint.mp4 | 63.47 MB | ||
| 4. PRIMARY KEY Constraint.srt | 50 B | ||
| 5. FOREIGN KEY Constraint.mp4 | 174.05 MB | ||
| 5. FOREIGN KEY Constraint.srt | 50 B | ||
| 6. CHECK Constraint.mp4 | 37.79 MB | ||
| 6. CHECK Constraint.srt | 50 B | ||
| 7. Section 15 Quiz.html | 162 B | ||
| 18. Conclusion + Bonus | |||
| 1. Conclusion.mp4 | 4.96 MB | ||
| 1. Conclusion.srt | 50 B | ||
| 2. Where to next.html | 2.6 KB | ||
| 2.1 Special Discounts For Our Students.xlsx | 35.27 KB | ||
| 3. Bonus Code Samples.pdf | 84.14 KB | ||
| 4. Course Bonuses (SQL Cheatsheet & SQL Certification Exam Samples).html | 1.17 KB | ||
| 4.1 SQL Cheatsheet (Oracle Master).pdf | 3.58 MB | ||
| 4.2 Oracle Database 12c SQL Fundamentals 1Z0-061 Exam (23.01.2017).pdf | 2.76 MB | ||
| 4.3 Oracle Database 12c SQL Fundamentals 1Z0-061 Exam (04.03.2017).pdf | 1.58 MB | ||
| 19. Appendix | |||
| 1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp4 | 18.85 MB | ||
| 1. Appendix 1 Oracle Database 12c Installation into Your Computer.srt | 17.22 KB | ||
| 1.1 Oracle's Official Website.html | 84 B | ||
| 2. Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c.html | 3.09 KB | ||
| 3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4 | 26.92 MB | ||
| 3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.srt | 19.87 KB | ||
| 2. Software Download & Installation | |||
| 1. About the Database Installation.mp4 | 50.14 MB | ||
| 1. About the Database Installation.srt | 5.15 KB | ||
| 10. SQL Statements Used in This Course.mp4 | 43.26 MB | ||
| 10. SQL Statements Used in This Course.srt | 5.99 KB | ||
| 11. The Working Document.html | 758 B | ||
| 11.1 Working Document Link.html | 122 B | ||
| 12. Don't Forget to Leave a Rating!.html | 654 B | ||
| 2. Which Option to Choose to Have a Database.mp4 | 86.46 MB | ||
| 2. Which Option to Choose to Have a Database.srt | 86.47 MB | ||
| 3. Option 1 Having the Database with the Oracle Virtual Box.mp4 | 57.84 MB | ||
| 3. Option 1 Having the Database with the Oracle Virtual Box.srt | 13.71 KB | ||
| 3.1 Step 1 Download Oracle Virtual Box.html | 136 B | ||
| 3.2 Linux Username and Password.txt | 185 B | ||
| 3.3 Oracle Master - Changing Virtual Machine Keyboard Input Settings.pdf | 823.08 KB | ||
| 3.4 (Optional) Download Oracle's Virtual Machine (12c Release 2).html | 141 B | ||
| 3.5 Step 2 Download Virtual Machine Image Link.html | 141 B | ||
| 4. Option 1 How to Install the Virtual Box on Mac OS X.html | 4.18 KB | ||
| 5. Option 2 Downloading And Installing Oracle Database.mp4 | 191.61 MB | ||
| 5. Option 2 Downloading And Installing Oracle Database.srt | 21.83 KB | ||
| 5.1 Oracle's Official Website.html | 145 B | ||
| 6. Option 2 Unlocking the HR Schema.mp4 | 38.26 MB | ||
| 6. Option 2 Unlocking the HR Schema.srt | 9.53 KB | ||
| 6.1 (Oracle Master Training) - Scripts to Unlock the HR Schema.pdf | 230.84 KB | ||
| 7. Option 2 Configuring and Using the SQL Developer.mp4 | 144.42 MB | ||
| 7. Option 2 Configuring and Using the SQL Developer.srt | 25.86 KB | ||
| 8. Option 3 Using Oracle Live SQL.mp4 | 42.8 MB | ||
| 8. Option 3 Using Oracle Live SQL.srt | 8.62 KB | ||
| 9. Option 3 Warning About Oracle Live SQL Limitations.html | 1020 B | ||
| 3. Retrieving Data | |||
| 1. Oracle Data Types.mp4 | 60.94 MB | ||
| 1. Oracle Data Types.srt | 8.38 KB | ||
| 10. CODE Using Column Aliases.html | 397 B | ||
| 11. Quote (Q) Operator.mp4 | 49.04 MB | ||
| 11. Quote (Q) Operator.srt | 10.14 KB | ||
| 12. DISTINCT and UNIQUE Operator.mp4 | 52.78 MB | ||
| 12. DISTINCT and UNIQUE Operator.srt | 8.63 KB | ||
| 13. Concatenation Operators.mp4 | 63.21 MB | ||
| 13. Concatenation Operators.srt | 8.42 KB | ||
| 14. Arithmetic Expressions and NULL Values.mp4 | 77.74 MB | ||
| 14. Arithmetic Expressions and NULL Values.srt | 11.43 KB | ||
| 15. Section 2 Quiz.html | 162 B | ||
| 2. What is a NULL Value.mp4 | 59.65 MB | ||
| 2. What is a NULL Value.srt | 6.21 KB | ||
| 3. DESCRIBE Command.mp4 | 29.28 MB | ||
| 3. DESCRIBE Command.srt | 5.12 KB | ||
| 4. INFORMATION Command.mp4 | 48.7 MB | ||
| 4. INFORMATION Command.srt | 10.08 KB | ||
| 5. SQL Statement Basics.mp4 | 101.38 MB | ||
| 5. SQL Statement Basics.srt | 15.36 KB | ||
| 6. Oracle Error Messages.mp4 | 40.07 MB | ||
| 6. Oracle Error Messages.srt | 7.58 KB | ||
| 7. Using SELECT Statements.mp4 | 43.89 MB | ||
| 7. Using SELECT Statements.srt | 7.15 KB | ||
| 8. CODE Using SELECT Statements.html | 215 B | ||
| 9. Using Column Aliases.mp4 | 50.37 MB | ||
| 9. Using Column Aliases.srt | 8.27 KB | ||
| 4. Restricting Data | |||
| 1. Using WHERE Clause.mp4 | 37.59 MB | ||
| 1. Using WHERE Clause.srt | 5.04 KB | ||
| 10. Section 3 Quiz.html | 162 B | ||
| 2. Comparison Operators.mp4 | 58.2 MB | ||
| 2. Comparison Operators.srt | 6.96 KB | ||
| 3. BETWEEN … AND Operator.mp4 | 50.36 MB | ||
| 3. BETWEEN … AND Operator.srt | 6.13 KB | ||
| 4. IN Operator.mp4 | 75.69 MB | ||
| 4. IN Operator.srt | 12.43 KB | ||
| 5. LIKE Operator.mp4 | 110.62 MB | ||
| 5. LIKE Operator.srt | 13.37 KB | ||
| 6. IS NULL Operator.mp4 | 46.94 MB | ||
| 6. IS NULL Operator.srt | 5.87 KB | ||
| 7. Logical Operators (AND, OR, NOT).mp4 | 116.74 MB | ||
| 7. Logical Operators (AND, OR, NOT).srt | 15.48 KB | ||
| 8. Rules of Precedence.mp4 | 62.86 MB | ||
| 8. Rules of Precedence.srt | 12.11 KB | ||
| 9. Quiz.html | 166 B | ||
| 5. Sorting Data | |||
| 1. ORDER BY Clause.mp4 | 140.05 MB | ||
| 1. ORDER BY Clause.srt | 17.38 KB | ||
| 2. ASC and DESC Operators.mp4 | 68.71 MB | ||
| 2. ASC and DESC Operators.srt | 11.7 KB | ||
| 3. NULLS FIRST and NULLS LAST Operators.mp4 | 34.15 MB | ||
| 3. NULLS FIRST and NULLS LAST Operators.srt | 5.01 KB | ||
| 4. ROWNUM & ROWID in SQL.mp4 | 99.72 MB | ||
| 4. ROWNUM & ROWID in SQL.srt | 14.15 KB | ||
| 5. Oracle FETCH Clause.mp4 | 80.04 MB | ||
| 5. Oracle FETCH Clause.srt | 14.46 KB | ||
| 6. Section 4 Quiz.html | 162 B | ||
| 6. Using Substitution Variables | |||
| 1. What is a Substitution Variable.mp4 | 105.32 MB | ||
| 1. What is a Substitution Variable.srt | 17.27 KB | ||
| 2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4 | 125.45 MB | ||
| 2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands.srt | 21.74 KB | ||
| 3. ACCEPT and PROMPT Commands.mp4 | 57.67 MB | ||
| 3. ACCEPT and PROMPT Commands.srt | 9.07 KB | ||
| 4. SET VERIFY ON SET VERIFY OFF Commands.mp4 | 51.89 MB | ||
| 4. SET VERIFY ON SET VERIFY OFF Commands.srt | 9.35 KB | ||
| 7. Single-Row Functions | |||
| 1. Single Row Functions.mp4 | 110.94 MB | ||
| 1. Single Row Functions.srt | 14.55 KB | ||
| 10. Date Functions & Arithmetic Operations on Dates.mp4 | 135.3 MB | ||
| 10. Date Functions & Arithmetic Operations on Dates.srt | 22 KB | ||
| 11. Date Manipulation Functions in SQL.mp4 | 147.3 MB | ||
| 11. Date Manipulation Functions in SQL.srt | 24.92 KB | ||
| 12. Section 5 Quiz.html | 162 B | ||
| 2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios.mp4 | 117.9 MB | ||
| 2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios.srt | 16.6 KB | ||
| 3. Character Functions - Character Manipulation Functios (Part 1).mp4 | 111.99 MB | ||
| 3. Character Functions - Character Manipulation Functios (Part 1).srt | 15.29 KB | ||
| 4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp4 | 69.43 MB | ||
| 4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function).srt | 11.91 KB | ||
| 5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4 | 107.7 MB | ||
| 5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).srt | 25.16 KB | ||
| 6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4 | 82.76 MB | ||
| 6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).srt | 14.87 KB | ||
| 7. Numeric Functions.mp4 | 115.12 MB | ||
| 7. Numeric Functions.srt | 18.99 KB | ||
| 7.1 Oracle Numeric Functions.html | 104 B | ||
| 8. Nested Functions.mp4 | 101.38 MB | ||
| 8. Nested Functions.srt | 19.53 KB | ||
| 9. Date Values & Date Formats in Oracle.mp4 | 231.13 MB | ||
| 9. Date Values & Date Formats in Oracle.srt | 30.66 KB | ||
| 8. Conversion Functions | |||
| 1. Conversion Functions.mp4 | 90.06 MB | ||
| 1. Conversion Functions.srt | 14.14 KB | ||
| 2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4 | 132.29 MB | ||
| 2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).srt | 21.05 KB | ||
| 3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4 | 120.37 MB | ||
| 3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).srt | 20.96 KB | ||
| 4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4 | 142.26 MB | ||
| 4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.srt | 26.15 KB | ||
| 5. Section 6 Quiz.html | 162 B | ||
| 9. Conditional Expressions | |||
| 1. Oracle Conditional Expressions CASE Expressions.mp4 | 172.69 MB | ||
| 1. Oracle Conditional Expressions CASE Expressions.mp4.vtx | 792.76 KB | ||
| 1. Oracle Conditional Expressions CASE Expressions.srt | 29.38 KB | ||
| 2. Oracle Conditional Expressions DECODE Function.mp4 | 63.2 MB | ||
| 2. Oracle Conditional Expressions DECODE Function.srt | 12.55 KB | ||
| 3. Section 7 Quiz.html | 162 B |

Description
★ Last Course Updates:
✔ (Jan, 2021): 3-Real SQL(200+ High-Quality Questions) Certification Exam Samples are added!
✔ (Dec, 2020): New Lectures and Quiz Questions are added!
✔ (Nov, 2020): English Closed-Captions are added!
Important Notice: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL.
Are you a student ready to learn SQL for your lessons?
Do you want to get a better job?
Are you bored with watching a lot of stuff, but could not learn anything?
Do you think you know SQL, but you cannot write SQL codes?
Are you looking for a really professional course?
Then this is the course you are looking for.
You have come to the right place!
In this course, all the subjects are explained in a professional order.
If you are new to SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects.
After completing this course, you will learn all that you need to know. If you don’t see something in this course, it means you really don’t need to know it for now.
Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.
So come on, what are you waiting for?
Get this course, and go get a better job!
Benefits of Taking This SQL Course:
Knowing SQL can get you a better job or improve the one you have and it can earn you $80-100k+ in the IT Industry. It’s a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, this is why it’s so popular and backed by Oracle.
This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL codes easily and thinking analytically against the problem in your company.
Student Reviews Prove This Course’s Worth:
Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.
Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high-quality audio/video.
Check out all of the great reviews in the review section … a lot of happy students
Important Notice:
Knowing SQL is “mandatory” for any IT Professionals and having good SQL knowledge will be a “GREAT PLUS” for you!
If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you!
So let’s do this! I’ll see you in the first lecture!
Who this course is for:
Anyone willing to step into the software development career!
Anyone dreaming to get a well-paid SQL Development Job!
Anyone planning to Pass the Oracle 1Z0-071 (OCA) exam!
Anyone who wants to Become an in-demand SQL Professional!
Requirements
Nothing more than a working computer; all PC, Mac or Linux, etc. users are all welcome.
No previous programming experience is required!
No paid tools are required!
Last Updated 1/2021
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 503.7 MB | freecoursewb | 6 days | 20 | 11 | |
| 784.3 MB | freecoursewb | 6 days | 18 | 6 | |
| 2.2 GB | freecoursewb | 6 days | 0 | 0 | |
| 3.7 GB | freecoursewb | 6 days | 0 | 0 | |
| 3.3 GB | freecoursewb | 6 days | 24 | 16 |
All Comments