[TutsNode.com] - The Complete Oracle SQL Bootcamp (2021)

  2. Software Download & Installation

   -Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema.pdf

   6. Option 2 Configuring and Using the SQL Developer-it_IT.srt

   6. Option 2 Configuring and Using the SQL Developer-en_US.srt

   3. Option 1 Having the Database with the Oracle Virtual Box-th_TH.srt

   4. Option 2 Downloading And Installing Oracle Database-pl_PL.srt

   3. External URLs.txt

   Don't Forget to Leave a Rating!.html

   Option 3 Warning About Oracle Live SQL Limitations.html

   7. Option 3 Using Oracle Live SQL-th_TH.srt

   3. Option 1 Having the Database with the Oracle Virtual Box-ro_RO.srt

   3. Option 1 Having the Database with the Oracle Virtual Box-id_ID.srt

   2. Which Option to Choose to Have a Database-it_IT.srt

   2. Which Option to Choose to Have a Database-pl_PL.srt

   2. Which Option to Choose to Have a Database-en_US.srt

   1. About the Database Installation-th_TH.srt

   5. Option 2 Unlocking the HR Schema-it_IT.srt

   5. Option 2 Unlocking the HR Schema-en_US.srt

   7. Option 3 Using Oracle Live SQL-it_IT.srt

   7. Option 3 Using Oracle Live SQL-en_US.srt

   8. SQL Statements Used in This Course-pl_PL.srt

   1. About the Database Installation-id_ID.srt

   1. About the Database Installation-it_IT.srt

   1. About the Database Installation-en_US.srt

   3. Option 1 Having the Database with the Oracle Virtual Box.mp4

   2. Which Option to Choose to Have a Database.mp4

   7. Option 3 Using Oracle Live SQL.mp4

  1. Database Concepts

   Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html

   2. Why Oracle Database-th_TH.srt

   9. The Sample (HR) Schema Used in This Course-th_TH.srt

   8. Introduction to Database Objects-en_US.srt

   4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-th_TH.srt

   1. What is a Database-pl_PL.srt

   2. Why Oracle Database-ro_RO.srt

   5. What is a Relational Database (RDBMS)-it_IT.srt

   5. What is a Relational Database (RDBMS)-pl_PL.srt

   9. The Sample (HR) Schema Used in This Course-ro_RO.srt

   1. What is a Database-en_US.srt

   9. The Sample (HR) Schema Used in This Course-id_ID.srt

   5. What is a Relational Database (RDBMS)-en_US.srt

   9. The Sample (HR) Schema Used in This Course-en_US.srt

   10. What is SQL-ro_RO.srt

   4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-ro_RO.srt

   4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-id_ID.srt

   4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)-it_IT.srt

   10. What is SQL-en_US.srt

   6. Entity Relationship Logic in Databases-ro_RO.srt

   6. Entity Relationship Logic in Databases-id_ID.srt

   6. Entity Relationship Logic in Databases-en_US.srt

   3. What is a Table-pl_PL.srt

   3. What is a Table-en_US.srt

   7. What is Pluggable Database-en_US.srt

   5. What is a Relational Database (RDBMS).mp4

   1. What is a Database.mp4

   10. What is SQL.mp4

   6. Entity Relationship Logic in Databases.mp4

   7. What is Pluggable Database.mp4

  7. Single-Row Functions

   9. Date Values & Date Formats in Oracle-it_IT.srt

   9. Date Values & Date Formats in Oracle.mp4

   11. Date Manipulation Functions in SQL-it_IT.srt

   5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)-en_US.srt

   11. Date Manipulation Functions in SQL-en_US.srt

   10. Date Functions & Arithmetic Operations on Dates-pl_PL.srt

   8. Nested Functions-it_IT.srt

   7. Numeric Functions-pl_PL.srt

   8. Nested Functions-pl_PL.srt

   2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios-it_IT.srt

   2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios-en_US.srt

   3. Character Functions - Character Manipulation Functios (Part 1)-it_IT.srt

   6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)-it_IT.srt

   1. Single Row Functions-pl_PL.srt

   1. Single Row Functions-en_US.srt

   4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function)-en_US.srt

   4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function)-pl_PL.srt

   10. Date Functions & Arithmetic Operations on Dates.mp4

   6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4

   1. Single Row Functions.mp4

   3. Character Functions - Character Manipulation Functios (Part 1).mp4

   7. Numeric Functions.mp4

  13. Using Subqueries

   3. Multiple Row Subqueries-pl_PL.srt

   3. Multiple Row Subqueries-en_US.srt

   4. Multiple Column Subqueries-pl_PL.srt

   7. Correlated Subqueries-it_IT.srt

   7. Correlated Subqueries-pl_PL.srt

   7. Correlated Subqueries-en_US.srt

   2. Single Row Subqueries-pl_PL.srt

   8. EXISTS Operator & Semijoins-pl_PL.srt

   8. EXISTS Operator & Semijoins-en_US.srt

   5. Using Subqueries as a Table-pl_PL.srt

   1. Using Subqueries-it_IT.srt

   1. Using Subqueries-en_US.srt

   9. NOT EXISTS Operator-pl_PL.srt

   2. Single Row Subqueries.mp4

   7. Correlated Subqueries.mp4

   5. Using Subqueries as a Table.mp4

   1. Using Subqueries.mp4

   9. NOT EXISTS Operator.mp4

  18. Appendix

   2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-th_TH.srt

   2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-ro_RO.srt

   2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-pl_PL.srt

   1. Appendix 1 Oracle Database 12c Installation into Your Computer-ro_RO.srt

   2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c-en_US.srt

   1. Appendix 1 Oracle Database 12c Installation into Your Computer-pl_PL.srt

   Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c.html

   1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp4

  16. Data Manipulation Language (DML) Statements

   11. MERGE Statement-it_IT.srt

   3. INSERT Statement (Part 2)-it_IT.srt

   3. INSERT Statement (Part 2)-pl_PL.srt

   12. (TCL) Transaction Control Statements-en_US.srt

   2. INSERT Statement (Part 1)-pl_PL.srt

   6. Conditional INSERT ALL Statements-it_IT.srt

   6. Conditional INSERT ALL Statements-en_US.srt

   9. UPDATE Statement-it_IT.srt

   5. Unconditional Insert Statements (INSERT ALL Statements)-it_IT.srt

   5. Unconditional Insert Statements (INSERT ALL Statements)-pl_PL.srt

   8. Pivoting Insert-it_IT.srt

   8. Pivoting Insert-en_US.srt

   13. COMMIT and ROLLBACK Statements-th_TH.srt

   7. Conditional INSERT FIRST Statements-it_IT.srt

   7. Conditional INSERT FIRST Statements-en_US.srt

   1. Data Manipulation Language (DML)-pl_PL.srt

   10. DELETE Statement-it_IT.srt

   10. DELETE Statement-en_US.srt

   4. Multitable Insert Statements-pl_PL.srt

   SAVEPOINT-Statement.sql

   15. FOR UPDATE Statement-th_TH.srt

   12. (TCL) Transaction Control Statements-it_IT.srt

   12. (TCL) Transaction Control Statements-ro_RO.srt

   13. COMMIT and ROLLBACK Statements-id_ID.srt

   13. COMMIT and ROLLBACK Statements-pl_PL.srt

   14. SAVEPOINT Statement-en_US.srt

   14. SAVEPOINT Statement-it_IT.srt

   14. SAVEPOINT Statement-ro_RO.srt

   15. FOR UPDATE Statement-id_ID.srt

   15. FOR UPDATE Statement-pl_PL.srt

   6. Conditional INSERT ALL Statements.mp4

   14. SAVEPOINT Statement.mp4

   13. COMMIT and ROLLBACK Statements.mp4

   9. UPDATE Statement.mp4

   10. DELETE Statement.mp4

   1. Data Manipulation Language (DML).mp4

   4. Multitable Insert Statements.mp4

  19. Conclusion + Reward!

   Bonus Lecture.html

   1. Conclusion-th_TH.srt

   1. Conclusion-id_ID.srt

   1. Conclusion-pl_PL.srt

   1. Conclusion.mp4

  9. Conditional Expressions

   1. Oracle Conditional Expressions CASE Expressions-pl_PL.srt

   2. Oracle Conditional Expressions DECODE Function-it_IT.srt

   2. Oracle Conditional Expressions DECODE Function-en_US.srt

   2. Oracle Conditional Expressions DECODE Function.mp4

  8. Conversion Functions

   4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions-pl_PL.srt

   2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)-it_IT.srt

   2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)-pl_PL.srt

   2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)-en_US.srt

   1. Conversion Functions-it_IT.srt

   1. Conversion Functions-en_US.srt

   3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4

   1. Conversion Functions.mp4

  3. Retrieving Data

   5. SQL Statement Basics-it_IT.srt

   CODE Using Column Aliases.html

   5. SQL Statement Basics-en_US.srt

   12. Arithmetic Expressions and NULL Values-en_US.srt

   9. Quote (Q) Operator-it_IT.srt

   9. Quote (Q) Operator-pl_PL.srt

   4. INFORMATION Command-en_US.srt

   10. DISTINCT and UNIQUE Operator-it_IT.srt

   11. Concatenation Operators-en_US.srt

   1. Oracle Data Types-it_IT.srt

   8. Using Column Aliases-it_IT.srt

   8. Using Column Aliases-en_US.srt

   1. Oracle Data Types-en_US.srt

   6. Oracle Error Messages-it_IT.srt

   7. Using SELECT Statements-it_IT.srt

   7. Using SELECT Statements-pl_PL.srt

   2. What is a NULL Value-it_IT.srt

   3. DESCRIBE Command-it_IT.srt

   3. DESCRIBE Command-pl_PL.srt

   12. Arithmetic Expressions and NULL Values.mp4

   2. What is a NULL Value.mp4

   10. DISTINCT and UNIQUE Operator.mp4

   3. DESCRIBE Command.mp4

   4. INFORMATION Command.mp4

   7. Using SELECT Statements.mp4

  15. Data Definition Language (DDL) Statements

   5. ALTER TABLE Statement-pl_PL.srt

   4. CREATE TABLE AS SELECT (CTAS) Statement in Oracle-it_IT.srt

   2. Naming Rules & Naming Conventions in Oracle-it_IT.srt

   4. CREATE TABLE AS SELECT (CTAS) Statement in Oracle-en_US.srt

   9. TRUNCATE TABLE Statement-it_IT.srt

   9. TRUNCATE TABLE Statement-en_US.srt

   6. Marking Columns Unused (Using The SET UNUSED Clause)-it_IT.srt

   6. Marking Columns Unused (Using The SET UNUSED Clause)-pl_PL.srt

   3. CREATE TABLE Statement-pl_PL.srt

   8. DROP TABLE Statement-it_IT.srt

   6. Marking Columns Unused (Using The SET UNUSED Clause)-en_US.srt

   8. DROP TABLE Statement-en_US.srt

   7. READ-ONLY Tables in SQL-pl_PL.srt

   11. RENAME Statement-it_IT.srt

   11. RENAME Statement-en_US.srt

   1. Data Definition Language (DDL)-pl_PL.srt

   5. ALTER TABLE Statement.mp4

   2. Naming Rules & Naming Conventions in Oracle.mp4

   9. TRUNCATE TABLE Statement.mp4

   3. CREATE TABLE Statement.mp4

   7. READ-ONLY Tables in SQL.mp4

   1. Data Definition Language (DDL).mp4

  12. Joining Multiple Tables

   21. Entity-Relationship Models in DBMS - How to Use Them with Joins-it_IT.srt

   15. Cross Join (Cartesian Product Cross Product)-pl_PL.srt

   15. Cross Join (Cartesian Product Cross Product)-en_US.srt

   17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)-pl_PL.srt

   15. Cross Join (Cartesian Product Cross Product).mp4

   19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins-it_IT.srt

   16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)-it_IT.srt

   16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)-pl_PL.srt

   10. Non-Equijoins (Joining Unequal Tables)-it_IT.srt

   12. LEFT OUTER JOIN (LEFT JOIN)-it_IT.srt

   10. Non-Equijoins (Joining Unequal Tables)-en_US.srt

   12. LEFT OUTER JOIN (LEFT JOIN)-en_US.srt

   7. Multiple Join Operations-pl_PL.srt

   5. Handling Ambiguous Column Names-it_IT.srt

   18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)-pl_PL.srt

   5. Handling Ambiguous Column Names-en_US.srt

   18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)-en_US.srt

   3. Natural Join-en_US.srt

   13. RIGHT OUTER JOIN (RIGHT JOIN)-pl_PL.srt

   11. OUTER JOINS-pl_PL.srt

   11. OUTER JOINS-en_US.srt

   1. What is a Join & Oracle SQL Join Types-pl_PL.srt

   1. What is a Join & Oracle SQL Join Types-en_US.srt

   6. Inner Join & Join with the ON Clause-pl_PL.srt

   9. Self Join-it_IT.srt

   4. Join with the USING Clause-it_IT.srt

   9. Self Join-en_US.srt

   NonEquiJoins-Source-Code.sql

   20. Which Join Type Should You Use-pl_PL.srt

   14. FULL OUTER JOIN (FULL JOIN)-pl_PL.srt

   14. FULL OUTER JOIN (FULL JOIN)-en_US.srt

   8. Restricting Joins-en_US.srt

   2. Creating a Join-en_US.srt

   16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4

   10. Non-Equijoins (Joining Unequal Tables).mp4

   21. Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4

   18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4

   12. LEFT OUTER JOIN (LEFT JOIN).mp4

   5. Handling Ambiguous Column Names.mp4

   9. Self Join.mp4

   4. Join with the USING Clause.mp4

   8. Restricting Joins.mp4

   20. Which Join Type Should You Use.mp4

  6. Using Substitution Variables

   2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands-pl_PL.srt

   1. What is a Substitution Variable-en_US.srt

   1. What is a Substitution Variable-pl_PL.srt

   3. ACCEPT and PROMPT Commands-en_US.srt

   3. ACCEPT and PROMPT Commands-pl_PL.srt

   4. SET VERIFY ON SET VERIFY OFF Commands-en_US.srt

   1. What is a Substitution Variable.mp4

   4. SET VERIFY ON SET VERIFY OFF Commands.mp4

  11. Grouping Data

   1. GROUP BY Clause (Part 1)-pl_PL.srt

   2. GROUP BY Clause (Part 2)-it_IT.srt

   2. GROUP BY Clause (Part 2)-en_US.srt

   3. HAVING Clause-pl_PL.srt

   4. Nested Group Functions-it_IT.srt

   4. Nested Group Functions-en_US.srt

   1. GROUP BY Clause (Part 1).mp4

   4. Nested Group Functions.mp4

  14. Working with the Oracle SET Operators

   1. Introduction to SET Operators in Oracle SQL-pl_PL.srt

   2. UNION and UNION ALL Operators-it_IT.srt

   2. UNION and UNION ALL Operators-en_US.srt

   7. Combining Multiple Queries Using the SET Operators-en_US.srt

   6. Using the ORDER BY Clause with SET Operators-en_US.srt

   5. Matching Unmatched Queries in SET Operations-pl_PL.srt

   7. Combining Multiple Queries Using the SET Operators-pl_PL.srt

   4. MINUS Operator-pl_PL.srt

   4. MINUS Operator-en_US.srt

   3. INTERSECT Operator-pl_PL.srt

   Source-Code-Combining-Multiple-Queries-Using-the-SET-Operators.sql

   1. Introduction to SET Operators in Oracle SQL.mp4

   6. Using the ORDER BY Clause with SET Operators.mp4

   5. Matching Unmatched Queries in SET Operations.mp4

   3. INTERSECT Operator.mp4

  5. Sorting Data

   1. ORDER BY Clause-en_US.srt

   5. Oracle FETCH Clause-pl_PL.srt

   4. ROWNUM & ROWID in SQL-en_US.srt

   5. Oracle FETCH Clause-en_US.srt

   2. ASC and DESC Operators-it_IT.srt

   2. ASC and DESC Operators-en_US.srt

   3. NULLS FIRST and NULLS LAST Operators-pl_PL.srt

   3. NULLS FIRST and NULLS LAST Operators-en_US.srt

   5. Oracle FETCH Clause.mp4

   3. NULLS FIRST and NULLS LAST Operators.mp4

  4. Restricting Data

   7. Logical Operators (AND, OR, NOT)-it_IT.srt

   5. LIKE Operator-it_IT.srt

   5. LIKE Operator-pl_PL.srt

   8. Rules of Precedence-it_IT.srt

   4. IN Operator-en_US.srt

   8. Rules of Precedence-en_US.srt

   2. Comparison Operators-en_US.srt

   3. BETWEEN ... AND Operator-pl_PL.srt

   3. BETWEEN ... AND Operator-en_US.srt

   6. IS NULL Operator-it_IT.srt

   1. Using WHERE Clause-en_US.srt

   1. Using WHERE Clause-it_IT.srt

   5. LIKE Operator.mp4

   4. IN Operator.mp4

   3. BETWEEN ... AND Operator.mp4

   1. Using WHERE Clause.mp4

  10. Group Functions

   7. LISTAGG Function-pl_PL.srt

   1. Group Functions-it_IT.srt

   1. Group Functions-en_US.srt

   3. COUNT Function-pl_PL.srt

   8. Overview Of Group Functions-pl_PL.srt

   4. MAX Function-it_IT.srt

   4. MAX Function-pl_PL.srt

   4. MAX Function-en_US.srt

   6. SUM Function-it_IT.srt

   6. SUM Function-pl_PL.srt

   1. Group Functions.mp4

   4. MAX Function.mp4

   3. COUNT Function.mp4

   8. Overview Of Group Functions.mp4

  17. Creating Constraints

   2. NOT NULL Constraint-th_TH.srt

   4. PRIMARY KEY Constraint-th_TH.srt

   6. CHECK Constraint-th_TH.srt

   1. Creating Constraints-id_ID.srt

   1. Creating Constraints-pl_PL.srt

   2. NOT NULL Constraint-en_US.srt

   2. NOT NULL Constraint-it_IT.srt

   2. NOT NULL Constraint-ro_RO.srt

   3. UNIQUE Constraint-id_ID.srt

   3. UNIQUE Constraint-pl_PL.srt

   4. PRIMARY KEY Constraint-en_US.srt

   4. PRIMARY KEY Constraint-it_IT.srt

   4. PRIMARY KEY Constraint-ro_RO.srt

   5. FOREIGN KEY Constraint-id_ID.srt

   5. FOREIGN KEY Constraint-pl_PL.srt

   6. CHECK Constraint-en_US.srt

   6. CHECK Constraint-it_IT.srt

   6. CHECK Constraint-ro_RO.srt

   3. UNIQUE Constraint.mp4

   2. NOT NULL Constraint.mp4

   1. Creating Constraints.mp4

 TutsNode.com.txt

 .pad

  1

  3

  5

  7

  9

  11

  13

  15

  17

  19

  21

  23

  25

  27

  29

  31

  33

  35

  37

  39

  41

  43

  45

  47

  49

  51

  53

  55

  57

  59

  61

  63

  65

  67

  69

  71

  73

  75

  77

  79

  81

  83

  85

  87

  89

  91

  93

  95

  97

  99

  101

  103

  105

  107

  109

  111

  113

  115

  117

  119

  121

  123

  125

  127

  129

  131

  133

  135

  137

  139

  141

  143

  145

 [TGx]Downloaded from torrentgalaxy.to .txt