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

  7. Single-Row Functions

   9. Date Values & Date Formats in Oracle.srt

   11. Date Manipulation Functions in SQL.srt

   8. Nested Functions.srt

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

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

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

   12. Section 5 Quiz.html

   10. Date Functions & Arithmetic Operations on Dates.mp4

   7. Numeric Functions.mp4

   1. Single Row Functions.mp4

   8. Nested Functions.mp4

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

  2. Software Download & Installation

   7. Option 2 Configuring and Using the SQL Developer.srt

   5. Option 2 Downloading And Installing Oracle Database.mp4

   3.1 Step 1 Download Oracle Virtual Box.html

   3.4 (Optional) Download Oracle's Virtual Machine (12c Release 2).html

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

   11. The Working Document.html

   12. Don't Forget to Leave a Rating!.html

   6. Option 2 Unlocking the HR Schema.srt

   10. SQL Statements Used in This Course.srt

   4. Option 1 How to Install the Virtual Box on Mac OS X.html

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

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

   10. SQL Statements Used in This Course.mp4

   6. Option 2 Unlocking the HR Schema.mp4

  18. Conclusion + Bonus

   3. Bonus Code Samples.pdf

   2. Where to next.html

   1. Conclusion.srt

   4.1 SQL Cheatsheet (Oracle Master).pdf

  8. Conversion Functions

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

   1. Conversion Functions.srt

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

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

  19. Appendix

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

   1.1 Oracle's Official Website.html

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

  14. Working with the Oracle SET Operators

   2.1 Retired Employees Tables Creation Codes.pdf

   4. INTERSECT Operator.srt

   8. Section 12 Quiz.html

   6. Matching Unmatched Queries in SET Operations.srt

   3. UNION and UNION ALL Operators.mp4

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

   6. Matching Unmatched Queries in SET Operations.mp4

  16. Data Definition Language (DDL) Statements

   9. Section 14 Quiz.html

   2. Naming Rules.srt

   4. ALTER TABLE Statement.srt

   6. TRUNCATE TABLE Statement.srt

   8. RENAME Statement.srt

   7. COMMENT Statement.mp4

   6. TRUNCATE TABLE Statement.mp4

   2. Naming Rules.mp4

  9. Conditional Expressions

   1. Oracle Conditional Expressions CASE Expressions.srt

   2. Oracle Conditional Expressions DECODE Function.srt

   2. Oracle Conditional Expressions DECODE Function.mp4

  1. Database Concepts

   10.1 HR-Schema-Relationship.png

   5.1 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam [04.03.2017].pdf

   5.3 Oracle-Database-12c-Database-SQL-1Z0-071-Exam [2016-07-12].pdf

   6. What is a Relational Database (RDBMS).srt

   10. The Sample (HR) Schema Used in This Course.srt

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

   3. What is a Table.srt

   9. Introduction to Database Objects.mp4

   10. The Sample (HR) Schema Used in This Course.mp4

   2. Why Oracle Database.mp4

   11. What is SQL.mp4

   7. Entity Relationship Logic in Databases.mp4

   5.4 SQL Cheatsheet (Oracle Master).pdf

  13. Using Subqueries

   4. Multiple Column Subqueries.srt

   6. SCALAR Subqueries.srt

   8. EXISTS Operator & Semijoins.srt

   1. Using Subqueries.srt

   10. Section 11 Quiz.html

   2. Single Row Subqueries.mp4

   3. Multiple Row Subqueries.mp4

   8. EXISTS Operator & Semijoins.mp4

   1. Using Subqueries.mp4

  12. Joining Multiple Tables

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

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

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

   12. LEFT OUTER JOIN (LEFT JOIN).srt

   5. Handling Ambiguous Column Names.srt

   3. Natural Join.srt

   11. OUTER JOINS.srt

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

   4. Join with the USING Clause.srt

   20. Which Join Type Should You Use.srt

   2. Creating a Join.srt

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

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

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

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

   3. Natural Join.mp4

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

   11. OUTER JOINS.mp4

   9. Self Join.mp4

   4. Join with the USING Clause.mp4

   2. Creating a Join.mp4

   20. Which Join Type Should You Use.mp4

  3. Retrieving Data

   8. CODE Using SELECT Statements.html

   5. SQL Statement Basics.srt

   11. Quote (Q) Operator.srt

   12. DISTINCT and UNIQUE Operator.srt

   1. Oracle Data Types.srt

   6. Oracle Error Messages.srt

   2. What is a NULL Value.srt

   5. SQL Statement Basics.mp4

   13. Concatenation Operators.mp4

   2. What is a NULL Value.mp4

   9. Using Column Aliases.mp4

   4. INFORMATION Command.mp4

   6. Oracle Error Messages.mp4

  6. Using Substitution Variables

   1. What is a Substitution Variable.srt

   3. ACCEPT and PROMPT Commands.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).srt

   4. Nested Group Functions.srt

   1. GROUP BY Clause (Part 1).mp4

   3. HAVING Clause.mp4

  17. Creating Constraints

   7. Section 15 Quiz.html

   2. NOT NULL Constraint.srt

   4. PRIMARY KEY Constraint.srt

   6. CHECK Constraint.srt

   4. PRIMARY KEY Constraint.mp4

   1. Creating Constraints.mp4

  4. Restricting Data

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

   4. IN Operator.srt

   10. Section 3 Quiz.html

   3. BETWEEN … AND Operator.srt

   1. Using WHERE Clause.srt

   5. LIKE Operator.mp4

   8. Rules of Precedence.mp4

   3. BETWEEN … AND Operator.mp4

   1. Using WHERE Clause.mp4

  5. Sorting Data

   5. Oracle FETCH Clause.srt

   2. ASC and DESC Operators.srt

   3. NULLS FIRST and NULLS LAST Operators.srt

   4. ROWNUM & ROWID in SQL.mp4

   2. ASC and DESC Operators.mp4

  10. Group Functions

   1. Group Functions.srt

   5. MIN Function.srt

   8. Overview Of Group Functions.srt

   9. Section 8 Quiz.html

   2. AVG Function.mp4

   3. COUNT Function.mp4

   5. MIN Function.mp4

   6. SUM Function.mp4

  15. Data Manipulation Language (DML) Statements

   1. Data Manipulation Language (DML).srt

   3. INSERT Statement (Part 2).srt

   5. DELETE Statement.srt

   7. COMMIT and ROLLBACK Statements.srt

   9. FOR UPDATE Statement.srt

   4. UPDATE Statement.mp4

   9. FOR UPDATE Statement.mp4

   6. Transaction Control Statements.mp4

   8. SAVEPOINT Statement.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

 [TGx]Downloaded from torrentgalaxy.to .txt